nagios监控mysql方法
nagios中添加mysql监控：
1.在要监控的数据库服务器新建库和用户：
- CREATE DATABASE nagdb DEFAULT CHARSET=utf8;
- GRANT SELECT ON nagdb.* TO ‘nagios’@'192.168.100.%’;
- UPDATE mysql.user SET `Password` = PASSWORD(‘********’) WHERE `User` = ‘nagios’
- FLUSH PRIVILEGES;
2.被监控端安装：
- apt-get install libmysqlclient15-dev
- ./configure –with-mysql=/opt/mysql or /var/mysql/ #针对每台数据库服务器的路径不同
- make
- make distclean
- make all
- vi /usr/local/nagios/etc/nrpe.cfg
添加：
- command[check_mysql_status]=/usr/local/nagios/libexec/check_mysql -H 192.168.100.200 -u nagios -d nagdb -p ‘nagios_4_dxy!’
3.监控端服务器：
- vi /usr/local/nagios/etc/objects/commands.cfg
添加：
- #check_mysql
- define command{
- command_name check_mysql
- command_line $USER1$/check_Mysql -H $HOSTADDRESS$ -u nagios -d nagdb -p *******
- }
4.在监控端服务器的*.cfg中添加：
- define service{
- use generic-service
- host_name Stalingrad-server
- service_description check_mysql
- check_command check_nrpe!check_mysql_status
- notifications_enabled 0
- }
5.重启nagios。Nagios监控Mysql就可以啦。
【编辑推荐】
