Johan, I don't think there's any need for the heavyness (and ugliness ;) ) of MySQL Proxy. We're using haproxy for a similar setup (just with galera behind it, but that shouldn't really matter. Have a look at this blog post that explains most of it: http://www.olindata.com/blog/2014/04/managing-percona-xtradb-cluster-puppet#haproxy
cheers, On Wed, Jul 9, 2014 at 12:11 PM, Johan De Meersman <vegiv...@tuxera.be> wrote: > 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. > -- Best regards, Walter Heck CEO / Founder OlinData <http://olindata.com/?src=wh_gapp> - Open Source Training & Consulting Check out our upcoming trainings <http://olindata.com/training/upcoming>
