Search Exchange
Search All Sites
Nagios Live Webinars
Let our experts show you how Nagios can help your organization.Login
Directory Tree
check_mysql_config.pl (Advanced Nagios Plugins Collection)
- Nagios 1.x
- Nagios 2.x
- Nagios 3.x
- Nagios XI
31803
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!
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
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
Reviews (0)
Be the first to review this listing!