默认主从都开启了bin log.
1.主从都在/etc/my.cnf中加入并重启服务
gtid_mode = ON
enforce_gtid_consistency = ON
2.在主库创建用户并授权
create user slave identified with mysql_native_password by '123456'
mysql>GRANT REPLICATION SLAVE ON *.* to 'slave'@'%' identified by '123456'; //如果用户已存在,会改密码,如果不存在会直接创建这个用户,所以不需要create user单独创建用户
mysql>FLUSH PRIVILEGES;
2.在从库10.153.35.5中执行
CHANGE MASTER TO
MASTER_HOST='10.153.35.2',
MASTER_USER='slave',
MASTER_PASSWORD='123456',
MASTER_AUTO_POSITION = 1;
3.在从库开启复制线程
mysql> SHOW SLAVE STATUS\G
Slave_IO_Running: No
Slave_SQL_Running: No
mysql> START SLAVE IO_THREAD;
Query OK, 0 rows affected (0.01 sec)
mysql> START SLAVE SQL_THREAD;
Query OK, 0 rows affected (0.01 sec)
3.在从库开启复制线程
mysql> SHOW SLAVE STATUS\G
Slave_IO_Running: Yes
Slave_SQL_Running: Yes