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.
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