What about slaves delay ?

[Grégory Duchatelet]

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