Hi,
I'm running a mysql-proxy on a production environnement : a PHP API loadbalance SQL requests to a pool of mysql slave servers, i add a pseudo slave server which is mysql-proxy who loadbalance. So i could remove mysql-proxy from the pool and add all others, in case of failure.
Last day evening, the web site was lagging a lot, i check all servers, see nothing strange, then i remove mysql-proxy from pool and add all slaves, which do a lower lag...
You cas see a screenshot of what happens, with and then without mysql-proxy :
http://my.grg.dev.easyrencontre.com/tmp/mproxy.png
Without mysql-proxy : servers handle a lot more requests, and web site go faster.
Any ideas about what happened ?
Greg
