Mysql daemin check on remote host

[benhank]

Hello all !

I have nagios setup with it's mysql db located on a remote host.
How do I set up checks to monitor the mysql daemon (and as a bonus, other critical spects of mysql) for this type of setup?

[scottwilkerson]

How about a 2nd Nagios XI server?

This need not be a licensed server as you can run 7 hosts or less on a free license.

You can monitor both your XI server, and MySQL checks on the separate MySQL server from this seperate machine to make sure they both are online.

[benhank]

another nagios server.... hmmm

Thought bubble appears and a movie begins to play within as Ben Hank ponders how that would go...

Ben sits down with the All Powerful Controller of the Money. He glances around the office, noticing that every conceivable surface appears to be covered with beans. Upon closer inspection he notices that every bean seems to be tagged and labeled with barcodes and price tags. The APCM (whose name no one in the office knows for some reason), sits at his desk exhaling a thick cloud of cigar smoke. Which is odd because there is no cigar in his mouth. He speaks "yes Mr, Hankerson, what can I do for you"
Ben, sweating bullets by now repeats the mantra he has been repeating in his mind for some time now: "Scott makes sense just say what scott said"
Ben screw up his courage and answers: "um, sir, I would like to purchase a new nagios ser..."

Epilogue:
It is a cold and gray day at the cemetery. The wife and children of the late Ben Hankerson are huddled together crying. Son number 1 looks up unto the tear streaks face of his mom and asks the question that has been on all their minds since the 'incident"
"Why did he do it mommy? Why did he do it?" "Didn't daddy love us?"
His mom, a strong woman decides to tell her poor fatherless child the truth:
'Your dad loved you son number 1"
"but...as far as we can tell your father must have gone crazy"

[ssax]

I personally would just install the NRPE or NCPA agent on the remote machine and check the mysql service status, and use the MySQL Wizards for the other queries you may be interested in.

Another plugin you might want to use is to check for crashed tables:

https://exchange.nagios.org/directory/P ... us/details

[scottwilkerson]

Ben, sweating bullets by now repeats the mantra he has been repeating in his mind for some time now: "Scott makes sense just say what scott said"
Ben screw up his courage and answers: "um, sir, I would like to purchase a new nagios ser..."

Thanks for always brightening our Fridays

[benhank]

=D yeah, if possible it would be safer...to check the daemon on the remote server from currently purchased equipment lol.
I do see your point tho. since mysql is on the remote server, and the daemon dies, then I would not be able to access nagios in the first place. Maybe I can use a test box and re-purpose it, but even in that case how would I set up the checks?

[scottwilkerson]

=D yeah, if possible it would be safer...to check the daemon on the remote server from currently purchased equipment lol.
I do see your point tho. since mysql is on the remote server, and the daemon dies, then I would not be able to access nagios in the first place. Maybe I can use a test box and re-purpose it, but even in that case how would I set up the checks?

You can just use the MySQL Wizard and the Nagios XI Server Wizard (yes we even have a wizard to check other Nagios XI machines for just this purpose).

And the XI server I'm proposing can be a very small VM if it is only monitoring these 2 hosts...

[benhank]

hokay Fellas thanks! you can lock this one up!

[scottwilkerson]

hokay Fellas thanks! you can lock this one up!

Great!

Locking