The multi master plugin for MySQL is here “MySQL Group Replication“. It is a virtual synchronous solution for MySQL with conflict detection. It also supports automatic group membership management, failure detection and automatic distributed recovery.
With the introduction of this new feature there was a need to perform some good amount of testing as it involves complex functionalities like :
- Servers execute local transactions and broadcasts the update to the group.
- All servers in the group, even the sender, receive same transaction in the same order and check for conflicts.
- All servers, independently, decide to commit the transaction – no conflicts.
- A new node can join an existing group, so in this case we need distributed recovery to bring it at par with the other servers.
So a great deal[Read more...]