Today’s blog post is related again to MySQL Group Replication.
By default MySQL Group Replication runs in Single-Primary mode. And it’s the best option and the option you should use.
But sometimes it might happen that in very specific cases you would like to run you MGR Cluster in Multi-Primary mode: writing simultaneously on all the nodes member of the Group.
It’s of course feasible but you need to make some extra verification as not all workload are compatible with this behavior of the cluster.
Requirements
The requirements are the same as those for using MGR in Single-Primary mode:
- InnoDB Storage Engine
- Primary Keys
- IPv4 Network
- Binary Log Active
- Slave Updates Logged
- Binary …