杭州linux認(rèn)證運(yùn)維實(shí)戰(zhàn)培訓(xùn)
1、監(jiān)控MySQL主從同步
企業(yè)面試題1：監(jiān)控MySQL主從同步是否異常，如果異常，則發(fā)送短信或者郵件給管理員。提示：如果沒(méi)主從同步環(huán)境,可以用下面文本放到文件里讀取來(lái)模擬：
階段1：開(kāi)發(fā)一個(gè)守護(hù)進(jìn)程腳本每30秒實(shí)現(xiàn)檢測(cè)一次。
階段2：如果同步出現(xiàn)如下錯(cuò)誤號(hào)（1158,1159,1008,1007,1062），則跳過(guò)錯(cuò)誤。
階段3：請(qǐng)使用數(shù)組技術(shù)實(shí)現(xiàn)上述腳本（獲取主從判斷及錯(cuò)誤號(hào)部分）
如果沒(méi)有生產(chǎn)環(huán)境可以使用以下的模擬文本，**修改文本模擬故障。
[root@oldboy~]# mysql -uroot -p'oldboy' -S /data/3307/mysql.sock -e "show slavestatus\G;"
*************************** 1. row ***************************
Slave_IO_State:Waiting for master to send event
Master_Host:10.0.0.179 #當(dāng)前的mysql master服務(wù)器主機(jī)
Master_User: rep
Master_Port: 3306
Connect_Retry: 60
Master_Log_File:mysql-bin.000013
Read_Master_Log_Pos: 502547
Relay_Log_File:relay-bin.000013
Relay_Log_Pos:251
Relay_Master_Log_File:mysql-bin.000013
Slave_IO_Running:Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB: mysql
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 502547
Relay_Log_Space:502986
Until_Condition:None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0 #和主庫(kù)比同步延遲的秒數(shù)，這個(gè)參數(shù)很重要
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
腳本：
#!/bin/bash
# oldboy linux training
# 2015-05-17
# 說(shuō)明：本腳本來(lái)自老男孩linux21期學(xué)員張耀開(kāi)發(fā)！
# Source function library.
. /etc/init.d/functions
# Defined variables
MysqlUser=root
MysqlPass=oldboy123
MysqlPort=3307
Mysqlsock=/data/$MysqlPort/mysql.sock
ErrorNo=(1158 1159 1008 1007 1062)
errorlog=/tmp/error_skip.log
MysqlCmd="/application/mysql/bin/mysql -u$MysqlUser -p$MysqlPass -S $Mysqlsock"
# Judge mysql server is ok?
[ -S $Mysqlsock ] ||{
echo "Maybe MySQL have someting wrong"
exit 1
}
# Defined skip error Functions
function error_skip(){
local flag
flag=0
for num in ${ErrorNo[@]}
do
if [ "$1" == "$num" ];then
$MysqlCmd -e'stop slave;set global sql_slave_skip_counter=1;start slave;'
echo "$(date %F_%R) $1" >>$errorlog
else
echo "$(date %F_%R) $1" >>$errorlog
((flag ))
fi
done
[ "$flag" == "${#ErrorNo[@]}" ] &&{
action "MySQL Slave" /bin/false
uniq $errorlog|mail -s "MySQL Slave is error" 12345678@qq.com
}
}
# Defined check slave Functions
function check_slave(){
MyResult=`$MysqlCmd -e'show slave status\G'|egrep '_Running|Behind_Master|SQL_Errno' |awk '{print $NF}'`
array=($MyResult)
if [ "${array[0]}" == "Yes" -a "${array[1]}" == "Yes" -a "${array[2]}" == "0" ]
then
action "MySQL Slave" /bin/true
else
error_skip ${array[3]}
fi
}
# Defined main Functions
function main(){
while true
do
check_slave
sleep 60
done
}
main
咨詢電話【詹老師】：17706505315
了解更多的杭州Linux認(rèn)證課程>>>>杭州Linux認(rèn)證培訓(xùn)
了解更多的杭州培訓(xùn)課程>>>>杭州培訓(xùn)網(wǎng)
