All pages
Powered by GitBook
1 of 1

Loading...

COM_REGISTER_SLAVE

This command is used by a replica to register its details, such as server ID, hostname, and port, with the primary server.

This command is sent by the replica server to start MariaDB replication, and should be sent before requesting binlog events with COM_BINLOG_DUMP.

The payload is:

  • uint<1> command (COM_REGISTER_SLAVE = 0x15).

  • uint<4> Replica server ID.

  • Replica hostname length.

  • Hostname.

  • Replica username length.

  • Username.

  • Replica password length.

  • Replica password.

  • Replica connection port.

  • Replication rank.

  • Master server ID.

Note:

  • Replica hostname, replica user, replica password, and replica port are usually not set. Some replica can be used for such settings (report_host, report_port etc).

  • Replication rank is not set.

  • Master server ID is not set either.

Example of COM_REGISTER_SLA

The replica server is configured with:

  • server-id=10101;

  • report-host=slave_n_1;

  • report-port=23241.

We can see from the example:

  • server_id [4] = 75 27 00 00 => 10101.

  • hostname_len [1] = 09.

  • hostname[n] = slave_n_1 (9 bytes).

  • username len [1] = 0 (not set).

This page is licensed: CC BY-SA / Gnu FDL

password len [1] = 0 (not set).
  • slave port [2] = c9 5a => 23241.

  • rank [4] = 0.

  • master server id = 0.

  • uint<1>
    string
    uint<1>
    string
    uint<1>
    string
    uint<2>
    uint<4>
    uint<4>
    replication parameters
    1b 00 00 00 15 75 27 00    00 09 73 6c 61 76 65 5f    .....u'...slave_
     6e 5f 31 00 00 c9 5a 00    00 00 00 00 00 00 00       n_1...Z.......