I'm using ldirectord with heartbeat for mysql load balancing. It is distributing mysql connections equally to all servers available in the pool but sometime slave remains in the pool even after encountering a Too many connections error. There should be some option to count number of running queries on the slave before sending more connections to it.
Anyone who is using ldirectord for mysql and would like to share the same experience with suggested solutions for this hitch?
Thanks.