- nagios监控mysql服务器:
- 1、建立专用数据库:
- [root@svr3 ~]# /usr/local/webserver/mysql/bin/mysql -u root -p
- Enter password:
- Welcome to the MySQL monitor. Commands end with ; or \g.
- Your MySQL connection id is 51910
- Server version: 5.5.3-m3-log Source distribution
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
- mysql> create database nagios;
- Query OK, 1 row affected (0.00 sec)
- mysql> grant select on nagios.* to nagios@'%' identified by '123qweasd';
- Query OK, 0 rows affected (0.00 sec)
- mysql> flush privileges;
- Query OK, 0 rows affected (0.00 sec)
- mysql> select User,Password,Host from user;
- +----------------+-------------------------------------------+------------------+
- | User | Password | Host |
- +----------------+-------------------------------------------+------------------+
- | root | *84BB5DF4823DA319BBF86C99624479A198E6EEE9 | localhost |
- | nagios | *A1F1CB851D62F002C09A0C9C4A76262473432F55 | % |
- +----------------+-------------------------------------------+------------------+
- 14 rows in set (0.00 sec)
- 12 rows in set (0.00 sec)
- [root@svr3 ~]# /usr/local/nagios/libexec/check_mysql -H 10.1.1.30 -u nagios -d nagios -p 123qweasd
- Uptime: 970046 Threads: 1 Questions: 684583 Slow queries: 3 Opens: 672 Flush tables: 1 Open tables:
- 369 Queries per second avg: 0.705
- [root@svr4 nrpe_install]# /usr/local/nagios/libexec/check_mysql -H 10.1.1.30 -u nagios -d nagios -p 123qweasd
- Uptime: 970348 Threads: 1 Questions: 684584 Slow queries: 3 Opens: 672 Flush tables: 1 Open tables: 369 Queries per second avg: 0.705
- 果断开始设置:
- #定义用户
- #定义组,及隶属用户
- #用户增加
- 在command.cfg里增加插件命令:
- #check mysql
- define command{
- command_name check_mysql
- command_line $USER1$/check_mysql -H $HOSTADDRESS$ -u nagios -d nagios -p 123qweasd
- }
- #定义服务:
- define service {
- host_name svr3.labexam.com
- service_description MysqlDB
- check_period 24x7
- max_check_attempts 2
- normal_check_interval 1
- retry_check_interval 1
- contact_groups sagroup,dbagroup
- notification_interval 5
- notification_period 24x7
- notification_options w,u,c,r
- check_command check_mysql
- }
- 感谢秋香老师,你的书给了我很大帮助。
转载于:https://blog.51cto.com/myhat/654952