先配置master server-id(需要打开binlog)
创建用于主从的用户并赋予权限
CREATE USER 'rw'@'%' IDENTIFIED WITH mysql_native_password BY 'rw';
GRANT REPLICATION SLAVE ON *.* TO 'rw'@'%';
SHOW MASTER STATUS; 查看主库 binlog 和position 记录下等下要用
再配置从库 master server-id(不能和主库一样)
设置连接主库相关信(MASTER_LOG_FILE,MASTER_LOG_POS)
CHANGE MASTER TO
MASTER_HOST='192.168.1.101',
MASTER_USER='rw',
MASTER_PASSWORD='rw',
MASTER_LOG_FILE='mysql-bin.000003',
MASTER_LOG_POS=829;
##启动从库
start slave;
##查看是否启动
show slave status;
slave_io_running和slave_sql_running 都为yes 表示已经配置成功了。