The Ultimate Guide to High Availability with MariaDB

BINLOG_CHECKPOINT_EVENT

Binlog Checkpoint Event, Event Type is 161 (0xa1)
This event specifies a binlog file such that XA crash recovery can start from that file.

Note: there can be more than one in a binlog file.

  • Event type is 161 (0xa1)

Fields

Example Without CRC32

12 ad 26 5a a1 84 27 00  00 27 00 00 00 47 01 00  ..&Z..'..'...G..
00 00 00 10 00 00 00 6d  79 73 71 6c 2d 62 69 6e  .......mysql-bin
2e 30 30 30 30 36 32                              .000062

Header, 19 Bytes

  • Event Timestamp = 12 ad 26 5a
  • Event Type = a1 => 161
  • Server_id = 84 27 00 00 => 00 00 27 84 = 10116
  • Event Size = 27 00 00 00 => 00 00 00 27 = 39
  • Next Pos = 47 01 00 00 => 00 00 01 47 = 327
  • Flags = 00 => 0

Content, Variable Size

  • filename length = 10 00 00 00 = >00 00 00 10 => 16
  • filename = mysql-bin.000062

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.