# Two Synchronised Percona XtraDB Clusters?

**URL:** <https://forums.percona.com/t/two-synchronised-percona-xtradb-clusters/2706>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [May 23, 2013, 2:44pm UTC](https://forums.percona.com/t/two-synchronised-percona-xtradb-clusters/2706 "2013-05-23T14:44:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![CraigWatson](https://avatars.discourse-cdn.com/v4/letter/c/ecae2f/32.png) [@CraigWatson](https://forums.percona.com/u/CraigWatson)\
**Post date:** [May 23, 2013, 2:44pm UTC](https://forums.percona.com/t/two-synchronised-percona-xtradb-clusters/2706/1 "2013-05-23T14:44:00Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![azigui](https://avatars.discourse-cdn.com/v4/letter/a/cab0a1/32.png) [@azigui](https://forums.percona.com/u/azigui)\
**Post date:** [May 28, 2013, 6:33am UTC](https://forums.percona.com/t/two-synchronised-percona-xtradb-clusters/2706/2 "2013-05-28T06:33:45Z")

</div>

Hi,

Are they on two datacenters ?  
Do you use the WAN network four your replication ?  
In this case you must use wsrep\_provider\_options parameters in your configuration (i.e evs.keepalived\_period, evs.suspect\_timeout,…)

Best regards,

Azigui

---

<div class="post-metadata">

**Author:** ![CraigWatson](https://avatars.discourse-cdn.com/v4/letter/c/ecae2f/32.png) [@CraigWatson](https://forums.percona.com/u/CraigWatson)\
**Post date:** [May 28, 2013, 8:13am UTC](https://forums.percona.com/t/two-synchronised-percona-xtradb-clusters/2706/3 "2013-05-28T08:13:53Z")

</div>

Hi Azigui,  
Yes, the two clusters would indeed be in two datacentres, linked via an IPsec VPN over a WAN.

Your suggestion seems to be to create one big cluster and split the nodes between two datacentres, with replication over a WAN. From the Percona documentation, I understand that cluster replication is as quick as replication to your slowest node, so our intra-cluster replication would basically be limited to the speed of the WAN. Is this correct?

My other concern is that Cluster B should be read-only until the time when we switch to our disaster recovery solution. We should also be able to fail-back to Cluster A when the outage is over.

Would a “read\_only” configuration line in my.cnf on the Cluster B nodes work (assuming we go with a two-cluster system as I described in my first post)?

Thanks,  
Craig

---

<div class="post-metadata">

**Author:** ![percona.jayj](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/percona.jayj/32/927_2.png) [@percona.jayj](https://forums.percona.com/u/percona.jayj)\
**Post date:** [May 30, 2013, 11:47am UTC](https://forums.percona.com/t/two-synchronised-percona-xtradb-clusters/2706/4 "2013-05-30T11:47:28Z")

</div>

Craig: 1 cluster over a WAN will have a commit penalty of the about the single worst RTT between any two nodes in your cluster. That is, likely the ping time of your WAN link.

In a two cluster scenario, you should be able to make cluster B read\_only. This would effectively function like one big dual-master (or master/slave) DR setup with regular MySQL, and all the same caveats would apply about data loss on failover, repointing and recovering on a DR Failover, etc.

However, here’s a gotcha. If A1 replicates to B1 and either of those two failed, you basically have to rebuild all of B. There’s no easy way to failover async replication channels to other nodes in the cluster. Nope, you can’t guarantee binlog positions are the same, though you could fudge this a bit if you tried hard. This will be solved in Galera 3.0 on 5.6 using GTIDs, but for now you’re stuck.

---

<div class="post-metadata">

**Author:** ![marc.castrovinci](https://avatars.discourse-cdn.com/v4/letter/m/ec9cab/32.png) [@marc.castrovinci](https://forums.percona.com/u/marc.castrovinci)\
**Post date:** [June 7, 2013, 12:37pm UTC](https://forums.percona.com/t/two-synchronised-percona-xtradb-clusters/2706/5 "2013-06-07T12:37:48Z")

</div>

Jay, I’m investigating the same setup. Any timeframe on PXC 5.6 and Galera 3.0?