/
Data Replication 101

Data Replication 101

This page is outdated and no longer receives updates!

Basic Database Replication Strategies

There are two basic replication strategies, master-slave and master-master.

Master-Slave Replication

Master-slave is the easiest to design and implement because one database does all of the work and simply reports results to the slave database on some designated timing interval. In the event that the master dies, the slave takes over. The problem with the master-slave model is that the slave is idle until it is promoted to become the master. This model leaves half of the computer resources unused at all times.

Master-Master Replication

The master-master model is designed to address the unused resource problem. In the master-master model, both computer systems and both databases are working for users at the same time. In the event that a disaster were to occur, the remaining system would take over the entire load of the combined systems. The system would run at a slower speed until more resources could be added to th