Out setup is multiple Front Ends (replicated) and 2 Backend MYSQL servers (Master-Master replication).

We're looking to achieve HA automatic failover for wordpress. We've got the front ends covered through replication and a load balancer.

Any ideas on how to achieve AUTOMATIC MySQL failover?

Thanks in advance.


You can achieve automatic failover using a synchronous service, like Galera cluster.

It requires three nodes, but you can set up two nodes there, along with an arbitrator.

| improve this answer | |

We use MariaDB Galera Replication for ensuring high availability of our WordPress Enterprise solution. Load balancing and automatic failover can be achieved with a help of DNS round robin (assigning multiple IP addresses of database instances to one hostname) or with a help of ProxySQL (or MaxScale) placed in front of database cluster.

| improve this answer | |

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.