Issues in Multi Leader Replication
We'll cover the following...
Some of the problems with multi-leader replication include:
Copies of the same data being modified concurrently in different datacenters requiring conflict resolution.
Writes being lost from a data center that experiences permanent failure if they haven’t been replicated to other leaders.
In case of databases, auto incrementing keys, triggers, and integrity constraints can be problematic to handle.
Handling Conflicts
One of the major problems of multileader replication is conflicting writes. Suppose you are editing a Google document simultaneously with a colleague sitting across the globe. One of you changes the first heading in the document from A to B and the other changes the same heading from A to C respectively. The changes by the two users are committed at the local leader in the nearest data center to each of the users. Unbeknownst to the parties, ...