1.service mysqld restart
2.创建用户,在主机上使用root@localhost登录,授权从机可以使用哪个用户登录
GRANT replication slave ON *.* TO 'slave'@'%' IDENTIFIED BY '123456';
3.查看master 状态:
show master status;
结果如下表格:
File
Position
Binlog_Do_DB
Binlog_Do_DB
Executed_Gtid_Set
mysql-bin.000001
154
执行命令:
4.3 配置Slave(192.168.1.153)
1.修改192.168.1.153 中MySQL的/etc/my.cnf配置文件。
server_id = 1503
log-bin=mysql-bin
binlog_format=mixed
relay_log=mysql-relay
2. 执行命令:
change master to master_user='slave', master_password='123456',master_host='192.168.1.152',master_log_file='mysql-bin.000001',master_log_pos=154;
3.启动slave
start slave;
4.查看命令状态:如下入
show slave status \G;
两个yes 就表示成功。
5. 双主模式
模式
ip
Master (Slave)
192.168.1.152
Slave(Master)
192.168.1.153
5.1 修改192.168.1.153 机器的配置文件:
1. 修改192.168.1.153 中MySQL的/etc/my.cnf配置文件。
#MySQL服务器唯一id
server_id = 15
#binlog日志类型
log-bin=mysql-bin
binlog_format=mixed
2.创建slave 用户:
GRANT replication slave ON *.* TO 'slave'@'%' IDENTIFIED BY '123456';
3.查看master 状态:
show master status;
File
Position
Binlog_Do_DB
Binlog_Do_DB
Executed_Gtid_Set
mysql-bin.000001
356
5.2 修改192.168.1.152 执行命令:
1.执行命令
change master to master_user='slave', master_password='123456',master_host='192.168.1.153',master_log_file='mysql-bin.000001',master_log_pos=356;
3.启动slave
start slave;
4.查看命令状态:如下入
1.有一个错误: 2020-12-08T17:24:00.656737Z 9 [ERROR] Slave I/O for channel ‘’: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work. Error_code: 1593 解决办法,修改其中一台服务器的server-uuid,并保证server-uuid的格式正确,修改完成之后重启Mysql服务就可以了。 在修改配置文件之前,先登录Mysql客户端查看uuid,把返回的uuid复制,放到要修改的配置文件即可。
1.有一个错误:2020-12-08T17:24:00.656737Z 9 [ERROR] Slave I/O for channel ‘’: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work. Error_code: 1593解决办法,修改其中一台服务器的