Nagios and Icinga plugins for MySQL 1.0.0 have been released

FromDual has the pleasure to announce the release of the new version 1.0.0 of its widely used Nagios and Icinga plugins for MySQL, Galera Cluster, MariaDB and Percona Server.

All plugins are basically renewed and should now work all correctly.

The new Nagios/Icinga plugins can be downloaded here.

In the inconceivable case that you find a bug in the Nagios/Icinga plugins please report it to our bug tracker.

Any feedback, statements and testimonials are welcome as well! Please send them to feedback@fromdual.com.

Description of the current functionality

Details about the functionality and the usage of each plugin you get with the option: --help.

The following Nagios/Icinga plugin for MySQL and MariaDB are currently available:

check_db_mysql.pl

This Nagios/Icinga plugin alerts you if your MySQL database is not up and running.

check_errorlog_mysql.pl and errorLogFilterRules.pm

This Nagios/Icinga plugin alerts you if it finds some suspicious messages in the MySQL error log.
The rules which messages should be ignored can be found in the file errorLogFilterRules.pm. If you want to add your own filter rules please add them in this file as well.

check_galera_nodes.pl

This Nagios/Icinga plugin alerts you if the actual number of nodes in your a Galera Cluster is not the expected one.

check_repl_mysql_cnt_slave_hosts.pl

This Nagios/Icinga plugin alerts you if your MySQL Slaves have not reported to their Master properly their existence with the report_host variable.

check_repl_mysql_heartbeat.pl

This Nagios/Icinga plugin alerts you if your MySQL Slave is too many heartbeats behind its Master.

check_repl_mysql_io_thread.pl

This Nagios/Icinga plugin alerts you if your MySQL Slaves IO thread is not up an running.

check_repl_mysql_read_exec_pos.pl

This Nagios/Icinga plugin alerts you if your MySQL Slaves read and execution positions differ too much.

check_repl_mysql_readonly.pl

This Nagios/Icinga plugin alerts you if your MySQL Slave is NOT set to readonly.

check_repl_mysql_seconds_behind_master.pl

This Nagios/Icinga plugin alerts you if your MySQL Slave falls too many seconds behind its Master.

check_repl_mysql_sql_thread.pl

This Nagios/Icinga plugin alerts you if your Slaves SQL thread is not up an running.

perf_mysql.pl

This Nagios/Icinga plugin gathers MySQL and MariaDB performance data.

Changes in FromDual Nagios/Icinga plugins 1.0.0

All plugins

• Usage was improved. The usage can be shown with the --help option.
• Usage states now which GRANT privileges are needed for a specific plugin.
• Examples added how to use each plugin.
• Default socket location moved from /tmp/mysql.sock to /var/run/mysqld/mysqld.sock.
• New host/socket convention implemented in all scripts similar to MySQL client tools.
• -epn tag added for Icinga.

check_errorlog_mysql.pl

• Some bugs fixed.
• More filtering rules added.
• Filtering rules separated into own file.
• Entry point finding problem fixed.

check_repl_mysql_heartbeat.pl

• Script name fixed.

check_db.pl

• Unknown command problem with Galera Cluster caught.
• mysqladmin ping removed and implemented in Perl.

Support and Subscription for commercial use

For subscriptions for commercial use of this software please get in contact with us.