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