nagios 监控slave（check_mysql_health插件）

 

# mount /dev/cdrom /media/cdrom

# rpm -ivh /media/cdrom/Server/perl-DBI-1.52-2.el5.i386.rpm # rpm -ivh /media/cdrom/Server/perl-DBD-MsSQL-3.0007-2.el5.i386.rpm --nodeps

# tar zxf check_mysql_health-2.1.7.tar.gz

# cd check_mysql_health-2.1.7 # ./configure # make && make install

 

# mysql -u root -p123456

> grant all on *.* to identified by '123456'; > quit  

下面要借助于nrpe（nrpe安装步骤略）

# vi /usr/local/nagios/etc/nrpe.cfg

command[slave_io_running]=/usr/local/nagios/libexec/check_mysql_health --hostname 192.168.1.10 --port 3306 --username ming --password 123456 --mode slave-io-running --critical No

command[slave_io_running]=/usr/local/nagios/libexec/check_mysql_health --hostname 192.168.1.10 --port 3306 --username ming --password 123456 --mode slave-sql-running --critical No

:wq

重启nrpe：

# killall nrpe

# /usr/local/nagios/bin/nrpe  -c /usr/local/nagios/etc/nrpe.cfg -d

# vi /usr/local/nagios/etc/objects/ming.cfg                     (ming.cfg为监控主机的文件，自建的)

define service{         use                             local-service         ; Name of service template to use         host_name                       myhostname         service_description             slave-io-running         check_command                   check_nrpe!slave_io_running         }

define service{

        use                             local-service         ; Name of service template to use         host_name                       myhostname         service_description             slave-sql-running         check_command                   check_nrpe!slave_sql_running         }

:wq

重启nagios

# service nagios restart