基本信息

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

安裝插件

下載 wget https://labs.consol.de/assets/downloads/nagios/check_mysql_health-2.2.2.tar.gz

配置、編譯、安裝

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 復制代碼

配置

配置插件

添加check命令

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

創建主機配置文件

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-serverhost_name mysql91alias mysql server 91address 192.168.0.91 } # define a new hostgroup define hostgroup {hostgroup_name mysql-serveralias mysql-servermembers mysql91 } # define services with template generic-service # mysql_conn_time define service {use generic-servicehost_name mysql91service_description mysql_conn_timecheck_command check_mysql_health!192.168.0.91!db!MysqlPasswd2019!3306!connection-time! } # mysql_threads_connected define service {use generic-servicehost_name mysql91service_description mysql_threads_connectedcheck_command check_mysql_health!192.168.0.91!db!MysqlPasswd2019!3306!threads-connected! } # mysql_slow_queries define service {use generic-servicehost_name mysql91service_description mysql_slow_queriescheck_command check_mysql_health!192.168.0.91!db!MysqlPasswd2019!3306!slow-queries! } # mysql_encde define service {use generic-servicehost_name mysql91service_description mysql_sqlcheck_command check_mysql_health!192.168.0.91!db!MysqlPasswd2019!3306!encode! } # mysql_open_files define service {use generic-servicehost_name mysql91service_description mysql_open_filescheck_command check_mysql_health!192.168.0.91!db!MysqlPasswd2019!3306!open-files! } 復制代碼

更多Mysql檢查
check_mysql_health插件通過修改--mode的參數來設定檢查項，其他檢查可以參考check_mysql_health mode參數

檢查Nagios配置文件
sudo /usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg [站外圖片上傳中...(image-396093-1556865444556)]

重啟Nagios服務，打開web界面查看新增的主機和服務
sudo systemctl restart nagios

測試報警
將被監控主機的mysql服務關閉，查看Nagios Web平臺中的報警。

參考

check_mysql_health website

轉載于:https://juejin.im/post/5ccbe1c351882541ca0344f2

總結

以上是生活随笔為你收集整理的Nagios使用check_mysql_health插件监控Mysql主机的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。