Home Directory Plugins Databases check_mysql_config.pl (Advanced Nagios Plugins Collection)

Search Exchange

Search All Sites

Nagios Live Webinars

Let our experts show you how Nagios can help your organization.

Contact Us

Phone: 1-888-NAGIOS-1
Email: sales@nagios.com

Login

Remember Me

Directory Tree

check_mysql_config.pl (Advanced Nagios Plugins Collection)

Rating
0 votes
Favoured:
0
Compatible With
  • Nagios 1.x
  • Nagios 2.x
  • Nagios 3.x
  • Nagios XI
Hits
31803
Nagios CSP

Meet The New Nagios Core Services Platform

Built on over 25 years of monitoring experience, the Nagios Core Services Platform provides insightful monitoring dashboards, time-saving monitoring wizards, and unmatched ease of use. Use it for free indefinitely.

Monitoring Made Magically Better

  • Nagios Core on Overdrive
  • Powerful Monitoring Dashboards
  • Time-Saving Configuration Wizards
  • Open Source Powered Monitoring On Steroids
  • And So Much More!
Checks MySQL config file matches running MySQL server configuration. Primarily written to check that DBAs hadn't changed any running DB from Puppet deployed config without backporting their changes.
Part of the Advanced Nagios Plugins Collection, download it here:

https://github.com/harisekhon/nagios-plugins

./check_mysql_config.pl --help

Nagios Plugin to check MySQL config file matches running MySQL server configuration

Primarily written to check that DBAs hadn't changed any running DB from Puppet deployed config without backporting their changes

A friend and ex-colleague of mine Tom Liakos @ Specificmedia pointed out a long time after I wrote this that Percona independently developed a similar tool called pt-config-diff (part of the Percona toolkit) around the same time.

usage: check_mysql_config.pl [ options ]

-c --config --config-file Path to MySQL my.cnf config file (default: /etc/my.cnf)
-H --host MySQL host to check (default: 127.0.0.1). Set to blank to connect via socket
-P --port MySQL port to connect to (default: 3306)
-u --mysql-user MySQL username to use to connect to local MySQL connection (default: root)
-p --mysql-password MySQL Password to use to connect to local MySQL connection (default: empty)
-d --mysql-instance MySQL [instance] in my.cnf to test (default: mysqld)
--skip-name-resolve Ensure that skip-name-resolve is specified in the config file
--warn-on-missing Return warning when there my.cnf variables missing from running MySQL config. Default is just to list them but return OK unless there is an actual mismatch. Useful if you want to make sure they're all accounted for as sometimes they only appear in config file or the live name is different to the config file name
-s --mysql-socket MySQL socket file through which to connect (default: /var/lib/mysql/mysql.sock)
-h --help Print description and usage options
-t --timeout Timeout in secs (default: 10)
-v --verbose Verbose mode
-V --version Print version and exit