HEARTBEAT_LOG_EVENT
This event does not appear in the binary log. It's only sent over the network by a master to a replica server to let it know that the master is still alive, and is only sent when the master has no binlog events to send to replica servers.
Header
Timestamp is set to
0
.Next position is set to last position.
Type is set to
HEARTBEAT_EVENT
(0x1b
).
Fields
string The current master binary log name.
Example of Transmission (Without CRC32)
T 127.0.0.1:8808 -> 127.0.0.1:57157 [AP]
23 00 00 04 00 00 00 00 00 1b 67 2b 00 00 22 00 '.........g+..&.
00 00 ed 01 00 00 20 00 66 6f 6f 2d 62 69 6e 2e ...... .log-bin.
31 30 30 30 31 33 39 1000139
Network Replication protocol, 5 bytes
packet size [3] = 23 00 00 => 00 00 23 => 35 (ok byte + event size).
pkt sequence [1] = 04.
OK
indicator [1] = 0 (OK
).
Heartbeat Event
Header
Timestamp [4] = 00 00 00 00 => 0.
Event Type [1] = 1b => 27.
Server_id [4] = 67 2b 00 00 => 00 00 2b 67 => 111111.
Event Size [4] = 22 00 00 00 => 00 00 00 26 => 34 (header + data).
Next_pos [4] = ed 01 00 00 => 00 00 01 ed => 493.
Flags [2] == 20 00 => 00 20 = > 32.
Content, String
log-bin.1000139.
This page is licensed: CC BY-SA / Gnu FDL
Last updated
Was this helpful?