check mysql health_利用check_mysql_health监控mysql数据

下载地址

https://labs.consol.de/nagios/check_mysql_health/index.html

安装

nagios安装配置省略. . . .

#yum install perl-DBI perl-DBD-MySQL# tar -zxf check_mysql_health-2.2.1

./configure --prefix=/usr/local/nagios/

make && make install

登录mysql

mysql> grant usage,select on *.* to "nagios"@"%" identified by "nagios";测试命令1

# ./check_mysql_health --hostname 10.10.9.91 --port 3307 --username nagios --password nagios --mode threads-connected --warning 120 --critical 150

OK - 109 client connection threads | threads_connected=109;120;150

测试命令2(需要执行sql语句)

1.语句转换

#echo 'SELECT COUNT(*)  FROM zjb.zjb_data_tc_only_20160410'|/usr/local/nagios/libexec/check_mysql_health --mode encode

SELECT%20COUNT%28%2A%29%20%20FROM%20zjb%2Ezjb%5Fdata%5Ftc%5Fonly%5F20160410

2.测试

# ./check_mysql_health --hostname 10.10.9.91 --port 3307 --username nagios --password nagios --mode sql --name SELECT%20COUNT%28%2A%29%20%20FROM%20zjb%2Ezjb%5Fdata%5Ftc%5Fonly%5F20160410 --warning 180000 --critical 220000

WARNING - select count(*)  from zjb.zjb_data_tc_only_20160410: 202081 | 'select'=202081;180000;220000

定义命令

# vim /usr/local/nagios/etc/objects/commands.cfg

define command{

command_name check_mysql_connected

command_line $USER1$/check_mysql_health --hostname 10.10.9.91 --port 3307 --username $ARG1$ --password $ARG2$ --mode threads-connected --warning $ARG3$  --critical $ARG4$

}

定义服务

vim /usr/local/nagios/etc/objects/91.cfg

define service{

use                             local-service         ; Name of service template to use

host_name                       91

service_description             Mysql_connected

check_command                   check_mysql_connected!nagios!nagios!120!150

}