COM_BINLOG_DUMP

You are viewing an old version of this article. View the current version here.

This is a command the slave sends to the master after COM_REGISTER_SLAVE.

The master server can send the binlog events.

Payload is

Note

  • Requested binlog position can be 4 when registering to master server for the very first time
    or when requesting events from a particular binlog file from the beginning of it.
  • The requested binlog file can empty when registering for the very first time if master log file is unknown
    or with GTID registration (not required).

When replication resumes or it is restarted (STOP SLAVE; START SLAVE) the slave server always
sends the latest binlog file name and position even if GTID registration is in place.

Example of COM_BINLOG_DUMP

  1b 00 00 00 12 34 06 00    00 02 00 75 27 00 00 6d    .....4.....u'..m
  79 73 71 6c 2d 62 69 6e    2e 30 30 30 30 33 34       ysql-bin.000034 

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.