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 |