MySQL Forums
Forum List  »  InnoDB clusters

The server_id must be different from the ones in use by the members of the GR group.
Posted by: Ankita Moghe
Date: May 17, 2018 07:31AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
The server_id must be different from the ones in use by the members of the GR group.
76
May 17, 2018 07:31AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.