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

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.

3
  • im new with the galera I never use one. question does it work with mysql 5.0?
    – dotcom
    Oct 21, 2015 at 8:42
  • Does it works in windows?
    – dotcom
    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.
    – mysql_user
    Nov 20, 2015 at 5:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.