MYSQL:::MY-011505 Repl Plugin group_replication reported Member was expelled from the group due to network failures changing member status to ERROR MY-011712 MY-011735

#MY-011505 Repl Plugin group_replication reported Member was expelled from the

 group due to network failures changing member status to ERROR MY-011712 MY-011735 

--Verified MISSING node ERROR node resolution#

Solution:

 cluster.rejoinInstance("loginadmin@DBCLUSTERNODEIP_1:3306")

rejoin the missing instance back to innodb cluster.

=========================================================================

MySQL Shell 8.0.20-commercial

Copyright (c) 2016, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates.

Other names may be trademarks of their respective owners.

Type '\help' or '\?' for help; '\quit' to exit.

 MySQL  JS > \c loginadmin@DBCLUSTERNODEIP_2:3306

Creating a session to 'loginadmin@DBCLUSTERNODEIP_2:3306'

Fetching schema names for autocompletion... Press ^C to stop.

Your MySQL connection id is 26666197

Server version: 8.0.20-commercial MySQL Enterprise Server - Commercial

No default schema selected; type \use <schema> to set one.

 MySQL  DBCLUSTERNODEIP_2:3306 ssl  JS > var cluster=dba.getCluster()

 MySQL  DBCLUSTERNODEIP_2:3306 ssl  JS > cluster.status();

{

    "clusterName": "uatcluster",

    "defaultReplicaSet": {

        "name": "default",

        "primary": "DBCLUSTERNODEIP_2:3306",

        "ssl": "REQUIRED",

        "status": "OK_NO_TOLERANCE",

        "statusText": "Cluster is NOT tolerant to any failures. 1 member is not active",

        "topology": {

            "DBCLUSTERNODEIP_1:3306": {

                "address": "DBCLUSTERNODEIP_1:3306",

                "mode": "R/O",

                "readReplicas": {},

                "role": "HA",

                "status": "(MISSING)"

            },

            "DBCLUSTERNODEIP_2:3306": {

                "address": "DBCLUSTERNODEIP_2:3306",

                "mode": "R/W",

                "readReplicas": {},

                "replicationLag": null,

                "role": "HA",

                "status": "ONLINE",

                "version": "8.0.20"

            },

            "DBCLUSTERNODEIP_3:3306": {

                "address": "DBCLUSTERNODEIP_3:3306",

                "mode": "R/O",

                "readReplicas": {},

                "replicationLag": null,

                "role": "HA",

                "status": "ONLINE",

                "version": "8.0.20"

            }

        },

        "topologyMode": "Single-Primary"

    },

    "groupInformationSourceMember": "DBCLUSTERNODEIP_2:3306"

}

 MySQL  DBCLUSTERNODEIP_2:3306 ssl  JS > : cluster.rejoinInstance("loginadmin@DBCLUSTERNODEIP_1:3306")

SyntaxError: Unexpected token :

 MySQL  DBCLUSTERNODEIP_2:3306 ssl  JS > cluster.rejoinInstance("loginadmin@DBCLUSTERNODEIP_1: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

problem.

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

the instance cannot rejoin.

Rejoining instance to the cluster ...

The instance 'DBCLUSTERNODEIP_1:3306' was successfully rejoined on the cluster.

 MySQL  DBCLUSTERNODEIP_2:3306 ssl  JS >

=========================================================================