Using a hardware load balancer for postgres / Mysql

by Ram   Last Updated May 09, 2017 09:05 AM

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

Related Questions

imitate load balancing programmatically

Updated September 23, 2016 09:02 AM