I have two dedicated servers on OVH with ESXI hosting multiple VMs. VMs are multiple application servers and databases (one is active, and another is standby). Each server also has Apache mod_jk Load Balancer that balance between application servers on both dedicated servers over vRack.
Problem is that both Load Balancers have public IP, and I need only one active at a time.
I have a few approaches, but all of them have some obstacles.
Approach 1:
I tried to define multiple A records on IONOS, but according to some sources, there is a problem with caching, especially with Google Chrome.
Approach 2:
IP groups on both servers are Failover so I can switch IP to other LB in case of failure, but the switch has to be done manually (as far as I know).
Approach 3:
OVH has an IP Load Balancing option, but it still creates a Single point of failure. Also, documentation is not very helpful. Can I define rules to use backup LB only in case primary LB failed?
Is there some solution to these problems or any other approach?