TER='123'
MYSQL_HOST_MASTER=192.168.99.137
MYSQL_USER_SLAVE=root
MYSQL_PASS_SLAVE='123'
MYSQL_HOST_SLAVE=192.168.1.220
tmpfile_01="tmp01.`date +%Y%m%d%H%M%S`.txt"
tmpfile_02="tmp02.`date +%Y%m%d%H%M%S`.txt"
mysql -h${MYSQL_HOST_MASTER} -u${MYSQL_USER_MASTER} -p${MYSQL_PASS_MASTER} -e"SHOW BINARY LOGS;" >${tmpfile_01}
mysql -h${MYSQL_HOST_SLAVE} -u${MYSQL_USER_SLAVE} -p${MYSQL_PASS_SLAVE} -e"SHOW SLAVE STATUS\G;" >${tmpfile_02}
#tail -1 ${tmpfile_01} | grep -v "Log_name"
#cat ${tmpfile_02} | grep -E 'Master_Log_File|Read_Master_Log_Pos|Exec_Master_Log_Pos' | grep -v "Relay_Master_Log_File" |sed 's/^[ ]*//g'
a=`tail -1 ${tmpfile_01} | grep -v "Log_name" |awk '{print $1}'|awk -F "." '{print $2}'`
b=`sed -n "/\/p" ${tmpfile_02} |sed 's/^[ ]*//g' |awk -F ":" '{print $2}'|awk -F "." '{print $2}'`
bhtime=`sed -n "/\/p" ${tmpfile_02} |sed 's/^[ ]*//g' |awk -F ":" '{print $2}'`
if [ "$b" = "$a" ];then
c=`tail -1 ${tmpfile_01} | grep -v "Log_name" |awk '{print $2}'`
d=`sed -n "/\/p" ${tmpfile_02} |sed 's/^[ ]*//g' |awk -F ":" '{print $2}'`
k=`sed -n "/\/p" ${tmpfile_02} |sed 's/^[ ]*//g' |awk -F ":" '{print $2}'`
e=`expr $c - $d`
dfevt=`expr $d - $k`
if [ "${e}" -eq 0 -a "${bhtime}" -eq 0 -a "${k}" -eq 0 ] ; then
echo "*****************************************************************************"
echo -e "\e[1;31m &&&&&&&Synchronization has been completed!&&&&&&& \e[0m"
echo "*****************************************************************************"
elif [ "${e}" -eq 0 -o "${bhtime}" -gt 0 ] ; then
echo "*****************************************************************************"
echo -e "\e[1;31m Has been synchronized to the same log file! Wait a moment \e[0m"
echo -e "\e[1;31m Not synchronized binlog events is:${dfevt},behind master tims is ${bhtime} \e[0m"
echo "*****************************************************************************"
fi
elif [ ${b} -lt ${a} ];then
exbin=`sed -n "/\/p" ${tmpfile_02} |sed 's/^[ ]*//g' |awk -F ":" '{print $2}'`
y=`sed -n "/\/p" ${tmpfile_02} |sed 's/^[ ]*//g' |awk -F ":" '{print $2}'`
#u=`awk '{if($1~/'''''$y'''''/ ) print NR}' ${tmpfile_01}`
u=`grep -n "$y" ${tmpfile_01}|awk -F: '{print $1'}`
x=`awk 'NR>='''$u''' { print $0}' ${tmpfile_01}|awk 'BEGIN{total=0}{total+=$2}END{print total}' `
re=`expr $x - $exbin`
echo -e "\e[1;31m There are multiple log files are not synchronized,the events is:${re} \e[0m"
fi
rm -rf ${tmpfile_01}
rm -rf ${tmpfile_02}
|