Skip to Content

Copy data across nodes for durability and read-scaling.

Data Flow (master-slave)

   Master
     |
     v  (async log shipping)
  +--------+--------+--------+
  |slave_0|slave_1|slave_2|          (read replicas)
  +--------+--------+--------+

Two flavours

Pitfalls

Mitigation

Analogy

A library where the original book is at HQ and branches hold photocopies: branches lag behind HQ by a few hours.

Interview tip: Mention replication lag explicitly; it’s the cause of half the “data loss” production incidents.

Advertisement