Nagios 监控 Mysql

1. 被监控机的Mysql监控
   创建专用数据库、专用数据库账户
   mysql -uroot -p
   create database nagios_monitor;
   grant select on nagios_monitor.* to nagios@'%' 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
           }

   nagios -v nagios.cfg 检查nagios配置文件是否正确
   重启nagios服务即可

2. 监控Mysql并发数
   mysql
   https://github.com/tart/tart-monitoring
   https://exchange.nagios.org/directory/Plugins/Databases/MySQL/check_mysql_connections/details