MySQL Data Replication in Ubuntu 18.04..4 LTS
For this configuration, we have setup below mentioned nodes: Master Node IP : 192.168.1.101 Slave Node IP : 192.168.1.102 [ Step:01 ] Install MySQL on the Master server: #sudo apt-get update #sudo apt-get install mysql-server Install MySQL on the Slave server: #sudo apt-get update #sudo apt-get install mysql-server [ Step:02 ] ON MASTER NODE #vi sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf bind-address = 192.168.1.101 server-id = 1 log_bin = /var/log/mysql/mysql-bin.log #sudo systemctl restart mysql #sudo mysql CREATE USER 'replica'@'192.168.1.102' IDENTIFIED BY '123456'; GRANT REPLICATION SLAVE ON *.* TO 'replica'@'192.168.1.102'; SHOW MASTER STATUS\G mysql> SHOW MASTER STATUS\G *************************** 1. row *************************** ...