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 I have created a user named 'haproxy' with the following privileges =================================== mysql> show grants for 'haproxy'@'10.14.19.17'; +--------------------------------------------------+ | Grants for [email protected] | +--------------------------------------------------+ | GRANT USAGE ON *.* TO 'haproxy'@'10.14.19.17' | +--------------------------------------------------+ 1 row in set (0.00 sec) ================================== and it can login without password to the RDS Master ============================================== root@haproxy-1:~# mysql -h xxxxxxxxxxxxx.rds.amazonaws.com -u haproxy Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2485932 Server version: 5.5.12-log Source distribution Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL v2 license Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show grants; +--------------------------------------------------+ | Grants for [email protected] | +--------------------------------------------------+ | GRANT USAGE ON *.* TO 'haproxy'@'10.14.19.17' | +--------------------------------------------------+ 1 row in set (0.00 sec) mysql> =============================================== The HAProxy configuration to load Balance MySQL reads between RDS Master and Read Replica is ================================================ listen mysql-cluster 0.0.0.0:3306 mode tcp balance roundrobin option mysql-check user haproxy server rds-master xxxxxxxxxxx.rds.amazonaws.com:3306 check server rds-replica yyyyyyyyyyyyy.rds.amazonaws.com:3306 check ================================================ After a few Seconds of just health Check by HAProxy The HAProxy Log shows the error. =================================================== localhost haproxy[21891]: Server mysql-cluster/rds-master is DOWN, reason: Layer7 wrong status, code: 0, info: "Host 'ip-10-14-19-17.xxxxxxxxx.internal' is blocked because of many connection errors; unblock with 'mysqladmin", check duration: 0ms. ====================================================== 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? Thanks --Siju
