校验binlog文件中的gtid是否连续

最新推荐文章于 2024-08-02 16:34:22 发布

Dark Frank

最新推荐文章于 2024-08-02 16:34:22 发布

阅读量284

点赞数 1

分类专栏： MySQL

本文链接：https://blog.youkuaiyun.com/weixin_43395638/article/details/109545856

版权

MySQL 专栏收录该内容

7 篇文章

订阅专栏

#!/bin/bash
binlog_file_name=$1
first_gtid=`mysqlbinlog -v ${binlog_file_name} | grep 'SESSION.GTID_NEXT' | head -1 | awk -F "'" '{print $2}' | awk -F ":" '{print $2}'`
last_gtid=`mysqlbinlog -v ${binlog_file_name} |grep 'SESSION.GTID_NEXT'| grep -v AUTOMATIC| sed -n '$p'| awk -F "'" '{print $2}'| awk -F ":" '{print $2}'`
echo 'firt gtid is ' ${first_gtid}
echo 'last gtid is ' ${last_gtid}
next_gtid=`expr ${first_gtid} + 1`
echo 
while [ $((next_gtid)) -lt $((last_gtid)) ]
do
  exist_flag=`mysqlbinlog -v ${binlog_file_name} | grep ${next_gtid}`
  if [ -z "$exist_flag" ] ;then  
    echo 'Not found gtid ' + ${next_gtid}
  fi
  next_gtid=`expr ${next_gtid} + 1`
done