ubuntu nagios监控远程msyql

来源：互联网发布：2016年网络创业平台编辑：程序博客网时间：2024/05/20 16:40

本系列文章旨在记录作者搭建nagios监控的安装及配置步骤，都经过测试，欢迎指正。
nagios简介：
Nagios是一款开源的免费网络监视工具，能有效监控Windows、Linux和Unix的主机状态，交换机路由器等网络设置，打印机等。在系统或服务状态异常时发出邮件或短信报警第一时间通知网站运维人员，在状态恢复后发出正常的邮件或短信通知。
本篇文章将详细说明如何在ubuntu12.04 server 上安装nagios，并监控本机基本信息。
nagios监控主服务器及被监控服务器的配置：《ubuntu 安装配置 nagios》，《ubuntu nagios 配置监控远程主机》

插件：check_mysql_health

插件地址：http://labs.consol.de/lang/en/nagios/check_mysql_health/

用root用户进行一下操作

被监控机：

1).赋予nagios用户msyql权限

GRANT all ON *.* TO 'nagios'@'%' IDENTIFIED BY 'nagios1234';

Flush Privileges;

2).打开mysql远程访问：

vi /etc/mysql/my.cnf

注释掉 bind-address = 127.0.0.1

重启mysql:

service mysql restart

监控主机：

1)下载在/usr/local/src目录下

wget http://labs.consol.de/download/shinken-nagios-plugins/check_mysql_health-2.1.8.2.tar.gz

2).安装

./configure --prefix=/usr/local/nagios --with-nagios-user=nagios --with-nagios-group=nagios

make

make install

3).依赖包安装

sudo apt-get install libclass-dbi-mysql-perl

sudo apt-get install mysql-client-core-5.5 (如果已经安装，则无需再安装)

4).配置监控mysql的命令vi /usr/local/nagios/etc/objects/commands.cfg添加define command{ command_line $USER1$/check_mysql_health --hostname $ARG1$ --port $ARG2$ --username $ARG3$ --password $ARG4$ --mode $ARG5$ }增加：define service{ use generic-service ; Name of service template to use host_name linux-machine1 service_description check_mysql_slave_io check_command check_mysql_health!192.168.0.103!3306!nagios!nagios1234!slave-io-running notifications_enabled 1 }define service{ use generic-service ; Name of service template to use host_name linux-machine1 service_description check_mysql_slave_sql check_command check_mysql_health!192.168.0.103!3306!nagios!nagios1234!slave-sql-running notifications_enabled 1 }define service{ use generic-service ; Name of service template to use host_name linux-machine1 service_description check_mysql_connection_time check_command check_mysql_health!192.168.0.103!3306!nagios!nagios1234!connection-time notifications_enabled 1 }define service{ use generic-service ; Name of service template to use host_name linux-machine1 service_description check_mysql_threads_connected check_command check_mysql_health!192.168.0.103!3306!nagios!nagios1234!threads-connected notifications_enabled 1 }define service{ use generic-service ; Name of service template to use host_name linux-machine1 service_description check_mysql_slow_queries check_command check_mysql_health!192.168.0.103!3306!nagios!nagios1234!slow-queries

notifications_enabled 1 }define service{ use generic-service ; Name of service template to use host_name linux-machine1 service_description check_mysql_table_lock_contention check_command check_mysql_health!192.168.0.103!3306!nagios!nagios1234!table-lock-contention notifications_enabled 1 }7). 没有错误的话重新启动nagioskillall nagios /usr/local/nagios/bin/nagios -d /usr/local/nagios/etc/nagios.cfg

        command_name check_mysql_health

5).在监控该主机的配置文件中增加相应的service

vi /usr/local/nagios/etc/machines/linuxmachine1.cfg

6).检查刚才的修改是否有语法错误

/usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg