基本信息

• Nagios：Nagios core 4.4.3
• Nagios Plugins：check_mysql_health 2.2.2
• Mysql-server: 192.168.0.91
• db user：db
• 操作流程：下載插件->安裝插件->配置command->添加主機(jī)->添加服務(wù)

安裝插件

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.gz
cd 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
# make
sudo make
# install
sudo make install

配置

配置插件

1. 添加check命令

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

2. 創(chuàng)建主機(jī)配置文件

cd /usr/local/nagios/etc/objects
sudo touch mysql92\1.cfg && sudo chown nagios:nagios mysql91.cfg
# add
# define a host use template linux-server
define host {
    use         linux-server
    host_name       mysql91
    alias       mysql server 91
    address     192.168.0.91
}
# define a new hostgroup
define hostgroup {
    hostgroup_name  mysql-server
    alias       mysql-server
    members     mysql91
}
# define services with template generic-service
# mysql_conn_time
define 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_connected
define 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_queries
define 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_encde
define 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_files
define 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的參數(shù)來設(shè)定檢查項(xiàng)，其他檢查可以參考check_mysql_health mode參數(shù)
4. 檢查Nagios配置文件
   sudo /usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg
   
   check_nagios_cfg
5. 重啟Nagios服務(wù)，打開web界面查看新增的主機(jī)和服務(wù)
   sudo systemctl restart nagios
   
   service

6. 測(cè)試報(bào)警
   將被監(jiān)控主機(jī)的mysql服務(wù)關(guān)閉，查看Nagios Web平臺(tái)中的報(bào)警。

   
   
   alarm

參考

1. check_mysql_health website