MySQL Forums
Forum List  »  Router & Proxy

What about slaves delay ?
Posted by: Grégory Duchatelet
Date: July 06, 2007 05:41AM

Hi,

Great job Jan, i try it today and now it is in production environnement with 5 mysql slave servers (enterprise 5.0.44) running about ~100 requests/seconds, mysql-proxy use only ~3-4% CPU.

I hope this software will have a long life :)

This 5 servers are mysql slave read-only, so i have configured the PHP applications to only run SELECT queries to mysql-proxy.
Sometimes, 1 server, or another, but never the same, have a long replication delay (> 700 seconds), and I have to manually remove this server from the pool. Will mysql-proxy be able to manage slaves delaies ?

For example if 1 server have too much delay, say 240 seconds, it will be removed from the pool by mysql-proxy.

Thanks
Greg

Options: ReplyQuote


Subject
Views
Written By
Posted
What about slaves delay ?
4897
July 06, 2007 05:41AM
2897
July 06, 2007 07:51AM
2608
July 06, 2007 08:22AM
2637
July 06, 2007 12:21PM
2900
July 09, 2007 03:15AM


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.