MySQL Forums
Forum List  »  Router & Proxy

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

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

Options: ReplyQuote


Subject
Views
Written By
Posted
How to debug ?
3646
July 10, 2007 03:55AM
2335
August 10, 2007 06:51AM
2337
August 10, 2007 07:05AM
2360
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.