Best practice advice : for multi-master-master setup using 3 data centers ?

MySQL & MariaDB Other MySQL® Questions
1

Dc : USA
Dc : Europe
Dc : Asia

Best practice advice : for multi-master-master setup using 3 data centers ?

To avoid dead locks and lag between the dc - can I rely on percona out of the box to handle this ?

What should I be aware of and what to avoid ?

Any one have experience with this and can point me in right direction to a successful deployment?

2

Multi-Data center clusters are complicated. They never behave exactly like single node systems - you will either have to have increased latency for your updates or deal with consequences of asynchronous replication. Assuming the commit latency is OK for you you can set up PXC cluster with 3 data centers as you described.