What about slaves delay ?
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
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
2870
July 06, 2007 09:28AM
2637
July 06, 2007 12:21PM
3077
July 09, 2007 01:50AM
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.