[http://www.blogger.com/profile/13990877688502800403 Sheeri K. Cabral] said…
You could probably very easily put this all into a lua script, slap MySQL Proxy in front of it, and have automated failover – if it can’t reach the 1st backend, pick among the other backends by doing a query, promote it, etc.