# Can there be any challenges in PXC if 2 of its nodes are in GCP mumbai region and 1 node in Delhi region?

**URL:** <https://forums.percona.com/t/can-there-be-any-challenges-in-pxc-if-2-of-its-nodes-are-in-gcp-mumbai-region-and-1-node-in-delhi-region/32912>\
**Category:** Percona XtraDB Cluster 5.x\
**Tags:** percona\
**Created:** [September 4, 2024, 1:48pm UTC](https://forums.percona.com/t/can-there-be-any-challenges-in-pxc-if-2-of-its-nodes-are-in-gcp-mumbai-region-and-1-node-in-delhi-region/32912 "2024-09-04T13:48:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![todkar2130](https://avatars.discourse-cdn.com/v4/letter/t/c0e974/32.png) [@todkar2130](https://forums.percona.com/u/todkar2130)\
**Post date:** [September 4, 2024, 1:48pm UTC](https://forums.percona.com/t/can-there-be-any-challenges-in-pxc-if-2-of-its-nodes-are-in-gcp-mumbai-region-and-1-node-in-delhi-region/32912/1 "2024-09-04T13:48:54Z")

</div>

All the nodes are hosted in GCP VM

Architecture  
Mumbai Region -Node A , Node B, Node C  
Delhi Region- Node D

They are in same global VPC with same subnet ( eg:- 10.10.x.x)

The latency between both region is ranging around 22/23

Can there be any performance impact, lagging issue ?

---

<div class="post-metadata">

**Author:** ![Ivan\_Groenewold](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ivan_groenewold/32/6299_2.png) [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)\
**Post date:** [September 6, 2024, 11:53am UTC](https://forums.percona.com/t/can-there-be-any-challenges-in-pxc-if-2-of-its-nodes-are-in-gcp-mumbai-region-and-1-node-in-delhi-region/32912/2 "2024-09-06T11:53:37Z")

</div>

In general, PXC is not recommended across regions. It’s best to have a local cluster with asynchronous replication to remote sites. See [How Not to do MySQL High Availability: Geographic Node Distribution with Galera-Based Replication Misuse](https://www.percona.com/blog/how-not-to-do-mysql-high-availability-geographic-node-distribution-with-galera-based-replication-misuse/) for more info on this topic

---

<div class="post-metadata">

**Author:** ![CTutte](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ctutte/32/1341_2.png) [@CTutte](https://forums.percona.com/u/CTutte)\
**Post date:** [September 6, 2024, 1:23pm UTC](https://forums.percona.com/t/can-there-be-any-challenges-in-pxc-if-2-of-its-nodes-are-in-gcp-mumbai-region-and-1-node-in-delhi-region/32912/3 "2024-09-06T13:23:34Z")

</div>

As my college mentioned, in general is not worth having pxc nodes in different regions or with high latency connections but if latency is low it can work under certain circumstances (with a performance penalty).

Since every operation needs to be certified by all the nodes in the cluster, higher latency will have an impact in latency and performance.

An easy test you can do is:  
mysql\> SET profiling = 1;  
mysql\> # do some inserts  
mysql\> show profiles;

Example output:  
1 | 0.04700375 | insert into t1 values (null) |  
2 | 0.04648125 | insert into t1 values (null) |

The 2nd column will show you the latency in seconds each statement took. In the above example the inserts took 47 and 46 ms to execute.  
Do the test on your own topology and find out if the latency is good for your use case.

Regards
