> 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 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.
MG>how could a proxy server re-route a downed DB connection to another server?
MG>does Proxy have a heartbeat on 3306 and reroute somewhere else when 3306
connection goes silent?
MG>exactly how does either MySQLProxy or HAProxy handle these detection and
reroute scenarios?
> >>
</snip>
> >>
> >> 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
> >
MG>BR,
MG>Martin
