Database Replication | System Design Interview | Skill-Lync Resources
Easy System Design Database Design

What is database replication and why is it used?

Answer

Replication copies data across multiple database servers. Benefits: high availability (failover if primary fails), read scaling (distribute reads across replicas), data locality (replicas in different regions). Types: synchronous (waits for replicas, stronger consistency) vs asynchronous (faster, eventual consistency). Master-slave (writes to master only) vs master-master (writes to any). Challenges: replication lag, conflict resolution (multi-master). Most production databases use replication for availability.

Master These Concepts with IIT Certification
IIT Certified

Master These Concepts with IIT Certification

175+ hours of industry projects. Get placed at Bosch, Tata Motors, L&T and 500+ companies.

Relevant for Roles

Backend Developer Database Administrator DevOps Engineer