基本信息

• Nagios：Nagios core 4.4.3
• Nagios Plugins：check_mysql_health 2.2.2
• Mysql-server: 192.168.0.91
• db user：db
• 操作流程：下载插件->安装插件->配置command->添加主机->添加服务

安装插件

1. 下载 wget https://labs.consol.de/assets/downloads/nagios/check_mysql_health-2.2.2.tar.gz
2. 配置、编译、安装

tar -xzvf check_mysql_health-2.2.2.tar.gzcd check_mysql_health-2.2.2# configure./configure --prefix=/usr/local/nagios/libexec --with-nagios-user=nagios --with-nagios-group=nagios --with-perl=/usr/bin/perl# makesudo make# installsudo make install复制代码

配置

配置插件

1. 添加check命令

cd /usr/local/nagios/etc/objects/sudo vi commands.cfg## adddefine command {    command_name check_mysql_health    command_line $USER1$/check_mysql_health -H $ARG1$ --username $ARG2$ --password $ARG3$ --port $ARG4$ --mode $ARG5$	}复制代码

2. 创建主机配置文件

cd /usr/local/nagios/etc/objectssudo touch mysql92\1.cfg && sudo chown nagios:nagios mysql91.cfg# add# define a host use template linux-serverdefine host {    use			linux-server    host_name		mysql91    alias		mysql server 91    address		192.168.0.91}# define a new hostgroupdefine hostgroup {    hostgroup_name	mysql-server    alias		mysql-server    members		mysql91}# define services with template generic-service# mysql_conn_timedefine service {    use			generic-service    host_name		mysql91    service_description	mysql_conn_time    check_command	check_mysql_health!192.168.0.91!db!MysqlPasswd2019!3306!connection-time!}# mysql_threads_connecteddefine service {    use			generic-service    host_name		mysql91    service_description	mysql_threads_connected    check_command	check_mysql_health!192.168.0.91!db!MysqlPasswd2019!3306!threads-connected!}# mysql_slow_queriesdefine service {    use			generic-service    host_name		mysql91    service_description mysql_slow_queries    check_command	check_mysql_health!192.168.0.91!db!MysqlPasswd2019!3306!slow-queries!}# mysql_encdedefine service {    use			generic-service    host_name		mysql91    service_description mysql_sql    check_command	check_mysql_health!192.168.0.91!db!MysqlPasswd2019!3306!encode!}# mysql_open_filesdefine service {    use			generic-service    host_name		mysql91    service_description mysql_open_files    check_command	check_mysql_health!192.168.0.91!db!MysqlPasswd2019!3306!open-files!}复制代码

3. 更多Mysql检查
   check_mysql_health插件通过修改--mode的参数来设定检查项，其他检查可以参考
4. 检查Nagios配置文件
   sudo /usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg [站外图片上传中...(image-396093-1556865444556)]
5. 重启Nagios服务，打开web界面查看新增的主机和服务
   sudo systemctl restart nagios

6. 测试报警
   将被监控主机的mysql服务关闭，查看Nagios Web平台中的报警。

参考