I need to ensure high availability of my 3-tier architecture system. Currently I have the database mirrored by using MySQL Master-Master. All app boxes talk to the primary DB server

In case of primary DB hardware failure then the application needs to be switched to the secondary .. and that is manual. I want to make this automatic, using heartbeat and IP takeover etc., is possible but that has too many problems.

How is this problem solved normally. Is it a good idea to use a load balancer like F5 to route all DB traffic and then switch in case of failure


Your Answer

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

Browse other questions tagged or ask your own question.