Re: mysql failover and forcing disconnects

2012-05-24 Thread Willy Tarreau
Hi Justin, On Wed, May 23, 2012 at 03:11:00PM -0700, Justin Karneges wrote: (Apologies if this comes through twice. The first time I sent was before subscription approval, and I don't think it went through.) It was OK, you don't need to be subscribed to post messages. (...) 1) Even if

Re: mysql failover and forcing disconnects

2012-05-24 Thread Justin Karneges
On Wednesday, May 23, 2012 11:57:14 PM Willy Tarreau wrote: There is an option at the server level which is on-marked-down shutdown-session. It achieves exactly what you want, it will kill all connections to a server which is detected as down. Perfect! 2) If the master eventually comes

Re: mysql failover and forcing disconnects

2012-05-24 Thread Willy Tarreau
On Thu, May 24, 2012 at 01:12:14AM -0700, Justin Karneges wrote: Well, the network could fail at anytime and have a similar effect. I'm not sure if killing all connections to the backup is really any worse than killing all connections to the non-backup (via on-marked-down). Either way a

Re: mysql failover and forcing disconnects

2012-05-24 Thread Baptiste
On Thu, May 24, 2012 at 10:59 AM, Willy Tarreau w...@1wt.eu wrote: On Thu, May 24, 2012 at 01:12:14AM -0700, Justin Karneges wrote: Well, the network could fail at anytime and have a similar effect. I'm not sure if killing all connections to the backup is really any worse than killing all

Re: [ANNOUNCE] haproxy 1.4.21

2012-05-24 Thread Kevin Decherf
Hi, Just for archive: CVE-2012-2391 http://www.openwall.com/lists/oss-security/2012/05/23/15 Kevin Decherf - M: +33 681194547 - T: @Kdecherf On Tue, May 22, 2012 at 9:30 PM, Vivek Malik vivek.ma...@gmail.com wrote: A recommended upgrade for all production users. While we are not

Re: mysql failover and forcing disconnects

2012-05-24 Thread Justin Karneges
On Thursday, May 24, 2012 01:59:32 AM Willy Tarreau wrote: On Thu, May 24, 2012 at 01:12:14AM -0700, Justin Karneges wrote: Well, the network could fail at anytime and have a similar effect. I'm not sure if killing all connections to the backup is really any worse than killing all

Re: could haproxy call redis for a result?

2012-05-24 Thread S Ahmed
Baptiste, Whenever this feature will be implemented, will it work for a specific url like: subdomain1.example.com What about by query string? like: www.example.com/customer/12345 or www.example.com/some/path?customerId=12345 Will it work for all the above? On Tue, May 8, 2012 at 9:38 PM,

RE: haproxy conditional healthchecks/failover

2012-05-24 Thread Zulu Chas
Hi! I'm trying to use HAproxy to support the concepts of offline, in maintenance mode, and not working servers. Any good reason to do that??? (I'm a bit curious) Sure. I want to be able to mark a machine offline by creating a file (as opposed to marking it online by creating a

Problems with layer7 check timeout

2012-05-24 Thread Lange, Kevin M. (GSFC-423.0)[RAYTHEON COMPANY]
Hi, We're having odd behavior (apparently have always but didn't realize it), where our backend httpchks time out: May 24 04:03:33 opsslb1 haproxy[4594]: Server webapp_ops_bk/webapp_ops1 is DOWN, reason: Layer7 timeout, check duration: 1002ms. 0 active and 0 backup servers left. 1 sessions

Re: Problems with layer7 check timeout

2012-05-24 Thread Willy Tarreau
Hi Kevin, On Thu, May 24, 2012 at 04:04:03PM -0500, Lange, Kevin M. (GSFC-423.0)[RAYTHEON COMPANY] wrote: Hi, We're having odd behavior (apparently have always but didn't realize it), where our backend httpchks time out: May 24 04:03:33 opsslb1 haproxy[4594]: Server

Re: Problems with layer7 check timeout

2012-05-24 Thread Willy Tarreau
On Thu, May 24, 2012 at 04:31:39PM -0500, Lange, Kevin M. (GSFC-423.0)[RAYTHEON COMPANY] wrote: I thought it was a bug in the reporting, considering we've played with numerous values for the various timeouts as an experiment, but wanted your thoughts. This is v1.4.15. [root@opsslb1

Re: Problems with layer7 check timeout

2012-05-24 Thread Lange, Kevin M. (GSFC-423.0)[RAYTHEON COMPANY]
I've already put an upgrade to haproxy in place. Kevin M Lange Mission Operations and Services NASA EOSDIS Evolution and Development Intelligence and Information Systems Raytheon Company +1 (301) 851-8450 (office) +1 (301) 807-2457 (cell) kevin.m.la...@nasa.gov kla...@raytheon.com 5700

patch: on-marked-up option

2012-05-24 Thread Justin Karneges
Hi, This implements the feature discussed in the earlier thread of killing connections on backup servers when a non-backup server comes back up. For example, you can use this to route to a mysql master slave and ensure clients don't stay on the slave after the master goes from down-up. I've

Re: Problems with layer7 check timeout

2012-05-24 Thread Lange, Kevin M. (GSFC-423.0)[RAYTHEON COMPANY]
Monsieur Tarreau, Actually, we are seeing frontend service availability flapping. This morning particularly. Missing from my snippet is the logic for an unplanned outage landing page, that our customers were seeing this morning, so it haproxy truly is timing out and marking each backend as

Re: Problems with layer7 check timeout

2012-05-24 Thread Baptiste
Hi Lange, Would it be possible to take a trace (tcpdump) of the health check? This may help as well. Cheers On Fri, May 25, 2012 at 4:01 AM, Lange, Kevin M. (GSFC-423.0)[RAYTHEON COMPANY] kevin.m.la...@nasa.gov wrote: Monsieur Tarreau, Actually, we are seeing frontend service availability

Re: could haproxy call redis for a result?

2012-05-24 Thread Baptiste
Hi, I'm jut guessing, but to me it can work for URLs only, so in your case, it will match /, /customer/12345, and /some/path?customerId=12345. For now, the string table can't have a concatenated string of 2 information, Host header and URL in your case. But who knows, maybe this feature will

CISCO Workshop on: Strategic Management of Technology and Resources to Increase Attorney Productivity

2012-05-24 Thread Ellena Wright
Dear Reader, Invitation to attend GOAL’s next workshop led by - Tanya Vaislev, Senior Manager, Legal Cisco Systems, Inc., USA Topic: Strategic Management of Technology and Resources to Increase Attorney Productivity Venue: At your desk: On your Laptop/PC or Phone Date: 29 May 2012 Time: 9:00 am

Re: Problems with layer7 check timeout

2012-05-24 Thread Willy Tarreau
Hi Kevin, On Thu, May 24, 2012 at 09:01:43PM -0500, Lange, Kevin M. (GSFC-423.0)[RAYTHEON COMPANY] wrote: Monsieur Tarreau, Actually, we are seeing frontend service availability flapping. This morning particularly. Missing from my snippet is the logic for an unplanned outage landing page,