How does Database Replication actually work? Database replication is basically keeping copies of the same database on multiple servers. Instead of relying on one database for everything, changes can be replicated to other databases, allowing the system to handle more reads and continue working if one server fails. But replication introduces its own problems like replication lag, where a replica hasn't received the latest changes yet, and the question of whether data should be replicated synchronously or asynchronously. There are also different replication approaches, such as primary-replica and multi-primary replication, each with different trade-offs. https://www.frontendtechlead.com/learn-system-design/database-replication @CTBEsoftwareengineers
1
