Shulou(Shulou.com)05/31 Report--

This article mainly introduces the MySQL from the library binlog how to use mysqlbinlog stop-datetime filtering, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

1. To construct such binlog# at 4Adw4AdwAAAHsAAAAABAAQANS43LjIyLTIyLWRlYnLAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA # at 123 years 190825 0:01:37 server id 953340 end_log_pos 234 CRC32 0x483a41ac Previous-GTIDs# 010fde77-2075-11e9-ba07-5254009862c0:16-40 at # cb7ea36e-670f-11e9-b483-5254008138e4:94-10 "at 234" 190724 14:07:36 server id 413340 end_log_pos 299 CRC32 0x9294741b GTID last_committed=0 sequence_number=1 rbricks onlylikes SET @ @ SESSION.GTID_NEXT= 'cb7ea36e-670f-11e9-b483-5254008138e4purl 105 canister trunks / at 299 / 190724 14:07:36 server id 413340 end_log_pos 362Timestempany 1563948456 / session. SET @ @ session.foreign_key_checks=1, @ @ session.sql_auto_is_null=0, @ @ session.unique_checks=1, @ @ session.session .sqlchocolate modeboxes 524288, @ session.sqlharmmodeparts 524288, @ @ session.auto_increment_increment=1, @ @ session.autoimmune increments offsetbacks, @ @ session. Session. Session utf8 * / / *! * /; SET @ @ session.session. SET @ @ session.lcroomtimekeeper namespace server id 413340 end_log_pos 414 CRC32 0x65673dab Table_map: `testmts`190724 14:07:36 server id 413340 end_log_pos 454 CRC32 0xa368ded1 Write_rows: table id 110flags: STMT_END_FBINLOG 'qPU3XR3XRYANAAAJ4BAAAAAAG4AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAE3Rlc3RtBnRc3R3cQABAwABqz1nZQQcards: qPUX3R6cAYAAAMAAAG4AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA # at 45419724 14:07:36 server id 413340 end_log_pos 485 CRC32 0x40df9d14 Xid = 44COMMIT Universe

This binlog is from the binlog,Event header timestamp of the library as follows:

FORMAT_DESCRIPTION_EVENT:190825 0:01:37

PREVIOUS_GTIDS_LOG_EVENT:190825 0:01:37

The above two Event are generated from the library binlog itself, which is, of course, the time of this example.

GTID_LOG_EVENT:190724 14:07:36

QUERY_EVENT:190724 14:07:36

MAP_EVENT:190724 14:07:36

WRITE_EVET:190724 14:07:36

XID_EVENT:190724 14:07:36

They are all the time when the main library statement command was initiated.

This transaction will not be resolved if we use stop-datetime='2019-07-25 00-00-00-00-00-12-00-00-00-12-00-00-12-00 at this time. The reason is that the time of FORMAT_DESCRIPTION_EVENT exceeds this time and exits directly.

The source code is as follows

Debug is as follows:

Thank you for reading this article carefully. I hope the article "how to filter binlog from the MySQL library using mysqlbinlog stop-datetime filtering" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support and follow the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.