nagios實現Mysql主從同步狀態的監控

nagios實現Mysql主從同步狀態的監控

一、系統內容

主機名稱	IP
nagios	192.168.15.111
mysql_s	192.168.15.21

二、操作步驟

2.1 mysql_s端的配置

2.1.1 編寫check_mysql_slave監控指令碼

cd /usr/local/nagios/libexec #切換到nagios監控外掛程式所在目錄

vim check_mysql_slave #開始編寫mysql_slave監控指令碼

<喎?http://www.bkjia.com/kf/ware/vc/" target="_blank" class="keylink">vc3Ryb25nPjwvcD4KPHA+PHN0cm9uZz7XotLio7q84L/YvcWxvtbQtcRteXNxbNXLu6fSu7ao0qrQwr2o0ru49qOssqLJ6NbD09DP3rXEyKjP3qGjPC9zdHJvbmc+PC9wPgo8cD48c3Ryb25nPiA8L3N0cm9uZz48L3A+CjxwPjxzdHJvbmc+Mi4xLjIguPi9xbG+1Pa807/J1rTQ0Mioz948L3N0cm9uZz48L3A+Cgo8cD5jaG1vZCA3NTUgY2hlY2tfbXlzcWxfc2xhdmU8L3A+CjxwPi1yd3hyLXhyLXggICAxIHJvb3Qgcm9vdCAgICAgICAgNDcxIE9jdCAxNiAxMjo1OSBjaGVja19teXNxbF9zbGF2ZTwvcD4KPHN0cm9uZz48L3N0cm9uZz4KPHA+IDwvcD4KPHA+PHN0cm9uZz4yLjEuM7HgvK1ucnBltcTF5NbDzsS8/jwvc3Ryb25nPjwvcD4KCjxwPnZpbSAgL3Vzci9sb2NhbC9uYWdpb3MvbGliZXhlYy9ldGMvbnJwZS5jZmcgJiM0MzsyMDQ8L3A+CjxzdHJvbmc+PC9zdHJvbmc+CjxwPjxzdHJvbmc+I8ztvNO84L/YbXlzcWwg1ve0082ssr3XtMystcTD/MHuPC9zdHJvbmc+PC9wPgoKPHA+IGNvbW1hbmRbY2hlY2tfbXlzcWxfc2xhdmVdPS91c3IvbG9jYWwvbmFnaW9zL2xpYmV4ZWMvY2hlY2tfbXlzcWxfc2xhdmU8L3A+CjxzdHJvbmc+PC9zdHJvbmc+CjxwPiAgIDwvcD4KPHA+PHN0cm9uZz4yLjEuNNbY0MLG9LavIG5ycGUgt/7O8Twvc3Ryb25nPjwvcD4KPHA+IDwvcD4KPHA+PHN0cm9uZz4yLjEuNda00NC9xbG+suLK1Mrks/Y8L3N0cm9uZz48L3A+CjxwPiA8L3A+Cgo8cD4gW3Jvb3RAbXlzcWxfcyAgbGliZXhlY10jICAuL2NoZWNrX215c3FsX3NsYXZlPC9wPgo8cD4gPC9wPgo8cD5PSyBteXNxbF9zICBpcyBydW5uaW5nPC9wPgo8c3Ryb25nPjwvc3Ryb25nPgo8cD4gICA8L3A+CjxwPjxzdHJvbmc+Mi4yICBuYWdpb3O2y7XExeTWw6O6PC9zdHJvbmc+PC9wPgo8cD4gPC9wPgo8cD48c3Ryb25nPjIuMi4xINDeuMTS0dPQtcQgL3Vzci9sb2NhbC9uYWdpb3MvZXRjL29iamVjdHMvc2VydmljZS5jZmcgxeTWw87EvP48L3N0cm9uZz48L3A+CjxwPiA8L3A+Cgo8cD5kZWZpbmUgc2VydmljZSB7PC9wPgo8cD51c2UgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBnZW5lcmljLXNlcnZpY2U8L3A+CjxwPmhvc3RfbmFtZSAgICAgICAgICAgICAgICAgICAgICAgICAgICBteXNxbF9zbGF2ZTwvcD4KPHA+c2VydmljZV9kZXNjcmlwdGlvbiAgICAgICAgICAgIGNoZWNrXzIxX215c3FsX3JlcGxpY2F0aW9uX3N0YXR1czwvcD4KPHA+Y2hlY2tfY29tbWFuZCAgICAgICAgICAgICAgICAgY2hlY2tfbnJwZSFjaGVja19teXNxbF9zbGF2ZTwvcD4KPHA+bWF4X2NoZWNrX2F0dGVtcHRzICAgICAgICAgIDM8L3A+CjxwPm5vcm1hbF9jaGVja19pbnRlcnZhbCAgICAgICAgMjwvcD4KPHA+cmV0cnlfY2hlY2tfaW50ZXJ2YWwgICAgICAgICAgICAgMjwvcD4KPHA+Y2hlY2tfcGVyaW9kICAgICAgICAgICAgICAgICAgICAgICAgMjR4NzwvcD4KPHA+bm90aWZpY2F0aW9uX2ludGVydmFsICAgICAgICAgICAgIDEwPC9wPgo8cD5ub3RpZmljYXRpb25fcGVyaW9kICAgICAgICAgICAgICAgIDI0eDc8L3A+CjxwPm5vdGlmaWNhdGlvbl9vcHRpb25zICAgICAgICAgICAgdyx1LGMscjwvcD4KPHA+Y29udGFjdF9ncm91cHMgICAgICAgICAgICAgICAgICAgYWRtaW5zPC9wPgo8cD5wcm9jZXNzX3BlcmZfZGF0YSAgICAgICAgICAgIDE8L3A+CjxwPn08L3A+CjxzdHJvbmc+PC9zdHJvbmc+CjxwPiA8L3A+CjxwPjxzdHJvbmc+Mi4yLjLW2Mb0IG5hZ2lvczwvc3Ryb25nPjwvcD4KPHA+IDwvcD4KCjxwPltyb290QG5hZ2lvcyBvYmplY3RzXSMvZXRjL2luaXQuZC9uYWdpb3MgIGNoZWNrY29uZmlnICAjvOyy6cXk1sPOxLz+yse38dPQzvM8L3A+CjxwPltyb290QG5hZ2lvcyBvYmplY3RzXSMvZXRjL2luaXQuZC9uYWdpb3MgIHJlbG9hZCAgICAgICAgICAgCiPW2NDCvNPU2MXk1sPOxLz+PC9wPgo8cD5SdW5uaW5nIGNvbmZpZ3VyYXRpb24gY2hlY2suLi5kb25lLjwvcD4KPHA+U3RvcHBpbmcgbmFnaW9zOiBkb25lLjwvcD4KPHA+U3RhcnRpbmcgbmFnaW9zOiBkb25lLjwvcD4KPHN0cm9uZz48L3N0cm9uZz4KPHA+IDwvcD4KCjxwPsu1w/ejusjnuftuYWdpb3MgcmVsb2Fkzeqxz6OsvOC/2NKzw+bJ0M60s/bP1rzssuK94bn7LL/J0tTK1ravsuLK1DwvcD4KCjxwPi91c3IvbG9jYWwvbmFnaW9zL2xpYmV4ZWMvY2hlY2tfbnJwZSAtSDE5Mi4xNjguMTUuMjEgLWMgY2hlY2tfbXlzcWxfc2xhdmU8L3A+CjxzdHJvbmc+PC9zdHJvbmc+CjxwPiA8L3A+CjxwPjxzdHJvbmc+Mi4yLjMg1+7W1dCnufvNvDwvc3Ryb25nPjwvcD4KPHA+PHN0cm9uZz48aW1nIHNyYz0="http://www.2cto.com/uploadfile/Collfiles/20141017/2014101709071727.jpg" alt="">