配置mysql
----建立nagdb专用数据库
|
mysql> create database nagdb default CHARSET=utf8;
|
|
Query OK, 1 row affected (0.01 sec)
|
|
mysql> grant select on nagdb.* to 'nagios'@'%';
|
|
Query OK, 0 rows affected (0.00 sec)
|
|
mysql> update mysql.user set 'Password' = PASSWORD('nagios') where 'User'='nagios';
|
|
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Password' = PASSWORD('nagios') where 'User'='nagios'' at line 1
mysql> update mysql.user set Password = PASSWORD('nagios') where user='nagios';
Query OK, 1 row affected (0.03 sec)
Rows matched: 1 Changed: 1 Warnings: 0
|
|
Query OK, 0 rows affected (0.00 sec)
|
----用以下命令来验证一下：
|
[root@node2 etc]# /usr/local/nagios/libexec/check_mysql -H 192.168.1.152 -u nagios -d nagdb -p nagios
|
|
Uptime: 3374 Threads: 1 Questions: 11 Slow queries: 0 Opens: 33 Flush tables: 1 Open tables: 26 Queries per second avg: 0.003
|
备注:如果出现：/usr/local/nagios/libexec/check_mysql: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory
请查看$MYSQL_HOME/lib
|
[root@node2 lib]# ln -s ./libmysqlclient.so.18.0.0 /usr/lib/libmysqlclient.so.18
|
配置nrpe.cfg
|
[root@node2 etc]# tail /usr/local/nagios/etc/nrpe.cfg
|
|
command[check_mysql]=/usr/local/nagios/libexec/check_mysql -H 192.168.1.152 -u nagios -d nagdb -p nagios //加入此行
|
配置nagios服务端
|
[root@node1 etc]# cat services.cfg //加入下面内容
|
|
define service{
use local-service
host_name node2
service_description mysql
check_command check_nrpe!check_mysql
notifications_enabled 1
}
|
最后重启nrpe和服务端的nagios。
您可能感兴趣的文章:
MySQL性能全面优化方法参考,从CPU,文件系统选择到mysql.cnf参数优化MySQL性能优化的最佳20+条经验mysql性能优化工具--tuner-primer使用介绍数据库Mysql性能优化详解MySQL性能参数详解之Skip-External-Locking参数介绍MySQL性能参数详解之Max_connect_errors 使用介绍MySQL性能瓶颈排查定位实例详解Mysql性能优化方案分享Mysql性能优化案例 - 覆盖索引分享Mysql性能优化案例研究-覆盖索引和SQL_NO_CACHEmysql性能优化之索引优化19个MySQL性能优化要点解析详解MySQL性能优化（二）详解MySQL性能优化（一）10个MySQL性能调优的方法浅谈InnoDB隔离模式的使用对MySQL性能造成的影响使用FriendFeed来提升MySQL性能的方法my.cnf(my.ini)重要参数优化配置说明
