vi mysql_slave_check.sh
#!/bin/bash
Seconds_Behind_Master=`mysql -uroot -prootroot -e "show slave status\G" |egrep "Seconds_Behind_Master"`
Slave_IO_Running=`mysql -uroot -prootroot -e "show slave status\G" |egrep "Slave_IO_Running"`
Slave_SQL_Running=`mysql -uroot -prootroot -e "show slave status\G" |egrep "Slave_SQL_Running"`
Master_Log_File=`mysql -uroot -prootroot -e "show slave status\G"|egrep -w "Master_Log_File"`
Read_Master_Log_Pos=`mysql -uroot -prootroot -e "show slave status\G" |egrep -w "Read_Master_Log_Pos"`
Relay_Master_Log_File=`mysql -uroot -prootroot -e "show slave status\G" |egrep -w "Relay_Master_Log_File"`
Relay_Log_Pos=`mysql -uroot -prootroot -e "show slave status\G" |egrep -w "Relay_Log_Pos"`
#delay time check;
array=(${Seconds_Behind_Master//:/ })
if [ ${array[1]} -eq 0 ];then
echo "Slave is sync successfully And is nodelay "
else
echo "slave is behind master ${array[1]} Second "
fi
#SQL_THREAD check;
SQL_THREAD=(${Slave_IO_Running//:/ })
if [ ${SQL_THREAD[1]} == 'Yes' ];then
echo "Slave SQL_THREAD is syncing now "
else
echo "slave SQL_THREAD is Faild,please check it immediate "
fi
#IO_THREAD check;
IO_THREAD=(${Slave_IO_Running//:/ })
if [ ${IO_THREAD[1]} == 'Yes' ];then
echo "Slave IO_THREAD is syncing now "
else
echo "slave IO_THREAD is Faild,please check it immediate "
fi
#Master_File,Relay_File
echo $Master_Log_File
echo $Relay_Master_Log_File
echo $Read_Master_Log_Pos
echo $Relay_Log_Pos
#egrep 支持或。-w 精确匹配。不写-w就是模糊匹配。