Load Balancer Question
-
Is it possible to setup the load balancing function to work on the LAN subnet from machines on the LAN subnet?
I want to load balance MySQL queries against 1 of 2 replicas from apache servers on the same subnet. The apache servers are loadbalanced from the Internet and that works fine.
Apache 1 10.1.1.1
Apache 2 10.1.1.2
Virtual IP for Apache = 24.24.55.55 (This is made up)
MySQL 1 10.1.1.3
MySQL 2 10.1.1.4
Virtual IP for MySQL = 10.1.1.5I want either Apache 1 or 2 to query 10.1.1.5 and have that redirected to either MySQL 1 or 2.
The load balanced IP works when we are attached via VPN and the traffic flows across the LAN interface from the PPTP interface.
TIA
Peter
-
I'm not sure if this works but you could:
Enable NAT reflection under advanced
Access via the public IP.I dont know if this works, but you can reflect access to normal portforwards like this.
Maybe it works as well for server-balancing-pools -
NAT reflection won't do this.
The solution here is to put those devices into a DMZ and then load balance your traffic from the LAN to the the DMZ devices. This will work very well with a very minor network reconfiguration.
-
Thanks for the feedback.
Unfortunately we can't put them in a separate DMZ because these DB servers are also sharing hardware with the Apache servers.
What I can do is hookup eth1 and assign those IPs to the MySQL slaves and put them on a different VLAN and see if the LAN port will talk to both subnets.
Peter