Master-replica replication allows us to have a simple setup for reads and writes at the potential risk of being unable to write to the master database. Master-master replication allows us to be able to read and write to the database even if one of the masters fail. However, the complexity of maintaining a consistent state across all the masters and the possible performance penalty can mean that it is not the ideal choice in all circumstances.
The failover cluster replication tries to take the middle ground by providing features of both replication strategies. It can be explained as follows:
- We take a cluster of databases.
- A database is assigned as the master depending on the master selection strategy used, which ...