Bi-directional replication between 2 XtraDB clusters

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Good morning, does anyone use in production scheme below:

ClusterA(3 nodes) <-Native MySQL replication->ClusterB(3 nodes).

As I understand slave process will be started on some node in cluster and in case if node goes down we can use auto-position to start slave on other node in cluster without any problems. Basically I would like to use such scheme to replicate data between datacenters.

Thanks in advance!

2

Hi,
That’s of course possible, but many problems to be expected I am afraid. The first one is that you are simply implementing async master<->master topology here, and if it happens that writes go to both clusters at a same time, data may go out of sync. On top of that is that when MySQL’s GTID is used, in some cases nodes may end up with inconsistent sequences making changing async masters impossible - look for bugs related to GTID and PXC/Galera.
If possible, I’d consider using Galera homogenous system. If WAN link is too slow/unstable though, I’d be very careful and set the second cluster as stand-by/read only.