Last_IO_Errno: 13117 - master and slave have equal MySQL server UUIDs MYSQL 8 Layer 7 Gateway 10

Products

• CA API Gateway

Issue/Introduction

New cluster deployment setting up replication getting the following error, 

Last_IO_Errno: 13117
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.

On Gateway 10 running mysql8.

Environment

Release : 10.0

Component : API GATEWAY

Resolution

This can have 2 causes /etc/my.cnf having the same server-id on both nodes OR the auto.cnf value being the same on both nodes.

First run login to Privlieged shell,

# mysql

mysql> show global variables like '%server-id%';

mysql> show global variables like '%server-uuid%';

If the first query on server-id is duplicated validate the server-id in the /etc/my.cnf is unique and restart the mysql service on the node changed.

# service mysql restart

If the second query server-uuid is not unique on both nodes (i.e. the same value)

Follow the below instructions; 

Compare the output of,
more /var/lib/mysql/auto.cnf 
If the server ids are the same,
1) Make a backup copy on node2. 
cp /var/lib/mysql/auto.cnf /var/lib/mysql/auto.orig
2) Stop mysql
# service mysql stop
3) Move the file to /tmp
# mv /var/lib/mysql/auto.cnf /tmp/autocnf
4) Restart mysql
# service mysql start

And recreate/reinitialize replication if required.

https://knowledge.broadcom.com/external/article/44402/api-gateway-reinitialize-replication-in.html