1

After hours of searching I find lots of tutorials that do only 2 server Master Master. Now I wonder how to setup multi master setup because this is more suitable in my business. Because when the WAN connection is down my transaction in area's are still on going and then when the connection is back the changes in servers will be sync on. That's why i need multi master setup. Thanks in advance for any help and tips

asked Oct 21, 2015 at 8:24

1 Answer 1

1

MySQL Server master-master replication is possible for max 2 nodes.

You might want to use Galera Cluster (Percona Xtradb Cluster or Mariadb Galera cluster) Or Oracle's NDB Cluster to achieve HA as a better solution than master-master.

answered Oct 21, 2015 at 8:30
3
  • im new with the galera I never use one. question does it work with mysql 5.0? Commented Oct 21, 2015 at 8:42
  • Does it works in windows? Commented Oct 22, 2015 at 1:06
  • @dotcom It's not an add-on that you integrate with existing mysql but a separate install. You can get Percona xtradb cluster from percona.com/software/mysql-database/percona-xtradb-cluster. and not it doesnt work on windos. Commented Nov 20, 2015 at 5:02

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.