We have purchased 3X APACHE servers, and have a Mysql Server running behind them. We are using a hardware load balancer to balance the requests to the apache servers.
Our problem is that we set the rules for the Load Balancer (LB) to use the main public ips of the apache servers so that balancing happens on a per server basis in the Group. Also the A records of all the domains on the server to be balanced are pointing to the VIP of the LB.
Now the issue is once someone hits www.example.com, they are forwarded to the LB (VIP 18.104.22.168) which sends them to the Apache server IP ie 22.214.171.124. The issue is now, is that the Apache servers cannot route the request now to the domain's ip for www.example.com ie 126.96.36.199.
How can we manage multiple domain routing from the main Apache servers, which are sent requests from the VIP of the LB?
thanks in advance