How to repair a dual master replication
In a dual master replication, you can easily have issues if you do it manually without a cluster or something else.
There is not much difference between repairing a master/slave and a master/master replication. However, you should take care of one evident thing: when you're working on an issue on Master 2 for example, you absolutely need to stop the slave replication on Master1!
The advantage of doing this is simple; if you make mistakes on Master2, they won't be replicated on Master1. This helps you to keep your Master2 node as close as Master1 if you can correctly repair it. However, if you fail, you can recreate from a dump of your Master2 without impacting Master1 data.
That's why, in a dual master replication, ...
Get MariaDB High Performance now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
