Re: HAProxy and MySQL failover

2013-05-16 Thread Jonathan Matthews
In the past I've used a ludicrously high setting on the primary for rise, the number of health checks it has to pass before it's considered to be up again. It's definitely a hack, though that's not to say I haven't used it in production ;-) Jonathan -- Jonathan Matthews Oxford, London, UK

Re: HAProxy and MySQL failover

2013-05-16 Thread Michael Glenney
How about handling it on the backend. Setup your health checks on a different port and forward that port with iptables to the actual health check. When you fail over to the slave have some automation that detects that and shuts down iptables on the master. When your ready to receive traffic