判断mysql主从

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

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

原文地址:https://www.cnblogs.com/fatzi/p/12918074.html