MySQL Forums
Forum List  »  Merge Storage Engine

Re: Nagios configuration to monitor MySQL
Posted by: Sourygna Luangsay
Date: July 29, 2008 02:00AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Nagios configuration to monitor MySQL
23651
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.