Monitoring MYSQL Database replication

[jcamillo]

What is the best way to monitor Nagios XI database replication?

[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

[jcamillo]

Sorry about that, I am actually monitoring MYSQL replication to the backup server.

Thank you

[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