Re: Nagios configuration to monitor MySQL
Hello,
To check mysql with the nagios plugin check_mysql_query, I first create a non privilege user 'nagiosCheck'.
Then, I add the following line in the nrpe.cfg file :
command[check_mysqld]=/usr/lib/nagios/plugins/check_mysql_query -q 'select 1+2' -u nagiosCheck -p 'password' -w 3:3 -c 3:3
The query is quite stupid but it aims to function in every database (I don't have to know what all my clients'databases contain).
What is more, this test does a login operation so I may see if there is a problem in the mysql database.
Sourygna
Subject
Views
Written By
Posted
33571
July 04, 2008 02:36AM
Re: Nagios configuration to monitor MySQL
24358
July 29, 2008 02:00AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.