Nagios 監控 Mysql

標籤：

1. 被監控機的Mysql監控
   建立專用資料庫、專用資料庫賬戶
   mysql -uroot -p
   create database nagios_monitor;
   grant select on nagios_monitor.* to [email protected]‘%‘ identified by ‘nagiosMonitor‘;
   flush privileges;
   exit;
   測試check_mysql指令碼運行是否正常
   cd /usr/lib64/nagios/plugins
   ./check_mysql -unagios -pnagiosMonitor
   
   編輯nrpe.cfg檔案
   vi /usr/local/nagios/etc/nrpe.cfg 添加如下一行
   command[check_mysql]=/usr/lib64/nagios/plugins/check_mysql -unagios -pnagiosMonitor
   回到nagios監控伺服器
   修改services.cfg檔案
   vi /etc/nagios/objects/services.cfg
   添加如下代碼
   

   define service{        use                     generic-service        host_name               Nagios_Centos_Client1        service_description     Mysql Monitoring        check_command           check_nrpe!check_mysql        }

   check_mysql Code

   nagios -v nagios.cfg 檢查nagios設定檔是否正確
   重啟nagios服務即可

   
   
   
   
   
   

Nagios 監控 Mysql