ERROR: Got error reading packet from server: A slave with the same server_uuid/server_id as this sla...

centos7.5 做binlog-server,拉取主库binlog报错

问题:

[root@db03-53 binlog]# mysqlbinlog  -R --host=10.0.0.55 --user=mha --password=mha --raw  --stop-never mysql-bin.000001 &
[5] 31058
[root@db03-53 binlog]# Warning: Using a password on the command line interface can be insecure.
ERROR: Got error reading packet from server: A slave with the same server_uuid/server_id as this slave has connected to the master; the first event 'mysql-bin.000001' at 4, the last event read from './mysql-bin.000001' at 151, the last byte read from './mysql-bin.000001' at 151.

原因:

gtid是由tid+uuid组成的,gtid是唯一的标识符 ,报错里说明了uuid重复

解决方法:

删掉auto.cnf 文件,重启就会自动生成
[root@db01-51 ~]# rm -rf /application/mysql/data/auto.cnf
[root@db01-51 ~]# /etc/init.d/mysqld restart

转载于:https://www.cnblogs.com/lvhanzhi/p/10646041.html