# --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>
本站资源均来自互联网,仅供研究学习,禁止违法使用和商用,产生法律纠纷本站概不负责!如果侵犯了您的权益请与我们联系!
转载请注明出处: 免费源码网-免费的源码资源网站 » 二进制日志gtid模式
发表评论 取消回复