How to Configure MySQL Master-Slave Replication on Ubuntu Linux

  Master Server Configuration Install MySQL Server: sudo apt-get install -y mysql-server Add the following to /etc/mysql/my.conf: bind-address = 10.11.12.101 server-id = 1 log_bin = /var/log/mysql/mysql-bin.log Restart MySQL: sudo service mysql restart Create a replication user: mysql -u root CREATE USER ‘repl’@’%’ IDENTIFIED BY ‘slavepassword’; GRANT REPLICATION SLAVE ON *.* TO ‘repl’@’%’; exit Create a … Read more