Galera the synchronous Master-Master replication is quite popular.
It is used by Percona XtraDB Cluster, MariaDB Galera Cluster and even patched MySQL binaries exist.
Quite often you want to add a slave to a Galera Cluster. This is going to work quite well.
All you need is at least configure
server_id on the designated Masters
and attach your Slave.
Even you can use traditional (non GTID) replication. Using non GTID replication is a hassle. As you need to search for the right offset on the new Master to attach your Slave on.
Using GTID promises to be easier. As you simply switch to the new Master and the replication framework finds the new position based on the GTiD automatically.
As a fact we have two GTID[Read more...]