I’m planning to implement Percona XtraDB Cluster, and was wondering if it’s possible to synchronise two clusters. Example:
Nodes in Cluster A (production environment): A1, A2, A3, A4
Nodes in Cluster B (disaster recovery environment): B1, B2, B3, B4
Ideally, both clusters would be fully synchronised in real-time. My current ideal would be to set up one node in each cluster to use MySQL replication (i.e. A1 -> B1) which would then be populated to the rest of Cluster B.
In a disaster recovery situation, the replication would be broken, making Cluster B “live”.
Would this kind of setup work?