mysql随笔
备份exchangedb库下的systemtable表
mysqldump --defaults-extra-file=/etc/my_pass.txt --flush-logs --single-transaction --set-gtid-purged=OFF exchangedb systemtable > /data/system_config.sql
查看binlog执行的具体操作
/usr/bin/mysqlbinlog --no-defaults -v -v --base64-output=decode-rows /data/log/mysql/bin/mysql-bin.000079 |grep -A 10 42953 |more
对比主从库的gtid是否一致
select @@global.gtid_executed;
校验主从表数据是否一致
checksum table system_config;