In this exercise, we will use one master and one slave. The addresses are as follow:
master: 10.0.0.10
slave: 10.0.0.20
1. Make sure mysql-server is installed in both machines
2. In master, check the user_id
$ mysql -u root -p
mysql> show variables like 'server_id';
3. In master, create a user for replication
mysql> create user replicator@'%' identified with 'mysql_native_password' by 'mypassword';
3. In master, grant the user a privilege of slave replication
mysql> grant replication slave on *.* to replicator@'%';
4. In slave, change the server_id to a number different from the master
$ mysql -u root -p
mysql> set global variable server_id = 20;
5. Configure slave with the server's details
mysql> change master to master_host='10.0.0.10',master_user='replicator',master_password='mypassword';
6. Start slave
mysql> start replica;
7. Check slave status. Make sure slave_io and slave_sql are in running state.
mysql> show slave status\G
8. Test the setup. Create database, add table and some data into master, and check if the data gets replicated to slave.
No comments:
Post a Comment