mysql-proxy-discuss team mailing list archive

[Urban Loesch <bind@xxxxxxxx>]

Hi Diego,

thanks for your fast answer.
Sorry perhaps I haven't explained it not exactly enough.

It takes 3 minutes for the proxy to know that one backend is down or not 
reachable because of some network interruptions.

I made some tests and I "DROP" all connections from the proxy to the 
first backend with the firewall. So I can simulate a possible network 
interruption to backend 1.

With "netstat" I followed the proxy connection and I see for 3 minutes a 
"SYN_SENT" to backend 1, before the proxy is changing the connection to 
  backend 2.

For me it's very important that this timeout is as low as possible, 
perhaps 15 Seconds will be enough.

Many thanks
Urban


Diego Medina wrote:
> Hi Urban,
>
> What do you mean by a 3 minute timeout?
>
> * It takes 3 minutes for the proxy to know that one backend is down?
> * It takes 3 minutes for the proxy to know that the backend is "not"
> down any more?
>
> Thanks
>
> -Diego
>
>
> On Wed, Jul 15, 2009 at 5:15 AM, Urban Loesch<bind@xxxxxxxx> wrote:
> > Hi,
> >
> > I'm new to the list.
> >
> > I installed mysql-proxy 0.7.2 on a debian lenny system with two backend
> > servers for failover scenario. I only do SELECT queries on both backend's.
> > No writes.
> >
> > The failover works as expected and the proxy changes the server backend if
> > one of the two backend's rejects the connection or times out.
> >
> > The only problem now is, that the default network timeout is about 3 minutes
> > which I think is to long for me. Is there a way to change the timeout to 10
> > or 15 seconds?
> >
> > I searched the archives but I found only a solution for 0.6.0 with lua
> > scripts.
> >
> > It's not a problem for me to change the timeout in source code and recompile
> > the wohle proxy, but I'm not a c-programmer so I don't know where to look in
> > the code.
> >
> > Thanks for your help
> > Urban Loesch
> >
> >
> > _______________________________________________
> > Mailing list: https://launchpad.net/~mysql-proxy-discuss
> > Post to     : mysql-proxy-discuss@xxxxxxxxxxxxxxxxxxx
> > Unsubscribe : https://launchpad.net/~mysql-proxy-discuss
> > More help   : https://help.launchpad.net/ListHelp