Not the answer you need?
Register and ask your own question!

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

mysql.girlmysql.girl ContributorCurrent User Role Contributor
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?

Comments

  • PeterPeter Percona CEO Percona Moderator Role
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.