MySQL Forums
Forum List  »  InnoDB clusters

Innodb cluster. Primary node can't rejoin to cluster
Posted by: Al Es
Date: June 08, 2017 03:44AM

Good morning community,
i have just started to setup a development environment to test the innodb cluster solution, i have created 3 nodes and the creation of the cluster was ok till i stop the mysqld on the primary node in order to see if the failover works fine.
It does, and now the second nodes is elected as primary node:

mysql-js> cluster.status()
"clusterName": "testinnodbcluster",
"defaultReplicaSet": {
"name": "default",
"primary": "mgr2:3306",
"status": "OK_NO_TOLERANCE",
"statusText": "Cluster is NOT tolerant to any failures. 1 member is not active",
"topology": {
"mgr1:3306": {
"address": "mgr1:3306",
"mode": "R/O",
"readReplicas": {},
"role": "HA",
"status": "(MISSING)"
"mgr2:3306": {
"address": "mgr2:3306",
"mode": "R/W",
"readReplicas": {},
"role": "HA",
"status": "ONLINE"
"mgr3:3306": {
"address": "mgr3:3306",
"mode": "R/O",
"readReplicas": {},
"role": "HA",
"status": "ONLINE"

I started again the mysqld and then tried to rejoin the former primary to the cluster but i receive this error:
var cluster=dba.getCluster()
Dba.getCluster: This function is not available through a session to a standalone instance (RuntimeError)

If i try the rejoin from another node, the primary for example, this is the error:
mysql-js> cluster.rejoinInstance('root@mgr1:3306')
Rejoining the instance to the InnoDB cluster. Depending on the original
problem that made the instance unavailable, the rejoin operation might not be
successful and further manual steps will be needed to fix the underlying

Please monitor the output of the rejoin operation and take necessary action if
the instance cannot rejoin.

Please provide the password for 'root@mgr1:3306':
Rejoining instance to the cluster ...

Cluster.rejoinInstance: The instance 'mgr1:3306' does not belong to the ReplicaSet: 'default'. (RuntimeError)

how can i deal with this error?

Edited 2 time(s). Last edit at 06/08/2017 06:10AM by Al Es.

Options: ReplyQuote

Written By
Innodb cluster. Primary node can't rejoin to cluster
June 08, 2017 03:44AM

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.