mysql AB复制监控脚步

secce

[Shell] 纯文本查看 复制代码

#!/bin/bash

ip=$1

/bin/ping $1 -c1 -w1 &> /dev/null

if [ $? -eq 0 ]; then

	/usr/bin/mysql -u mysqlshell -p123 -h $1 -e "show slave status \G" &> ./status.txt

	if [ $? -eq 0 ];then

#		IO=`/usr/bin/mysql -u mysqlshell -p123 -h $1 -e "show slave status \G"| /bin/awk -F ":" 'NR==12{print $2}'`

#		SQL=`/usr/bin/mysql -u mysqlshell -p123 -h $1 -e "show slave status \G"| /bin/awk -F ":" 'NR==13{print $2}'`

		IO=`cat ./status.txt | /bin/awk -F ":" 'NR==12{print $2}'`

		SQL=`cat ./status.txt | /bin/awk -F ":" 'NR==13{print $2}'`

		if  [ $IO =  Yes ] && [ $SQL = Yes ]; then

			echo "master and slave is synchronization!!!"

			exit 0

		else 

			echo "master and slave is Not synchronized!!!"

			exit 1

		fi

	else

		echo "Can't connect to MySQL server on '$1'!!!"

		exit 2

	fi			

else

	echo "slave host Unreachable!!!"

	exit 3

fi

0

吃饭与ml是第一生产力。

违法℃玩家

只要不下流，我们就是主流!

sunny03

我在马路边丢了一分钱

轻轻的

找不到恐龙，就用蜥蜴顶

龍子

流氓不可怕，就怕流氓有文化。

lchl0388

内练一口气，外练一口屁。