check_mysql_health

Everything works great until SSL is enabled. To get this working with SSL you have to use an additional cnf. Then, when using that cnf it no longer accepts the host/port params so they have to be called out in a cnfgroup (in the file). Its just kind of awkwardly designed it seems. In order to add a new db for monitoring you either have to create a new cnfgroup in the cnf file or create a new cnf. In order to integrate smoothly with our monitoring system Opsview, this needs to be able to accept all arguments at the commandline.

So we would need minimally params for ssl-ca and ssl-mode that would get passed into DBI. I think we are going to try to re-write the code for this. Also, would be nice if Consol put their code in revision control so the community can help improve/maintain it.

In case this may help anyone, this is what you need to do to execute against AWS RDS:
./check_mysql_health --mode connection-time --database myDBName --username 'username' --password 'userpassword' --warning 1 --critical 5 --environment NAGIOS__SERVICEMYSQL_MYCNF='/mnt/opsview/usr/local/nagios/etc/mysql_rds.cnf' --environment NAGIOS__SERVICEMYSQL_MYCNFGROUP='groupName'

download the RDS cert bundle and put that with your certs:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.SSL.html

In the cnf file I have specified above, I have these contents:

[client]
ssl-ca = /etc/ldap/cacerts/rds-combined-ca-bundle.pem
ssl-mode = 'VERIFY_CA'

[groupName]
host = MyHostname.us-east-1.rds.amazonaws.com
port = 12345

The Nagios plugin may be really nice. I just don't have much experience with it right now. However, when I started trying it, it just came up with:

Can't locate object method "new" via package "DBD::MySQL::Server::Instance" (perhaps you forgot to load "DBD::MySQL::Server::Instance"?) at Nagios/DBD/MySQL/Server.pm line 85.

I was looking for such issues on the internet and didn't find any helpful topic. I wonder if I really am the only one on the world wide web having that issue.

However, I found out that a change of the line 85 in the mentioned file from:

$self->{instance} = DBD::MySQL::Server::Instance->new(%params);

to:

$self->{instance} = DBD::MySQL::Server->new(%params);

was helpful. Just as remark.

Great plugin, love the functionality!

The MySQL CLI now emits an annoying warning message: "Warning: Using a password on the command line interface can be insecure."

Seems the best way to slience this warning is to use the switch:
--defaults-file

Feature request - please add:
defaults-file /path/to/creds.cnf

Great plugin, but I do have a fairly big problem I've just noticed, we use a .my.cnf file for all username and password (Which is common across the company for the nagios mysql user), however we need to specify hostname in the command for obvious reasons.

However, when you run the script with the mycnf option, it doesn't parse the hostname and goes to localhost instead.

So I ended up with 20machines all with the same mysql health values!

If you use --hostname --user and --pass as normal, the script works great hence the good rating, but if I can submit a bug report somewhere that would be ace.

Cheers,
Chris

Great product, but cpu busy is not coming back very useful and I had to disable it. here is a link that explains a better way to do it.

http://strictlysql.blogspot.com/2010/06/finding-cpu-utilization-in-sql-server.html

I'd like to download this plugin, but there are no files listed and there's no download link as well.

This plugin is brilliant. Very easy to set up and gets all the lovely perfdata I need to have historic and highly valuable hard numbers to tune our MySQL servers and application code. No more naysayers with the complaining that 'changing for the sake of changing is not a solution'.

Also the checking of MySQL replication is very awesome.

This plugin defeats any reasons we had for using the MySQL Enterprise Manager software. Saving dollars and cents.