57.15 DB Replication

Replication is keeping multiple copies of data at geographically distributed nodes. It helps achieve availability, scalability, and performance.
If frequent Write operations are in the DB, replication becomes complex, i.e., consistency becomes an issue.

Replication approaches

Two types of replication approaches:



Synchronous versus asynchronous replication[1]

Replication Models

There are various replication models are also there:

Primary-Secondary replication

Replication methods

There are many different replication methods in primary-secondary replication:

Statement based replication

Write-ahead log (WAL) shipping

To be continued...

  1. https://www.educative.io/courses/grokking-modern-system-design-interview-for-engineers-managers/data-replication ↩︎

Thoughts 🤔 by Soumendra Kumar Sahoo is licensed under CC BY 4.0