MySQL Primary-Replica Replication on Ubuntu 24.04

Primary: 192.168.1.10   Replica: 192.168.1.11

Primary – my.cnf

[mysqld]
server-id   = 1
log_bin     = /var/log/mysql/mysql-bin
binlog_format = ROW
binlog_expire_logs_seconds = 604800

CREATE USER 'replicator'@'192.168.1.11' IDENTIFIED WITH mysql_native_password BY 'ReplPass!';
GRANT REPLICATION SLAVE ON *.* TO 'replicator'@'192.168.1.11';
FLUSH PRIVILEGES;
SHOW MASTER STATUS;

Dump and transfer

mysqldump --all-databases --source-data=2 --single-transaction -u root -p > /tmp/full.sql
scp /tmp/full.sql [email protected]:/tmp/

Replica – my.cnf

[mysqld]
server-id = 2
read_only = 1

mysql -u root -p < /tmp/full.sql

CHANGE REPLICATION SOURCE TO
    SOURCE_HOST='192.168.1.10',
    SOURCE_USER='replicator',
    SOURCE_PASSWORD='ReplPass!',
    SOURCE_AUTO_POSITION=1;
START REPLICA;
SHOW REPLICA STATUS\G