Hi, Le mercredi 13 juillet 2011 14:36:57, Siju George a écrit : > Hi, > > I have an HAproxy 1.4 System on Amazon EC2 running the kernel > > Linux 2.6.38-8-virtual #42-Ubuntu SMP Mon Apr 11 04:06:34 UTC 2011 > x86_64 x86_64 x86_64 GNU/Linux > > with HA proxy version 1.4.8-1
Your haproxy version is too old for your need. > option mysql-check user haproxy This syntax was not supported in haproxy 1.4.8, it appeared in 1.4.9 with a full handshake and a QUIT command to cleanly close the connection. http://haproxy.1wt.eu/git?p=haproxy-1.4.git;a=commitdiff;h=a1e4dcfe5718311b7653d7dabfad65c005d0439b > After a few Seconds of just health Check by HAProxy The HAProxy Log > shows the error. > > Trying to connect to RDS from HA Proxy System Command Line shows > > ===================================================== > root@qk-haproxy-1:/var/log# mysql -h xxxxxxxxxxxxxx.rds.amazonaws.com -u > haproxy > ERROR 1129 (HY000): Host 'ip-10-14-19-17.xxxxxxxxx.internal' is > blocked because of many connection errors; > unblock with 'mysqladmin flush-hosts' > ==================================================== > > Could some one point to me what could be wrong here? > > Anybody Loadbalancing Amazon RDS with HA Proxy? Try to upgrade haproxy to the last version or at least to 1.4.9. That should help you. If you can't upgrade, see if you can modify your mysql configuration, by increasing max_connect_errors (to a value like 9999 or even greater) : http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_max_connect_errors -- Cyril Bonté
