PalominoDB Nagios Plugin for MySQL

by SHEERI CABRAL Jun 9, 2011

This post has sample configurations, and an update, to the Nagios plugin called mysql_health_check.pl that PalominoDB has developed.  Presentation slides, the presentation video, the whitepaper and the download link to the actual Nagios check are always up-to-date at http://palominodb.com/about-us/projects.

There has been exciting news for the Nagios plugin PalominoDB developed for MySQL -- we now have --critical and --warning options for all modes (for --varcomp mode we only had a critical option before).

 

Here are some sample configurations (which are also seen in the slides):

To check rate of temporary tables:

define command {
 command_name    check_mysql_tmp_tables
 command_line    $USER1$/mysql_health_check.pl
--hostname $HOSTADDRESS$ --user myuser --password mypass 
--cache-dir=/var/lib/nagios/mysql_cache
--max-cache-age=300 --mode=varcomp 
--expression="Created_tmp_tables/Uptime_since_flush_status" 
--warning=">(8/60)" --critical=">(10/60)"
}
define service {
      use                      generic-service
      host_name                __HOSTNAME__
      service_description      MySQL Temp Tables
      check_command            check_mysql_tmp_tables
}
To check long-running queries (and an example of using a parameter, setting 2 different values one for master servers and one for slave servers):
define command {
 command_name    check_mysql_locked_queries
 command_line    $USER1$/mysql_health_check.pl
--hostname $HOSTADDRESS$ --user myuser --password mypass 
--cache-dir=/var/lib/nagios/mysql_cache
--max-cache-age=300 
--mode=locked-query  
--warning=$ARG1$ --critical=$ARG2$
 }
define service {
      use                      generic-service
      host_name                __HOSTNAME__
      service_description      MySQL Master Locked Queries
      check_command            check_mysql_locked_queries!60!120
}

 


define service {
      use                      generic-service
      host_name                __HOSTNAME__
      service_description      MySQL Slave Locked Queries
      check_command            check_mysql_locked_queries!300!600
}

If there are questions, comments or feedback, please let us know!

Posted in MySQL, Palomino, Presentations

Comments

Reply

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

More information about formatting options

By submitting this form, you accept the Mollom privacy policy.
Website by Digital Loom