We have a setup where the WordPress's MySQL database is replicated to a secondary MySQL server in case the primary fails. Are there any plugins or methods which would automatically switch to the secondary database server if the first one is unreachable ?

PS. Tried Hyper-DB but we don't exactly trust it since development on it stopped a while ago.

Thanks in advance.


HyperDB is awesome. You shouldn't worry about its dev date (which by the way, its being done by Automattic - the team behind WordPress).

HyperDB has some bigger advantages like spreading read/writes across servers and splitting them and its mostly used for such purposes (bigger scales).

In your case, I would go for a VIP VPS that would run Heartbeat, or a Failover service, since I do understand that your scope is HA and not Load Balancing.

| 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.