Using master-master for MySQL? To be frankly we need to get rid of that architecture. We are skipping the active-active setup and show why master-master even for failover reasons is the wrong decision.
So why does a DBA thinks master-master is good for in a failover scenario?
- The recovered node does get his data automatically.
- You need not to use a backup for recovery.
Please remember: MySQL Replication is async
Again: MySQL Replication is async. Even the so called semi-sync Replication!
So following is quite likely.
See a nice master-master …[Read more...]