Sunday, 22 June 2025

A replica with the same server_uuid/server_id as this replica has connected to the source

 Error: 

 Last_IO_Error: Got fatal error 1236 from source when reading data from binary log: 

 'A replica with the same server_uuid/server_id as this replica has connected to the source;

 the first event 'ON.000014' at 277, the last event read from './ON.000014' at 479, the last byte read from 

 './ON.000014' at 479.'


 Solution: 

      - Stop mysql service 

 [root@node02 ~]# systemctl stop mysqld

      - Go to mysql server database directory and take the backup 

 [root@node02 mysql]# pwd

       /var/lib/mysql

  [root@node02 mysql]# mv auto.cnf auto.cnf_bkp

  [root@node02 mysql]#

  - Start mysqld service 

 [root@node02 ~]# systemctl start  mysqld

No comments:

Post a Comment

The instance '****.**.**:3306' cannot be added to an InnoDB cluster because it has asynchronous (source-replica) replication channel(s) configured. MySQL InnoDB Cluster

  Error :    MySQL  JS > dba.checkInstanceConfiguration("root@192.*.*.*")  NOTE: Found unexpected replication channel '...