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;