Page 1 of 1

HOWTO check backup datetime in MySQL?

Posted: Thu Nov 17, 2016 4:06 am
by kithai
Hi guys!

So i'm totally newbie in Nagios, these are my first steps on it so here i am again asking for help :oops:
I'm looking on the internet for one plugin that can check backup datetimes on MySQL (and Oracle if it's possible) DB's, like the check_mssql_health plugin does.
But can't find anything like that. So the question is, do you know any plugin that allow me check that? Maybe with NRPE can be possible, or NRPE is just to check perfomance?

My next step on learning nagios is installing a NRPE agent in a printer server, just to know how it works and what allows me to do

Once again, thank you so much!

Re: HOWTO check backup datetime in MySQL?

Posted: Thu Nov 17, 2016 12:02 pm
by dwhitfield
NRPE could certainly do it, and if security is a concern, it is a good option. If security is a big concern, then check_by_ssh is a better option. Of course, there is a performance hit using check_by_ssh.

You probably already know, but the NRPE documentation is at https://assets.nagios.com/downloads/nag ... e/NRPE.pdf

As for MySQL, there a bunch of different plugins: https://exchange.nagios.org/directory/P ... ases/MySQL

If you tell us how exactly you are backing up MySQL (same machine, remote backup, etc.), we can help you a little more with the MySQL side.