Page 1 of 1
Monitoring MYSQL Database replication
Posted: Fri May 18, 2012 8:19 am
by jcamillo
What is the best way to monitor Nagios XI database replication?
Re: Monitoring MYSQL Database replication
Posted: Fri May 18, 2012 9:11 am
by scottwilkerson
Can you be a little more specific. Are you replicating your nagios database to a different machine and want to monitor that?
There are several items on the exchange for monitoring replication
http://exchange.nagios.org/index.php?op ... eplication
Re: Monitoring MYSQL Database replication
Posted: Sat May 19, 2012 10:10 pm
by jcamillo
Sorry about that, I am actually monitoring MYSQL replication to the backup server.
Thank you
Re: Monitoring MYSQL Database replication
Posted: Mon May 21, 2012 3:09 pm
by scottwilkerson
You could run the MySQL wizard and check the "Slave" items on the bottom of the page.
Also, you could craft a query that should yield a result and run the mysql query wizard with that query... Something like
Select the nagios database
use the following query
Code: Select all
SELECT NOW()-status_update_time FROM nagios_programstatus
the warning and critical levels will represent seconds