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)
Compatible With
- Nagios 1.x
- Nagios 2.x
- Nagios 3.x
- Nagios XI
Owner
Download URL
Hits
31699
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!