Shulou(Shulou.com)06/01 Report--

Determine whether the slave database is synchronized with the master database in GTID replication

In show slave stautus\ G:

When Retrieved_Gtid_Set = Executed_Gtid_Set indicates that the slave library has completed synchronization with the master library

#! / bin/bashExec_num=$ (mysql-uroot-p147258-e "show slave status\ G;" 2 > / dev/null | grep 'Executed_Gtid_Set' | awk-F ":"' {print $3}'| awk-F "-'{print $2}'| awk-F", "'{print $1}') Ret_num=$ (mysql-uroot-p147258-e" show slave status\ G " "2 > / dev/null | grep 'Retrieved_Gtid_Set' | awk-F": "' {print $3}'| awk-F"-"'{print $2}') # determine whether the two values are the same, and output yes equally, otherwise noif [$Exec_num-eq $Ret_num] then echo" yes "else echo" no "fi

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.