🗃️Read Replica
Also known as Replica, Read-Only Replica
A copy of a database that only answers reads. It takes load off the main one.
Think of it like
Think of it like extra menus on the tables. All can read one, but only the cook changes it.
Example
Jack's nightly sales report used to slow the shop down. Now it runs on a read replica, and shoppers never notice.
Why it matters
Most apps read far more than they write. Replicas let reads grow without slowing the writes.
Definition
Common mistake
Key takeaways
- 1Reads only. Writes still go to the primary.
- 2Spreads the load. Reports run on the copy.
- 3A little behind. Replication lag is real.