The server_id must be different from the ones in use by the members of the GR group.

[Ankita Moghe]

Hi Team,

I am deploying InnoDB Cluster for production environment.

while creating did't get any issue, but while adding instance i am facing some issues.

mysql-js> cluster.checkInstanceState('root@10.10.14.50:3306')
Please provide the password for 'root@10.10.14.50:3306':
Analyzing the instance replication state...

The instance '10.10.14.50:3306' is valid for the cluster.
The instance is fully recoverable.

{
"reason": "recoverable",
"state": "ok"
}

The error getting is:
cluster.addInstance('root@10.10.14.51:3306')
A new instance will be added to the InnoDB cluster. Depending on the amount of
data on the cluster this might take from a few seconds to several hours.

Please provide the password for 'root@10.10.14.51:3306':
Adding instance to the cluster ...

Cluster.addInstance: WARNING: The given '10.10.14.51:3306' and the peer 'ubuntu:3306' have duplicated server_id 1
ERROR: Error joining instance to cluster: The operation could not continue due to the following requirements not being met:
The server_id 1 is already used by peer 'ubuntu:3306'
The server_id must be different from the ones in use by the members of the GR group. (RuntimeError)


I am missing any configuration steps? Please help me solving this issue.

Regards,
Ankita