Documentation Home
MySQL Internals Manual
Download this Manual
EPUB - 0.8Mb


14.9.5 COM_BINLOG_DUMP

Requests a binlog network stream from the master starting a given position.

You can use SHOW BINARY LOGS to get the current logfile and position from the master.

The master responds either with a

If the binlog-filename is empty, the server will send the binlog-stream of the first known binlog.

COM_BINLOG_DUMP:

request a binlog-stream from the server

Payload
1              [12] COM_BINLOG_DUMP
4              binlog-pos
2              flags
4              server-id
string[EOF]    binlog-filename
Fields
  • binlog_pos (4) -- position in the binlog-file to start the stream with

  • flags (2) -- can right now has one value:

    Flag

    Description

    0x01

    BINLOG_DUMP_NON_BLOCK

    BINLOG_DUMP_NON_BLOCK

    if there is no more event to send send a EOF_Packet instead of blocking the connection

  • server_id (4) -- server id of this slave

  • binlog-filename (string.EOF) -- filename of the binlog on the master


User Comments
Sign Up Login You must be logged in to post a comment.