搭建Mysql双主双从报错The slave I/O thread stops because master and slave have equal MySQL server UUIDs(已解决)
搭建Mysql双主双从报错The slave I/O thread stops because master and slave have equal MySQLserver UUIDs具体问题Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server
·
搭建Mysql双主双从报错The slave I/O thread stops because master and slave have equal MySQL server UUIDs
具体问题
- Last_IO_Error: 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.
问题原因
- 两台主机从为克隆出来,具有相同的uuid
- 查看如下:
mysql> show variables like 'datadir';
+---------------+-----------------+
| Variable_name | Value |
+---------------+-----------------+
| datadir | /var/lib/mysql/ |
+---------------+-----------------+
1 row in set (0.01 sec)
mysql> select uuid();
+--------------------------------------+
| uuid() |
+--------------------------------------+
| 5c90b47a-b9b3-11ec-9004-000c290af237 |
+--------------------------------------+
1 row in set (0.00 sec)
解决办法
cd /var/lib/mysql/
vi auto.cnf
//修改server-uuid
//重启MySQL服务
systemctl restart mysqld
更多推荐
已为社区贡献4条内容
所有评论(0)