# percona xtraDB cluster 8.0.19 HA and DR solution across 2x data centers **URL:** \ **Category:** Percona XtraDB Cluster 8.x\ **Tags:** community, mysql, percona\ **Created:** [August 13, 2020, 7:25am UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-19-ha-and-dr-solution-across-2x-data-centers/7903 "2020-08-13T07:25:57Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![DBA100](https://avatars.discourse-cdn.com/v4/letter/d/b3f665/32.png) [@DBA100](https://forums.percona.com/u/DBA100)\ **Post date:** [August 13, 2020, 7:25am UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-19-ha-and-dr-solution-across-2x-data-centers/7903/1 "2020-08-13T07:25:57Z")
hi, we are having a percona xtraDB cluster 5.7x with 2 nodes in primary and another 2 x nodes in DR site, and as mysql can’t failover to a DR site by design we use 2 x ProxySQL on each site to redirect application request to the DR site. now we will migrate to percona xtraDB cluster 8.0.19 and as 3 x nodes is recommended for a cluster we will use this numbers! can we have 3 x nodes on primary site and 2 x nodes on DR site ? and use the same 2x proxysql in each site to redirect client traffic to any living percona ? any HA and DR topology for percona XtraDB cluster good reading can teach me this ? ---
**Author:** ![MirSos](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@MirSos](https://forums.percona.com/u/MirSos)\ **Post date:** [August 15, 2020, 4:48am UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-19-ha-and-dr-solution-across-2x-data-centers/7903/2 "2020-08-15T04:48:30Z")
If I understand well for why you want to DR site, maybe try use arbitrator? it will be work like third node. ---
**Author:** ![DBA100](https://avatars.discourse-cdn.com/v4/letter/d/b3f665/32.png) [@DBA100](https://forums.percona.com/u/DBA100)\ **Post date:** [August 15, 2020, 4:53am UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-19-ha-and-dr-solution-across-2x-data-centers/7903/3 "2020-08-15T04:53:23Z")
“maybe try use arbitrator? it will be work like third node.” yeah, but it don’t store data, right? it just for quorum votes only ? here every company as DR site, for compliance purpose!  are you saying percona xtraDB cluster is not for cross site ? we here use percona xtraDB cluster 5.7x across 2 x DC but we use proxySQL to failover. how about  for xtraDB cluster 8.0.19, how we design the 2 x DCs design ? how many nodes in primary and DR site ?  3 x nodes in primary site and 2 x in DR sites and KEEP using proxySQL to failover instead of DB level ? ---
**Author:** ![DBA100](https://avatars.discourse-cdn.com/v4/letter/d/b3f665/32.png) [@DBA100](https://forums.percona.com/u/DBA100)\ **Post date:** [August 17, 2020, 10:47pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-19-ha-and-dr-solution-across-2x-data-centers/7903/4 "2020-08-17T22:47:31Z")
hi, any update for me ? ---
**Author:** ![MirSos](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@MirSos](https://forums.percona.com/u/MirSos)\ **Post date:** [August 20, 2020, 7:30am UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-19-ha-and-dr-solution-across-2x-data-centers/7903/5 "2020-08-20T07:30:25Z")
Please explain me, why you want to use DR site? If you have 5 nodes, use all in master PXC. For me it is quite better solution than automatic failover.  ---
**Author:** ![DBA100](https://avatars.discourse-cdn.com/v4/letter/d/b3f665/32.png) [@DBA100](https://forums.percona.com/u/DBA100)\ **Post date:** [August 20, 2020, 7:57am UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-19-ha-and-dr-solution-across-2x-data-centers/7903/6 "2020-08-20T07:57:48Z")
", why you want to use DR site? " as I said before, here every company as DR site, for compliance purpose!  “If you have 5 nodes, use all in master PXC” what is that mean ? all  5 nodes in primary site ? we are now using 2 x nodes in primary site and 2 x nodes in secondary site! in galera replication, if primary site failed, DR site may also stop working as it is even number of nodes ! what I knew is open source DB most likely can’t cross site…  ---
**Author:** ![DBA100](https://avatars.discourse-cdn.com/v4/letter/d/b3f665/32.png) [@DBA100](https://forums.percona.com/u/DBA100)\ **Post date:** [August 20, 2020, 8:22am UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-19-ha-and-dr-solution-across-2x-data-centers/7903/7 "2020-08-20T08:22:28Z")
one thing, as we are using 2 x nodes on primary and another 2 x nodes on DR site, and we use ProxySQL to redirect SQL request to other percona Mysql nodes if one failed. Is it a normal way to architect a Percona XtraDB Cluster 5.7.23 and 8.0.19 DB system ?  ---
**Author:** ![MirSos](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@MirSos](https://forums.percona.com/u/MirSos)\ **Post date:** [August 20, 2020, 8:30am UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-19-ha-and-dr-solution-across-2x-data-centers/7903/8 "2020-08-20T08:30:05Z")
No! if you have at least 2 nodes PXC will be still working. if you lose one of those two nodes then you lose PXC, that why arbiter are cheap solution to secure. 3 nodes in cluster are recommendet because you may lose one of nodes, and your PXC will be works.2 nodes works like 1 node, if you lose 1 you lose all. ---
**Author:** ![MirSos](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@MirSos](https://forums.percona.com/u/MirSos)\ **Post date:** [August 20, 2020, 8:37am UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-19-ha-and-dr-solution-across-2x-data-centers/7903/9 "2020-08-20T08:37:12Z")
explain one thing, your 2xnodes on primary are masters and 2xnodes on DR are slaves to those masters?  ---
**Author:** ![DBA100](https://avatars.discourse-cdn.com/v4/letter/d/b3f665/32.png) [@DBA100](https://forums.percona.com/u/DBA100)\ **Post date:** [August 20, 2020, 9:27am UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-19-ha-and-dr-solution-across-2x-data-centers/7903/10 "2020-08-20T09:27:19Z")
“if you have at least 2 nodes PXC will be still working.” “2 nodes works like 1 node, if you lose 1 you lose all.” Yes I know!  then it is not a cluster any more as lost one, the cluster down! not protecting the cluster! " if you lose one of those two nodes then you lose PXC" that’s why I prefer 3 nodes. lost 1 nodes PXC (Percona xtraDG cluster, right?) still works , right ? "that why arbiter are cheap solution to secure. “ yeah,  ”, your 2xnodes on primary are masters and 2xnodes on DR are slaves to those masters? " 1 nodes on primary are master, the rest all slave. but any configuration  I can use to verify it ? what is the query ? ---
**Author:** ![MirSos](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@MirSos](https://forums.percona.com/u/MirSos)\ **Post date:** [August 21, 2020, 4:37am UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-19-ha-and-dr-solution-across-2x-data-centers/7903/11 "2020-08-21T04:37:48Z")
“1 nodes on primary are master, the rest all slave.” But this is simple Master-Slave replication, not Percona XtraDB Custer who is Master-Master replication. [https://www.percona.com/doc/percona-xtradb-cluster/LATEST/intro.html](https://www.percona.com/doc/percona-xtradb-cluster/LATEST/intro.html "Link: https://www.percona.com/doc/percona-xtradb-cluster/LATEST/intro.html")