{"id":5384,"date":"2020-07-30T00:10:04","date_gmt":"2020-07-29T16:10:04","guid":{"rendered":"http:\/\/39.97.231.10\/?p=5384"},"modified":"2020-07-30T00:10:04","modified_gmt":"2020-07-29T16:10:04","slug":"mysql-binlog-%e6%96%87%e4%bb%b6%e6%a0%bc%e5%bc%8f%e8%a7%a3%e6%9e%90gtid_log_event","status":"publish","type":"post","link":"http:\/\/www.weijing.co\/?p=5384","title":{"rendered":"MySQL Binlog \u6587\u4ef6\u683c\u5f0f\u89e3\u6790(GTID_LOG_EVENT)"},"content":{"rendered":"
\n
\nMySQL Binlog \u7531\u4e00\u4e2a\u4e2a\u7684event\u7ec4\u6210\uff0cevent\u6709\u4e0d\u540c\u7684\u79cd\u7c7b\uff0c\u5728MySQL 5.6\u7248\u672c\u52a0\u5165gtid\u529f\u80fd\u4e4b\u540e\uff0c\u6bcf\u4e2a\u4e8b\u52a1\u90fd\u4f1a\u6709\u552f\u4e00\u7684\u4e00\u4e2agtid\u5e8f\u53f7\u4e0e\u5176\u5bf9\u5e94\uff0c\u8fd9\u4e2agtid\u5e8f\u53f7\u5728Binlog\u4e2d\u4e5f\u6709\u4e00\u4e2a\u4e13\u95e8\u7684event\u7c7b\u578b\u4e0e\u4e4b\u5bf9\u5e94\uff0c\u4e5f\u5c31\u662fGTID_LOG_EVENT\uff0c\u672c\u6587\u5c06\u8be6\u7ec6\u63cf\u8ff0GTID_LOG_EVENT\u7684\u683c\u5f0f\u3002\n<\/div>\n<\/div>\n
\n
<\/div>\n
<\/div>\n
\u4e00\u3001\u4ec0\u4e48\u662fGTID_LOG_EVENT\uff1f<\/div>\n
<\/div>\n
\u63d2\u5165\u4e00\u6761\u8bb0\u5f55\uff0c\u770b\u4e0b\u8fd9\u4e2asql\u5728binlog\u91cc\u7531\u54ea\u51e0\u4e2a\u90e8\u5206\u7ec4\u6210\u3002<\/div>\n
insert into tb values(1);<\/div>\n
<\/div>\n
\u89e3\u6790binlog\uff0c\u6267\u884c\uff1ashow binlog events in \\’mysql-bin.000001\\’;<\/div>\n
<\/div>\n
\n
mysql> show binlog events in \\’mysql-bin.000001\\’;<\/div>\n
+—————-+———–+————-+——————————————————————-+<\/div>\n
| Event_type\u00a0\u00a0\u00a0\u00a0\u00a0| Server_id | End_log_pos | Info\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|<\/div>\n
+—————-+———–+————-+——————————————————————-+<\/div>\n
| Format_desc\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a010 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0123 | Server ver: 5.7.19-17-debug-log, Binlog ver: 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|<\/div>\n
| Previous_gtids |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a010 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0154 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|<\/div>\n
| Gtid\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a010 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0219 | SET @@SESSION.GTID_NEXT= \\’b0d850c2-dbd0-11e9-90c3-080027b8bded:1\\’ |<\/div>\n
| Query\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a010 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0290 | BEGIN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|<\/div>\n
| Table_map\u00a0 \u00a0 \u00a0 \u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a010 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0334 | table_id: 389 (db1.tb)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|<\/div>\n
| Write_rows\u00a0 \u00a0 \u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a010 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0374 | table_id: 389 flags: STMT_END_F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|<\/div>\n
| Xid\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a010 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0405 | COMMIT \/* xid=4632 *\/\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|<\/div>\n
+—————-+———–+————-+——————————————————————-+<\/div>\n
7 rows in set (0.00 sec)<\/div>\n<\/div>\n
<\/div>\n
\u53ef\u4ee5\u770b\u5230\u4e00\u6761\u63d2\u5165\u8bed\u53e5\uff0c\u5728binlog\u4e2d\u53d8\u6210\u4e86\u591a\u4e2aevent\u3002Format_desc\u548cPrevious_gtids\u5206\u522b\u662f\u683c\u5f0f\u63cf\u8ff0\u548c\u4e0a\u4e00\u4e2abinlog\u6587\u4ef6\u7ed3\u675f\u65f6\u7684gtid\u5e8f\u53f7\uff0c\u8fd9\u91cc\u4e0d\u8be6\u7ec6\u63cf\u8ff0\u3002\u4eceGtid\u8fd9\u4e2aevent\u5f00\u59cb\u770b\uff1a<\/div>\n
<\/div>\n
    \n
  1. \n
    Gtid\uff0cSET @@SESSION.GTID_NEXT= \\’b0d850c2-dbd0-11e9-90c3-080027b8bded:1\\’<\/div>\n<\/li>\n
  2. \n
    Query\uff0cBEGIN\uff0c\u4e8b\u52a1\u5f00\u59cb<\/div>\n<\/li>\n
  3. \n
    Table_map\uff0c\u8fd9\u79cd\u7c7b\u578b\u7684event\u63cf\u8ff0\u4e86\u8868\u7684\u5143\u4fe1\u606f\uff0c\u6bd4\u5982\u5b57\u6bb5\u6570\u91cf\uff0c\u5b57\u6bb5\u7c7b\u578b\uff0c\u5b57\u6bb5\u662f\u5426\u9ed8\u8ba4\u4e3a\u7a7a\uff0c\u5b57\u6bb5\u662f\u5426\u53d8\u957f\u7b49\u7b49<\/div>\n<\/li>\n
  4. \n
    Write_rows\uff0c\u8bb0\u5f55insert\u7684\u6570\u636e<\/div>\n<\/li>\n
  5. \n
    Xid\uff0cCOMMIT\uff0c\u4e8b\u52a1\u63d0\u4ea4<\/div>\n<\/li>\n<\/ol>\n
    <\/div>\n
    \u4e00\u6761\u7b80\u5355\u7684sql\u8bed\u53e5\uff0c\u5728binlog\u4e2d\u4ea7\u751f\u4e865\u4e2aevent\u3002\u5176\u4e2d\u7b2c\u4e00\u4e2aevent Gtid \u5c31\u662f\u4eca\u5929\u8981\u8be6\u7ec6\u4ecb\u7ecd\u7684event\u7c7b\u578b GTID_LOG_EVENT\u3002<\/div>\n
    <\/div>\n
    <\/div>\n
    \u4e8c\u3001GTID_LOG_EVENT\u7ed3\u6784\u89e3\u6790<\/div>\n
    <\/div>\n
    event header \u7ed3\u6784\u89e3\u6790\uff1a<\/div>\n