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

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.

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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