Data Replication - Interview Questions

What is Data Replication?

 key Concept

Data replication is the technique of storing copies of same data in multiple databases. Data replication improves the availability of applications.

What are different kinds of Data Replication?

 key Concept

There are two kinds of data replication.

Master-slave replication - In this kind of replication the master serves both read and write requests, and replicates the writes to one or more slaves. The slaves serve read requests only. If the master goes down, the system will continue to serve in read-only mode until the system promotes a slave to a master, or until a new master is provisioned.

Master-master replication - In this kind of replication multiple masters serve read and write requests. The writes are replicates to all master servers. The masters are fronted with a load balancer, and even if a master goes down the system will continue to serve read and write requests from the other masters.

 
Subscribe to our Questions

 

System Design - Interview Questions

Components of System Design
 
RECOMMENDED RESOURCES
Behaviorial Interview
Top resource to prepare for behaviorial and situational interview questions.

STAR Interview Example