Step 2 — Replication Configuration on Primary Server

sudo apt-get install nano
sudo nano /etc/mysql/my.cnf

 

[mysqld]
server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
binlog_format = ROW
innodb_flush_log_at_trx_commit = 1
sync_binlog = 1
sudo systemctl restart mysql
mysqldump -u root -p --all-databases --master-data > db_dump.sql
mysqldump -u root -p your_database your_table > /tmp/your_table.sql

Unlock tables

UNLOCK TABLES;
scp /tmp/your_table.sql user@slave_server:/tmp/

Revision #4
Created 19 September 2024 10:21:30
Updated 20 September 2024 08:47:16