Mysql replication checking between 2x servers

[fsodah]

How can perform I Mysql replication checking between 2x servers?

[mbellerue]

It looks like we have a plugin for this on the Exchange.
https://exchange.nagios.org/directory/P ... us/details

This doc will walk you through the process of importing the plugin, and creating a command from it.
https://assets.nagios.com/downloads/nag ... ios-XI.pdf

[fsodah]

Code: Select all

[root@nagios libexec]#  mysql -u nagios -p  -h x.x.x.x
Enter password: 
ERROR 1129 (HY000): Host 'x.x.x.x' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

I am trying my own script

[mbellerue]

It looks like MySQL is blocking your Nagios server.
https://stackoverflow.com/questions/362 ... k-with-mys

[fsodah]

I will check it ... and get back to you

[mbellerue]

Sounds good. We will keep this thread open, and wait to hear back.

[fsodah]

done solved using above link... please close ticket