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