MySQL主從複製的維護指令碼

標籤：running

#!/bin/bash

#date is 2016-7-13

##### 主

mstool="/usr/local/mysql/bin/mysql -h mysql_m.bj.com -uroot -proot -P 3306"

##### 從

sltool="/usr/local/mysql/bin/mysql -h 192.168.153.92 -uroot -proot -P 3306"

declare -a slave_stat

slave_stat=($($sltool -e "show slave status\G" |grep Running |awk -F : ‘{print $2}‘

))

if [ "${slave_stat[0]}" = "Yes" -a "${slave_stat[1]}" = "Yes" ]

     then

     echo "OK slave is running"

     exit 0

else

     echo "Critical slave is error"

     echo

     echo "*********************************************************"

     echo "Now Starting replication with Master Mysql!"

        file=`$mstool -e "show master status\G"|grep -i "File"|awk ‘{print $2}‘` 

        pos=`$mstool -e "show master status\G"|grep -i "Pos"|awk ‘{print $2}‘` 

        $sltool -e "slave stop;change master to master_host=‘mysql_m.bj.com‘,master_port=3306,master_user=‘mysync‘,master_password=mysync‘,master_log_file=‘$file‘,master_log_pos=$pos;slave start;"

        sleep 3

        $sltool -e "show slave status\G;"|grep Running

    echo

    echo "Now Replication is Finished!"

    echo

    echo "**********************************************************"

        exit 2

fi

大家可以根據的自己的環境更改相關參數

MySQL主從複製的維護指令碼