Load Balancer Question

[peterdh44]

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.5

I 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

[GruensFroeschli]

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

[Guest]

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.

[peterdh44]

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