Re: Proxy / connected failover question

2014-07-09 Thread Johan De Meersman
- Original Message - > From: "Martin Gainty" > Subject: Proxy / connected failover question > > >> I'm not usually an advocate of MySQL Proxy and the like, but I'm stuck > > >> with one shitty application that utterly breaks whenever th

RE: Proxy / connected failover question

2014-07-09 Thread Martin Gainty
> CC: vegiv...@tuxera.be; mysql@lists.mysql.com > From: wagnerbianch...@gmail.com > Subject: Re: Proxy / connected failover question > Date: Wed, 9 Jul 2014 08:31:05 -0300 > To: walterh...@olindata.com > > I like HAProxy as well as it simplifies many of the things you seem

Re: Proxy / connected failover question

2014-07-09 Thread Wagner Bianchi
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" escreveu: > > Johan, > > I don't think there's any need for the heavyness (and ugliness ;) ) of > MySQL Proxy. We're usin

Re: Proxy / connected failover question

2014-07-09 Thread Heck, Walter
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-pe

Re: Proxy / connected failover question

2014-07-09 Thread Claudio Nanni
Hi Johan, I wanted to love mysql-proxy for so many years, so I understand you :) > I have two main questions: > * am I remembering right that MySQL Proxy provides transparent failover ? > You need to use/create a lua failover script, I've never seen or tried one. What kept me from investing too

Proxy / connected failover question

2014-07-09 Thread Johan De Meersman
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