Database Replication | Database Interview | Skill-Lync Resources
Medium Database Systems Distributed Databases

What is database replication and what are the different types?

Answer

Replication copies data across multiple database servers. Types: Master-Slave (writes to master, reads from slaves - read scaling), Master-Master (writes to any master, complex conflict resolution), Synchronous (waits for replicas - consistency but slower), Asynchronous (doesn't wait - faster but potential data loss). Benefits: read scaling, high availability, geographic distribution. Challenges: replication lag, conflict resolution, consistency guarantees.

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

Database Administrator Backend Developer Systems Engineer