load-balancing with pfsense

view full story

http://serverfault.com – I am trying to setup a proof of concept based on MySQL galera. My MySQL servers are all setup and working properly and replicating as I wish they would do (it is not a question about MySQL replication). I am now at the load-balancer level, I am having a pfsense box (firewall/gateway) in front of these mysql servers and I am trying to setup the load-balancer. Pfsense has a load-balancer service integrated and if I used the normal TCP check it works great. but I want more than that, I installed an instance of apache2 on the mysql servers and this is running a php script that returns HTTP 200 if (HowTos)