plugins - Wordpress Backend HA (Automatic failover)

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.

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.

• plugins
• plugin-development
• database
• mysql
• backup

Share Improve this question asked Mar 8, 2017 at 13:58 joebegborg07joebegborg07 9399 bronze badges

Add a comment  | 

2 Answers 2

Sorted by: Reset to default 0

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.

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.