二进制日志gtid模式

垃圾宝宝

已于 2024-09-21 19:46:24 修改

阅读量344

点赞数 2

文章标签： mysql

于 2024-09-21 19:42:44 首次发布

本文链接：https://blog.youkuaiyun.com/houduanq/article/details/142422539

版权

# --skip-gtids，使用mysqlbinlog截取时添加该参数，会执行已经执行的事务
mysqlbinlog --skip-gtids --include-gtids='a56fdfdc-7699-11ef-8f40-000c297f81d5:40' /data/binlog/mysql-bin.000003 > gtid.sql
# --skip-gtids，使用mysqlbinlog截取时不添加该参数，不会执行已经执行的事务
mysqlbinlog --include-gtids='a56fdfdc-7699-11ef-8f40-000c297f81d5:40' /data/binlog/mysql-bin.000003 > gtid.sql

mysql> select * from t1;
+------+------+
| id   | k1   |
+------+------+
|    1 | kv11 |
|    2 | kv22 |
|    1 | kv11 |
|    2 | kv22 |
|    1 | kv11 |
|    2 | kv22 |
+------+------+
6 rows in set (0.00 sec)

–skip-gtids，使用mysqlbinlog截取时不添加该参数，不会执行已经执行的事务

mysqlbinlog --include-gtids=‘a56fdfdc-7699-11ef-8f40-000c297f81d5:40’ /data/binlog/mysql-bin.000003 > gtid.sql

source 后

mysql> select * from t1;
+------+------+
| id   | k1   |
+------+------+
|    1 | kv11 |
|    2 | kv22 |
|    1 | kv11 |
|    2 | kv22 |
|    1 | kv11 |
|    2 | kv22 |
+------+------+
6 rows in set (0.00 sec)

–skip-gtids，使用mysqlbinlog截取时添加该参数，会执行已经执行的事务

mysqlbinlog --skip-gtids --include-gtids=‘a56fdfdc-7699-11ef-8f40-000c297f81d5:40’ /data/binlog/mysql-bin.000003 > gtid.sql

source 后

mysql> select * from t1;
+------+------+
| id   | k1   |
+------+------+
|    1 | kv11 |
|    2 | kv22 |
|    1 | kv11 |
|    2 | kv22 |
|    1 | kv11 |
|    2 | kv22 |
|    1 | kv11 |
|    2 | kv22 |
+------+------+
8 rows in set (0.00 sec)

mysql>