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

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

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:

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 walterh...@olindata.com escreveu: Johan, I don't think there's any need for the heavyness (and ugliness ;) ) of MySQL

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 to be looking

Re: Proxy / connected failover question

2014-07-09 Thread Johan De Meersman
- Original Message - From: Martin Gainty mgai...@hotmail.com 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 the database goes away unexpectedly. I