You may have noticed two issues with the master-replica setup:
- The master is used extensively for database writes, and hence is under constant duress
- The issue of reads has been solved with replicas but the single point of failure for writes is still present
Master-master replication tries to solve these issues by making every database a master. It can be explained as follows:
- We take a cluster of databases:
- We designate every database as a master: