Hullo peoples,

I'm not usually an advocate of MySQL Proxy and the like, but I'm stuck with one shitty application that utterly breaks whenever the database goes away unexpectedly. I can't change the application itself, so I find myself looking for options that allow the heathen contraption to not notice it's connection has switched.

I am aware that connection state etc is likely to be lost anyway; I'll have to see wether or not that's going to be an issue during testing.

I have two main questions:
* am I remembering right that MySQL Proxy provides transparent failover ?
* Are there other contenders in the same field, or alternate solutions ?

Ideally I'm looking for a hyper-stable tool that can run on it's own VM, so the application doesn't notice when I switch backends. All the other applications play nice, in that they simply reconnect and go on with business, so it doesn't even *have* to take improbably loads.


Thank you for any and all suggestions and information,
Johan

--
What's tiny and yellow and very, very dangerous?
A canary with the root password.