Not the answer you need?
Register and ask your own question!

Bi-directional replication between 2 XtraDB clusters

Timur SolodovnikovTimur Solodovnikov EntrantCurrent User Role Beginner
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!

Comments

  • przemekprzemek Percona Support Engineer Percona Staff Role
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.