【移動應用開發(fā)技術】nagios 監(jiān)控mysql主從復制

【移動應用開發(fā)技術】nagios監(jiān)控mysql主從復制

檢測mysql主從

一、先安裝nrpe，這樣可以實現(xiàn)在遠程主機上執(zhí)行命令

nagios主機

mysql主機

被監(jiān)控主機

安裝nrpe的server端

tarfvxznrpe*.tar.gz

./configure--prefix=/usr/local/nagios

useraddnagios

make

makeinstall-daemon

makeinstall-daemon-config

makeinstall-xinetd

makeinstall

把插件拷貝給監(jiān)控主機nagios

scp/usr/local/nagios/libexec/check_nrpe

root@ip:/usr/local/nagios/libexec

在被監(jiān)控主機開啟nrpe服務

vim/etc/xinetd.d/nrpe

#default:on

#description:NRPE(NagiosRemotePluginExecutor)

servicenrpe{

flags

=REUSE

socket_type

=stream

port

=5666

wait

=no

user

=nagios

group

=nagios

server

=/usr/local/nagios/bin/nrpe

server_args

=-c/usr/local/nagios/etc/nrpe.cfg--inetd

log_on_failure

+=USERID

disable

=no

only_from

=

＃監(jiān)控主機的ip，保證他可以連接進來！

}

vim/etc/services

nrpe5666/tcp

servicexinetdrestart在監(jiān)控主機上測試

[root@server1objects]#/usr/local/nagios/libexec/check_nrpe-H88

NRPEv2.12在被監(jiān)控主機安裝插件vim/usr/local/nagios/etc/nrpe.cfg

command[check_users]=/usr/local/nagios/libexec/check_users-w5-c10

command[check_u]=/usr/local/nagios/libexec/check_users-w5-c10

command[check_load]=/usr/local/nagios/libexec/check_load-w15,10,5-c30,25,20

command[check_hda1]=/usr/local/nagios/libexec/check_disk-w20%-c10%-p/dev/hda1

command[check_zombie_procs]=/usr/local/nagios/libexec/check_procs-w5-c10-sZ

command[check_total_procs]=/usr/local/nagios/libexec/check_procs-w150-c200通過以上字段來定義命令，以及接收命令后執(zhí)行的插件，就是可以在遠程主機上執(zhí)行的命令。定義服務，來檢測一下

definehost{

host_name

mysql-server

alias

nrpe-server

address

check_command

check-host-alive

notification_options

d,u,r

check_interval

1

max_check_attempts

2

contact_groups

admins

notification_interval

10

notification_period

24x7

}定義命令

definecommand{

command_name

check_nrpe

command_line

/usr/local/nagios/libexec/check_nrpe-H$HOSTADDRESS$-c$ARG1$

}重啟nagios服務！二、建立MySQL檢測用戶mysql>GRANTREPLICATIONCLIENTON*.*TOztz@localhostidentifiedby'123';

mysql>flushprivileges;編寫插件

被監(jiān)控主機上

vim/usr/local/nagios/libexec/check_slave

#!/bin/bash

MYSQLUSER=ztz

MYSQLPS=123

MYSQLBIN=/usr/bin/mysql

STATE_OK=0

STATE_WARNING=1

STATE_CRITICAL=2

STATE_UNKNOWN=3

STATE_NUM=$($MYSQLBIN-u$MYSQLUSER-p$MYSQLPS-e"showslavestatus\G"|grepRunning|

grepYes|wc-l)

if[$?-ne0];then

echo"PleaseCheckthePlugins"

exit$STATE_UNKNOWNfi

if["${STATE_NUM}"-eq2];thenecho"CheckOK,MySQLReplicationisrunning"

exit$STATE_OK

elseecho"CheckCritical,MySQLReplicationiserror"

exit$STATE_CRITICAL

fi被監(jiān)控主機測試

[root@Nagiost~]#cd/usr/local/nagios/libexec/

[root@Nagios-Clientlibexec]#chmod+xcheck_slave

[root@Nagios-Clientlibexec]#./check_slave

CheckOK,MySQLReplicationisrunning

修改被監(jiān)控主機的nrpe.confg

[root@Nagios-Client~]#vi/usr/local/nagios/etc/nrpe.cfg

添加：

command[check_slave]=/usr/local/nagios/libexec/check_slave修改監(jiān)控主機服務定義文件

[root@Nagios-Server~]#vi/usr/local/nagios/etc/objects/localhost.cfg

添加：defineservice{

host_name

Nagios-Client

service_description

check-slave

check_period

24x7

max_check_attempts

4

normal_check_interval

3

retry_check_interval

2

notification_interval

10

notification_period

24x7

notification_options

w,u,c,r

check_command

check_nrpe!check_slave

}

3>重新加載Nagios

[root@Nagios-Server~]#/etc/init.d/nagiosreload

Runningconfigurationcheck...done.

Reloadingnagiosconfiguration...done

4>登陸驗證

三、設置短信報警

1install

rpm-ivh/tmp/msmtp-1.4.6-1.el5.scopserv.i386.rpm2config

[187tmp]#cd

/etc/

[187tmp]#vimmsmtprc默認是沒有這個文件

accountdefault

host

port25

tlsoff

authlogin

use/p>

password123

logfile/tmp/msmtp.log

3mutt

vim/etc/Muttrc

2753setsendmail="/usr/bin/msmtp"

2754setfrom=163.com"

2755setrealname="iori"

測試：

4mutt+msmtp

echo"hello"|

mutt-s"修改一下mail的內個就行了

5

nagioscommand.cfg

definecommand{

command_name

notify-by-sms

command_line

/usr/bin/printf"%b""*****Nagios*****\n\nNotificationType:$NOTIFICATIONTYPE$\nHost:$HOSTNAME$\nState:$HOSTSTATE$\nAddress:$HOSTADDRESS$\nInfo:$HOSTOUTPUT$\n\nDate/Time:$LONGDATETIME$\n"|/usr/bin/mutt-s"**$NOTIFICATIONTYPE$HostAlert:$HOSTNAME$is$HOSTSTATE$**"$CONTACTEMAIL$

}

definecontact{

contact_name

ydl

alias

ydl

host_notification_period

24x7

host_notification_options

d