Haproxy can't monitor other server mysql status
 

Hi guys,
i try executing a query on one of the masters as the haproxy user but i get error ilke this:
ERROR 2003 (HY000): Can't connect to MySQL server on '10.0.0.2' (113 "No route to host")
what is going on? i need to monitoring mysql status using haproxy.

thanks for your help. :)

Well, the message is pretty clear...it's telling you either the MySQL database on that host isn't running, or you don't have a network connection to that host. Have you done any basic troubleshooting yet?? The log files will probably have details.

Log into that host, and try to attach to mysql from there. If you can, then there is a network problem between the two machines, either causes by a firewall, IPtables, or a router/switch/hardware between the two.

Your node where the MySQL reside is maybe down, network error, or firewall policy to block some nodes. Investigate your MySQL host machine.

Right...that's what the OP was told in the first reply, eight months ago.

Well that's most root cause of your issue. Did you solved it?

You need to read the thread before responding. It was not my issue, and the poster never came back. You gave the same advice I did, eight months ago.