搭建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