The trunk version of the MySQL Proxy 0.6.0 just learnt about changing backends within running connection. It is now up to lua-script to decide which backend shall be used to send requests too. We wrote a complete tutorial which covers everything from: building and maintaining a connection pool with high and low water marks transparent authentication (no extra auth against the proxy) deciding on Qu