I like HAProxy as well as it simplifies many of the things you seem to be looking for.
-- Wagner Bianchi Mobile: +55.31.8654.9510 > Em 09/07/2014, às 07:48, "Heck, Walter" <walterh...@olindata.com> escreveu: > > 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>
