MySQL Master-slave replication

MySQL Host Master

1. Edit the MySQL configuration file my.cnf

server_id = 1 #server_id服务器唯一标识

Log_bin = Mysql-bin #借助mysql配置文件打开binlog

Restart MySQL

2. Create a user for master-slave replication

mysql> create user ' repl ' @ ' 172.17.0.% ' identified by ' abcd_123 ';

Authorized:

mysql> grant replication Slave on * * to ' repl ' @ ' 172.17.0.% ' identified by ' abcd_123 ';

mysql> flush Privileges;

To view host status:

Mysql> Show master status;

Mysql>show slave status/g;

MySQL slave machine slave

1. mysql> stop Slave; Stop master-slave replication

2. Synchronization

mysql> Change Master to master_host= ' 172.17.0.2 ', master_user= ' repl ', master_password= ' abcd_123 ', master_log_file= ' mysql-bin.000001 ', master_log_pos=575;

3. mysql> start slave;

Docker under command

Docker inspect MySQL master|grep IP

MySQL Master-slave replication