nagios监控mysql5.6.17-1.docx

在mysql服务器安装check_mysql_health首先在mysql被监控机安装nagios-plugins以及nrpe-,过程不在详细描述。安装check_mysql_healthtar zxvf check_mysql_health- -C ../software/./configure--prefix=/usr/local/nagios/--with-mysql=/var/lib/mysql/make&&makeinstallyuminstallperl-DBIperl-DBD-MySQL–y这两个必须安装否则运行check_mysql_health命令的时候,会报错在安装perl-DBD-MySQL的过程中遇到了一个问题在装好mysql的机器里,没有mysql-libs包,在yum安装的时候,会报错,-1,但是yum装的mysql-libs版本为mysql-libs--,我采取了强制安装的方法yuminstall-yyum-downloadonly安装yum下载功yuminstallperl-DBD-MySQL-y--downloadonly--downloaddir=/opt下载perl-DBD-MySQL的依赖包rpm-ivhmysql-libs----force–nodeps强制安装mysql-libsrpm-ivhperl-DBD-MySQL----force–nodeps强制安装perl-DBD因为mysql的机器开启了防火墙,mysql用的是3307端口,所以在防火墙中打开3307端口iptables-IINPUT-ptcp--dport3307-EPT防火墙打开3307端口/etc//iptablesrestart重启防火墙测试命令/usr/local/nagios/libexec/check_mysql_health--usernamenagios-password123456-port3307-modethreads-connectedOK-1clientconnectionthreads|threads_connected=1;10;20-hostname被监控端(数据库所在机器)的地址-username要监控的database用户的名称-database要监控的database的名称默认为information_schema-password要监控的databases密码-port数据库端口如不写就是默认3306-:connection-time(Timetoconnecttotheserver)uptime(Timetheserverisrunning)threads-connected(Numberofcurrentlyopenconnections)thre