MySQL性能監(jiān)控軟件Nagios的安裝及配置教程_MySQL

 yum install httpd gcc make perl-ExtUtils-Embed.x86_64 -y
 yum localinstall gd-devel-2.0.35-11.el6.x86_64.rpm -y

useradd nagios
usermod -G nagios apache
#編譯所需軟件包
#運行 nagios 服務(wù)的用戶
#使 apache 用戶對 nagios 目錄具有寫權(quán)限,不然 web 頁面操作失敗
tar jxf nagios-cn-3.2.3.tar.bz2
#nagios 軟件安裝
cd nagios-cn-3.2.3
./configure –enable-embedded-perl
make all //根據(jù)提示完成安裝
make install
make install-init
make install-commandmode
make install-config
make install-webconf //在apache下通過這條命令可以快速整合

yum install mysql-devel openssl-devel -y
tar zxf nagios-plugins-1.4.15.tar.gz
cd nagios-plugins-1.4.15
./configure --with-nagios-user=nagios --with-nagios-group=nagios --enable-extra-opts --enable-libtap --enable
-perl-modules
make
make install

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

 #cfg_file=/usr/local/nagios/etc/objects/localhost.cfg #注釋掉localhost.cfg文件
 cfg_file=/usr/local/nagios/etc/objects/services.cfg #新建 services.cfg 文件,存放服務(wù)與服務(wù)組定義
 cfg_file=/usr/local/nagios/etc/objects/hosts.cfg #新建 hosts.cfg 文件,存放主機與主機組定義

vi /usr/local/nagios/etc/objects/hosts.cfg

define host{ //主機的管理
use linux-server //使用默認(rèn)的主機規(guī)則
host_name vm2.example.com //主機名
alias Nagios vm2 //主機別名
address 127.0.0.1 //主機ip地址
icon_image switch.gif //圖標(biāo)
statusmap_image switch.gd2 
2d_coords 100,200 //2D圖像坐標(biāo)
3d_coords 100,200,100 //3D圖像坐標(biāo)
}
define hostgroup{ //主機組的管理
hostgroup_name linux-servers //主機組名字
alias Linux Servers //別名
members * //*代表上面所有主機

mysql> create database nagdb default CHARSET=utf8;

Query OK, 1 row affected (0.01 sec)

mysql> grant select on nagdb.* to 'nagios'@'%';

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

mysql> flush privileges;

[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

[root@node2 lib]# ln -s ./libmysqlclient.so.18.0.0 /usr/lib/libmysqlclient.so.18

[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 
//加入此行

[root@node1 etc]# cat services.cfg //加入下面內(nèi)容

define service{
 use local-service
 host_name node2
 service_description mysql
 check_command check_nrpe!check_mysql
 notifications_enabled 1
 }