Skip to main content

Replica


Grant User

CREATE USER 'repl'@'%' IDENTIFIED BY '123';
GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'repl'@'%';

Set Replica

CHANGE MASTER TO
  MASTER_HOST='192.168.x.x',
  MASTER_PORT=3306,
  MASTER_USER='foo',
  MASTER_PASSWORD='foo',
  MASTER_AUTO_POSITION=1,

Logs

| binlog.000002 |      157 |              |                  | 1f24ef7e-4fe5-11ef-9059-00163e0a1d19:1-136030002,
297b5fb2-8406-11ef-9c96-00163e042361:1-501724031,
871eaf94-4fe4-11ef-822a-00163e0450f0:1-57156590,
b1728a28-4fde-11ef-abf5-00163e0cd423:1-168,
b4006ef2-0985-11f0-a011-00163e063a2e:1-85676831 |