mysql with a as_mysql 5.7 server_uuid 相同导致slave故障问题解决

问题

今天添加了一个mysql5.7的 slave数据库，部署完成之后，启动新部署的slave一切正常，但是收到了老slave数据库的主从同步报警。

登陆故障数据库查询到，Mysql主从同步报错如下

Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'A slave with the same server_uuid/server_id as this slave has connected to the master; the first event 'mysql-bin.003459' at 4, the last event read from '/data/dblogs/binlog_3306/mysql-bin.003466' at 445747689, the last byte read from '/data/dblogs/binlog_3306/mysql-bin.003466' at 445747689.'

问题原因

一开始感觉这种现象应该是server-id相同导致，经过多次确认集群中server-id确实不一样。

sys_manage@10.1.13.12: (none) 09:58:41>show variables like 'server_id';

+---------------+---------+

| Variable_name | Value |

+---------------+---------+

| server_id | 1217423 |

+---------------+---------+