Page 1 of 1

Mysql replication checking between 2x servers

Posted: Sun Nov 10, 2019 2:22 pm
by fsodah
How can perform I Mysql replication checking between 2x servers?

Re: Mysql replication checking between 2x servers

Posted: Mon Nov 11, 2019 11:53 am
by 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

Re: Mysql replication checking between 2x servers

Posted: Mon Nov 11, 2019 12:57 pm
by 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

Re: Mysql replication checking between 2x servers

Posted: Mon Nov 11, 2019 2:25 pm
by mbellerue
It looks like MySQL is blocking your Nagios server.
https://stackoverflow.com/questions/362 ... k-with-mys

Re: Mysql replication checking between 2x servers

Posted: Mon Nov 11, 2019 2:47 pm
by fsodah
I will check it ... and get back to you

Re: Mysql replication checking between 2x servers

Posted: Mon Nov 11, 2019 3:02 pm
by mbellerue
Sounds good. We will keep this thread open, and wait to hear back.

Re: Mysql replication checking between 2x servers

Posted: Tue Nov 12, 2019 3:11 pm
by fsodah
done solved using above link... please close ticket