判断mysql主从

#!/bin/bash
a=$(mysql -e "show slave status\G" | awk '/Slave_IO_Running/ {print $2}')
b=$(mysql -e "show slave status\G" | awk '/Slave_SQL_Running/ {print $2}')

if [ $a == 'Yes' -a $a == $b ]; then
echo "yes"
else
echo "no"
fi

posted @ 2020-05-19 17:05  fives  阅读(1034)  评论(0)    收藏  举报