{"id":5388,"date":"2020-07-30T00:06:36","date_gmt":"2020-07-29T16:06:36","guid":{"rendered":"http:\/\/39.97.231.10\/?p=5388"},"modified":"2020-07-30T00:06:36","modified_gmt":"2020-07-29T16:06:36","slug":"mysql-binlog-%e6%96%87%e4%bb%b6%e6%a0%bc%e5%bc%8f%e8%a7%a3%e6%9e%90previous_gtids_log_event","status":"publish","type":"post","link":"http:\/\/www.weijing.co\/?p=5388","title":{"rendered":"MySQL Binlog \u6587\u4ef6\u683c\u5f0f\u89e3\u6790(PREVIOUS_GTIDS_LOG_EVENT)"},"content":{"rendered":"
\nMySQL Binlog\u6587\u4ef6\u5f00\u59344\u5b57\u8282\u56fa\u5b9a\u4e3amagic number\uff0c\u8ddf\u5728magic number\u4e4b\u540e\u7684\u7b2c\u4e00\u4e2aevent\u901a\u5e38\u662f\u683c\u5f0f\u63cf\u8ff0event\uff08FORMAT_DESCRIPTION_EVENT\uff09\uff0c\u5b83\u8bb0\u5f55\u4e86\u4e00\u4e9b\u91cd\u8981\u7684\u5143\u6570\u636e\uff0c\u6bd4\u5982event header\u7684\u957f\u5ea6\uff0c\u6bcf\u79cdevent\u7c7b\u578bdata\u90e8\u5206\u56fa\u5b9a\u957f\u5ea6\u7684\u5927\u5c0f\u7b49\u7b49\u3002Binlog event\u7c7b\u578b\u5927\u6982\u670940\u79cd\uff0c\u672c\u6587\u5c06\u4ecb\u7ecd\u53e6\u5916\u4e00\u79cd\u7c7b\u578b\u7684event\uff1aPREVIOUS_GTIDS_LOG_EVENT\uff0c\u5b83\u8bb0\u5f55\u4e86\u4e0a\u4e00\u4e2abinlog\u6587\u4ef6\u7ed3\u675f\u65f6\u6267\u884c\u5230\u7684gtid\u96c6\u5408\uff0c\u901a\u5e38\u8fd9\u4e2aevent\u8ddf\u5728\u683c\u5f0f\u63cf\u8ff0event\u4e4b\u540e\uff0c\u5982\u4e0b\u56fe\uff1a\n<\/div>\n
\n
\n
<\/div>\n
\n
mysql> show binlog events in \\’mysql-bin.000002\\’;<\/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\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\u00a0|<\/div>\n
|\u00a0Previous_gtids\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a010 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0194 | b0d850c2-dbd0-11e9-90c3-080027b8bded:1-53\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\u00a0\u00a0\u00a010 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0259 | SET @@SESSION.GTID_NEXT= \\’b0d850c2-dbd0-11e9-90c3-080027b8bded:54\\’ |<\/div>\n
| Query\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\u00a0346 | flush privileges\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<\/div>\n
<\/div>\n
\u4ece\u4ee5\u4e0a\u793a\u4f8b\u53ef\u4ee5\u770b\u51faPrevious_gtids\u7d27\u63a5\u5728Format_desc\u4e4b\u540e\uff0c\u8bb0\u5f55\u4e86\u4e0a\u4e00\u4e2abinlog\u6587\u4ef6\u7ed3\u675f\u65f6\u7684gtid\u96c6\u5408\u3002<\/div>\n
<\/div>\n
PREVIOUS_GTIDS_LOG_EVENT\u00a0\u683c\u5f0f\u89e3\u6790\uff1a<\/div>\n
<\/div>\n
event header \u7ed3\u6784\u89e3\u6790\uff1a<\/div>\n