MySQL Shell / InnoDB Cluster Cannot Rejoin Instance To Running Cluster
Last updated on SEPTEMBER 26, 2017
Applies to:MySQL Server - Version 5.7 and later
Information in this document applies to any platform.
If one of the InnoDB cluster member has been restored with MEB, and if it's added back to the cluster using - cluster.rejoinInstance() , then the status for this added node will be shown as - (MISSING).
However, the Group Replication would be running fine after rejoining. Only the shell doesn't detect this newly added instance.
Checking through the shell log suggests that, there has been change in UUID of the instance after MEB restore and that's obvious. However, in 'instances' metadata table, the obsolete server UUID still persists.
The rejoined instances won't be recognized as it's old member, because of the changed UUID and it can't be added as new instance due to it's same hostname-port number.
In the meantime, Group replication was able to identify this change in UUID
and it accepted the old member. It's the Shell that denies to accept the
To explain how MySQL Shell ( as of 1.0.10 ) has an known defect which prevents a node from being rejoined back to the running Cluster after being removed.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms