Re: killing persisent conections on backends marked down?

2012-02-28 Thread Siva
Hi Willy, >> is it possible for haproxy to failover to a backup, >> but not failback even if the server is alive again? I have the same problem. I would like for my primary to be detected as UP, but not do the failback immediately. Is it possible to failback to the primary only when the backup be

Re: killing persisent conections on backends marked down?

2010-02-26 Thread Greg Gard
hi, just a followup with a solution that might save some other rails dude some time. the fix below allows you to set the same timeouts for db connections as you have for your webserver backends without major invasive surgery to what rails expects (ie a persistent connection to db). turns out that

Re: killing persisent conections on backends marked down?

2010-02-26 Thread XANi
Hi Dnia 2010-02-25, czw o godzinie 21:07 -0500, Greg Gard pisze: > hi guys, > > thanks for the feedback. yet another rails issue that makes deployment > a hassle. my biggest issue with setting the timeouts is that when a > user hits the page after a timeout, they will get a 5xx error, but > perha

Re: killing persisent conections on backends marked down?

2010-02-25 Thread Willy Tarreau
On Thu, Feb 25, 2010 at 10:05:02PM -0500, Greg Gard wrote: > sorry willy i sent this to wrong address. here is my other question: > > one more thing. is it possible for haproxy to failover to a backup, > but not failback even if the server is alive again? for example, if i > could set rise to be i

Re: killing persisent conections on backends marked down?

2010-02-25 Thread Greg Gard
sorry willy i sent this to wrong address. here is my other question: one more thing. is it possible for haproxy to failover to a backup, but not failback even if the server is alive again? for example, if i could set rise to be infinite so that once it was down, it was down for good? currently, i

Re: killing persisent conections on backends marked down?

2010-02-25 Thread Greg Gard
hi guys, thanks for the feedback. yet another rails issue that makes deployment a hassle. my biggest issue with setting the timeouts is that when a user hits the page after a timeout, they will get a 5xx error, but perhaps i can teach rails to catch the exception and retry the connection. anyway,

Re: killing persisent conections on backends marked down?

2010-02-25 Thread Willy Tarreau
Hi, On Thu, Feb 25, 2010 at 10:54:35PM +0100, XANi wrote: > Dnia 2010-02-25, czw o godzinie 16:27 -0500, Greg Gard pisze: > > > hi willy and friends, > > > > i am working on a set of ruby scripts to do database failover and > > stonith. so far all is working pretty well, but i have a few issues:

Re: killing persisent conections on backends marked down?

2010-02-25 Thread XANi
Dnia 2010-02-25, czw o godzinie 16:27 -0500, Greg Gard pisze: > hi willy and friends, > > i am working on a set of ruby scripts to do database failover and > stonith. so far all is working pretty well, but i have a few issues: > > 1) rails makes persistent connections to the backend database so

killing persisent conections on backends marked down?

2010-02-25 Thread Greg Gard
hi willy and friends, i am working on a set of ruby scripts to do database failover and stonith. so far all is working pretty well, but i have a few issues: 1) rails makes persistent connections to the backend database so when a server is marked down, the connection remains ongoing. currently, i