Re: HAProxy for failover

2013-06-18 Thread Thomas Heil
Hi, There was a nice tutorial at http://www.alexwilliams.ca/blog/2009/08/10/using-haproxy-for-mysql-failover-and-redundancy/ But instead of doing such complex things, please try if galera cluster for mysql is suitable for you. cheers thomas On 06/18/13 13:51, Nenad Merdanovic wrote: > Hello, >

Re: HAProxy for failover

2013-06-18 Thread Nenad Merdanovic
Hello, There is no nice way of doing this in HAproxy that would show you that the server is down (in the Web GUI for example). You can only check where the traffic is going using the socket or the Web GUI and if the failover occured you will see traffic going to the 'backup' server. If you are us

HAProxy for failover

2013-06-18 Thread Jayadevan M
Hello all, I am using HAProxy for MYSQL failover. It is a MySQL master-slave replication environment. When master is UP, all reads and writes go to master. In case the master is down, reads and writes will go to the slave. Once the master is down and HAProxy redirects all reads/writes to the sl