COM_REGISTER_SLAVE

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.

• uint<1> Replica hostname length.

• string Hostname.

• uint<1> Replica username length.

• string Username.

• uint<1> Replica password length.

• string Replica password.

• uint<2> Replica connection port.

• uint<4> Replication rank.

• uint<4> Master server ID.

Note:

• Replica hostname, replica user, replica password, and replica port are usually not set. Some replica replication parameters 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.

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.......

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).

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

• slave port [2] = c9 5a => 23241.

• rank [4] = 0.

• master server id = 0.

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