LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > CentOS
User Name
Password
CentOS This forum is for the discussion of CentOS Linux. Note: This forum does not have any official participation.

Notices


Reply
  Search this Thread
Old 04-22-2017, 12:47 AM   #1
suhendra
LQ Newbie
 
Registered: Apr 2017
Posts: 1

Rep: Reputation: Disabled
Smile 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.

Last edited by suhendra; 04-22-2017 at 12:48 AM.
 
Old 04-23-2017, 09:14 AM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 26,520

Rep: Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944
Quote:
Originally Posted by suhendra View Post
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.
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.
 
Old 12-29-2017, 12:37 AM   #3
nejnej25
Member
 
Registered: Dec 2017
Location: Asia
Distribution: Slackware 14.2,CentOS 7, Ubuntu, Debian
Posts: 116

Rep: Reputation: Disabled
Your node where the MySQL reside is maybe down, network error, or firewall policy to block some nodes. Investigate your MySQL host machine.
 
Old 12-29-2017, 09:11 AM   #4
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 26,520

Rep: Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944
Quote:
Originally Posted by nejnej25 View Post
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.
 
Old 12-29-2017, 10:07 AM   #5
nejnej25
Member
 
Registered: Dec 2017
Location: Asia
Distribution: Slackware 14.2,CentOS 7, Ubuntu, Debian
Posts: 116

Rep: Reputation: Disabled
Quote:
Originally Posted by TB0ne View Post
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?
 
Old 12-30-2017, 07:40 PM   #6
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 26,520

Rep: Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944
Quote:
Originally Posted by nejnej25 View Post
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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
systemctl [status|start|stop] MySQL.server doesn't work grob115 Linux - Server 1 10-03-2015 06:47 PM
[SOLVED] HAPROXY - MySql Replication check script wademac Linux - Server 2 03-24-2011 08:25 PM
tweaking mysql in my lamp server - my.cnf and show status results Pawang Linux - Server 2 09-24-2009 09:34 AM
haproxy status error-req ravibhure Linux - Networking 0 02-16-2009 05:04 AM
Haproxy ,memcached ,mysql strange problem Eazy-Snatch Linux - Server 1 05-14-2008 02:54 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > CentOS

All times are GMT -5. The time now is 10:41 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration