MySQL Forums
Forum List  »  Router & Proxy

How to debug ?
Posted by: Grégory Duchatelet
Date: July 10, 2007 03:55AM


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 :

Without mysql-proxy : servers handle a lot more requests, and web site go faster.

Any ideas about what happened ?


Options: ReplyQuote

Written By
How to debug ?
July 10, 2007 03:55AM
August 10, 2007 06:51AM
August 10, 2007 07:05AM
August 13, 2007 09:14AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.