Load columnar text file into MySQL table
Kedar
Ever come accoss a situation where you have to load a flat text file into MySQL with data provided in single column! Say, your data to be loaded in table…
Browsing Category
MySQL-Articles
79 posts
MySQL related blog posts
MySQL – Alter table-change datatype of column with foreign key
Schema alteration is a big headache especially when it has already reached to production and things get worse when the relations are involved.Below is a short example for altering tables…
Access Control in MySQL Stored Routines: DEFINER, INVOKER & SQL SECURITY
MySQL Stored Routines (functions and procedures) are not only used for improving performance but also they’re handy when it comes to enhancing security and restricting user access. This post briefs…
Escaping “Lesson Learned” dealing with MySQL Databases & Case Sensitivity
Do you ever need to transfer databases between servers? Different OSes? Two common ways of data migration:1. Create mysqldump and load it.2. File transfer using SCP. MySQL Case Sensitivity and…
MySQL Load Data Infile with Stored Procedure
Did you ever need to run LOAD DATA INFILE in a procedure? May be to automate or dynamically perform the large data file load to the MySQL database. In this…
10 Steps: MySQL Monitoring through Nagios: Install & Configure
Nagios is a powerful monitoring system and here we will learn how to monitor MySQL through Nagios. We will be installing Nagios, required plugins and configuring it to monitor MySQL…
26 responses to “10 Steps: MySQL Monitoring through Nagios: Install & Configure”
This is the nice blog! It is very useful for me to understand the concept of mysql monitoring. I read in this blog that how the data gets changed and who is able to change it and how they all do this. MySQL monitoring is the way to secure your data from an unauthorized user to access your sensitive data.
Great Article… I found it here -> http://www.filewatcher.com/m/check_mysql_health-2.1.3.tar.gz.115861-0.html
Thanks
Hi! great guide It’s very useful for me.
All works fine except the services with name like slave: I have this error:
Command:
/usr/local/nagios/libexec/check_mysql_health –H 127.0.0.1 –port 3306 –username root –password Mikelodeon24- –mode slave-io-running
Error:
_______________________________________________________________________
CRITICAL – unable to get replication info
_______________________________________________________________________
I have the same problem with slave-sql-running also in WEB-GUI…
Whats are slave-io-running and slave-sql-running?
I’m await your anwser,thanks a lot
I’m sorry to keep you waiting so long! Well, so the error appears that it is not able to grab the “replication info” possibly connectivity issue?
Did you try
mysql -uroot -pYourPwd -h 127.0.0.1 -e 'show slave status\G'About your question of io/sql-running… The replication works using two threads…
IO-Thread –> Fetches binary-log from Master & store it as relay-log.
– Let’s say there’s a network issue then you’d get this thread terminated and see slave-io-running as false.
SQL-Thres –> Applies the received relay-log on Slave.
– This will stop in case of sql error and you’d see slave-sql-running as false.
Hope you’d have already figured things out but if not, this helps.
Regards,
Kedar.
Hi,
As per above steps i configured MySQL on nagios 4.1.1v and i am getting output on in background ” ./check_mysql_health -H 127.0.0.1 –port 3306 –username root –password root123 –mode threads-connected ”
But I am unable to get out output on nagios monitoring tool, It showing
” MySQL-Connection-time OK 01-20-2016 12:25:52 0d 0h 0m 11s 1/4 Please select a mode ”
Here “command.cfg” i defined :-
define command{
command_name check_mysql_health
command_line $USER1$/check_mysql_health -H $ARG1$ –username $ARG1$ –password $ARG2$ –port $ARG5$ –mode $ARG3$
}
And on localhost.cfg Service defined :-
define service{
use local-service
host_name NAME
service_description MySQL-Connection-Time
check_command check_mysql_health!root!root123!3306!connection-time!
}
Help me to resolve this issue
Very helpful post with good explanation.
Kedar Can you help me with how to configure nagios for mysql monitoring using percona plugin?
I would be very thankful to you
Please date your articles.
hmmm! Some how the theme is not showing the Year (only date/month)… I’d try to fix this.
Thank you Mark!
Hi ALL,
I configured nagios successfully and didnt get any error and nagios home page loading fine but remaining pages like services hosts, ets not loading and shows “The server encountered an internal error or misconfiguration and was unable
to complete your request.
Please contact the server administrator, root@localhost and inform them of
the time the error occurred, and anything you might have done that may have
caused the error.
More information about this error may be available in the server error
log.”
i issue below command but didn’t get any warning or errors …what could be the reason..
/usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg
Apache/2.2.15 (Red Hat) Server at localhost Port 80 am facing this issue
Hello All,
I am totally new on Linux. And recently I have configured a Nagios 3.4.1 server on Ubuntu 12.04 Desktop version. My Nagios server is running and showing output on web console as well. At the moment I have configured two check_commands (Check_ping and Check_snmp) in which check_ping is working fine and showing output in web console. But check_snmp is not working and my host on web console showing this service as a “critical” service.
And the status Information section of this critical service is showing this message “Service Check Timed Out”.
I have try to find solution on internet but nothing works, maybe as I am totally new so I am missing some configure required for snmp.
For your information:
/usr/local/nagios/libexec is shwoing check_snmp
On my server snmpd is running (I have checked with service snmpd status command)
and I have already installed and complied nagios-plugin-1.4.15 (with the help of commands available in nagios documentation)
Could any one suggest me how could I fix this issue. And if possible can someone share with me the step-by-step setting of SNMP for all the parameters in Nagios/Ubuntu. So that I can cross check my snmp settings.
Many Thanks in advance.
Sunil