Also Forgot to add 1) MySQL Client on HaProxy can connect to Amazon RDS.
mysql-client-5.1 5.1.54-1ubuntu4 ======================================================================== root@lb1:/var/software/hap15/haproxy-1.4.15# mysql -h xxxxxxxx.rds.amazonaws.com -u haproxy Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2580937 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 haproxy@12.11.2.6 | +-------------------------------------------------+ | GRANT USAGE ON *.* TO 'haproxy'@'12.11.2.6' | +-------------------------------------------------+ 1 row in set (0.06 sec) mysql> ======================================================= Amazon RDS is on MySQL 5.5 thanks --Siju On Thu, Jul 14, 2011 at 3:59 PM, Siju George <sgeorge...@gmail.com> wrote: > On Wed, Jul 13, 2011 at 6:23 PM, Cyril Bonté <cyril.bo...@free.fr> wrote: >> >> 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 >> > > Thanks a million Cyril. > I compiled in haproxy 1.4.15 from the website. > But when started it gives the error. > > ============================================================================================== > Jul 14 15:51:11 localhost haproxy[5091]: Server > mysql-cluster/rds-master is DOWN, reason: Layer7 wrong status, code: > 0, info: "Client does not support authentication protocol requested by > server; consider upgrading MySQL client", check duration: 117ms. 1 > active and 0 backup servers left. 0 sessions active, 0 requeued, 0 > remaining in queue > > Jul 14 15:51:12 localhost haproxy[5093]: Server > mysql-cluster/rds-replica is DOWN, reason: Layer7 wrong status, code: > 0, info: "Client does not support authentication protocol requested by > server; consider upgrading MySQL client", check duration: 119ms. 0 > active and 0 backup servers left. 0 sessions active, 0 requeued, 0 > remaining in queue. > > Jul 14 15:51:12 localhost haproxy[5093]: proxy mysql-cluster has no > server available! > =============================================================================================== > > what could be the trouble? > > The mysql client version on the HAProxy system is > > mysql-client-5.1 5.1.54-1ubuntu4 > > Thanks :-) > > --Siju >
