Hi Willy, Be careful with the new "mysql-check" option introduced in the development branch.
http://haproxy.1wt.eu/git?p=haproxy.git;a=commit;h=698ae00fc272bf5f4e159922546347066bd66378 It won't work with distant backends : mysql has a mechanism to block hosts that open connection whithout closing them correctly (depending on the max_connect_errors value on the mysql server). Using the configuration file provided in the commit and a distant server, this quickly results in : [WARNING] 012/111726 (7318) : Server mysql_1/srv1 is DOWN, reason: Layer7 wrong status, code: 0, info: "Host 'distant.mysql.server' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'", check duration: 0ms. [ALERT] 012/111726 (7318) : proxy 'mysql_1' has no server available!
