user=root
password='Gu-fmt1jOM'
for i in $socket
do
mysql=$(/app/mysql/bin/mysql -uroot -p"PJLuck08@!#DEMI6" -hlocalhost --default-character-set=utf8 -e "show slave status\G" | \
awk 'BEGIN {
tel = 0
}
/Slave_IO_Running: Yes/ { tel++ }
/Slave_SQL_Running: Yes/ { tel++ }
END {
if ( tel == 2 ) {
print "Yes"
} else {
print "No"
}
}'
)
date=`date`
if [ $mysql = Yes ]; then
echo $date" mysql" >> $slavelogfile
else
echo $date" mysql" >> $slavelogfile
fi
done
转载于:https://blog.51cto.com/1556359/1204801