InnoDB Cluster Repair

"status": "(MISSING)" 

ERROR: group_replication has stopped with an error

Solution #1: Kick problem instance from cluster and add again

On Primary...

mysqlsh

var cluster = dba.getCluster()

cluster.status()

cluster.status({extended:3})

cluster.rescan()

Select Y to remove node from the cluster when prompted
            "node3:3306": {                "address": "node3:3306",                "instanceErrors": [                    "ERROR: group_replication has stopped with an error."                ],                "memberRole": "SECONDARY",                "memberState": "ERROR",                "mode": "R/O",                "readReplicas": {},                "role": "HA",                "status": "(MISSING)",                "version": "8.0.24"            }

On problem node...

mysqlsh

\sql

STOP GROUP_REPLICATION;

RESET REPLICA ALL;

SET GLOBAL super_read_only = OFF;

DROP DATABASE mysql_innodb_cluster_metadata;

On Primary...

mysqlsh

var cluster = dba.getCluster()

cluster.addInstance('icadmin@node3:3306',{ipAllowlist:"10.0.0.0/24,10.0.1.0/24,10.0.2.0/24"})

Select C to clone when prompted

cluster.status()

Solution #2: Kick problem instance from cluster and add again

A simpler variation on Solution #1

On any node...

mysqlsh

var cluster = dba.getCluster()

cluster.status()

cluster.status({extended:3})

cluster.removeInstance('icadmin@node3:3306')

cluster.addInstance('icadmin@node3:3306',{ipAllowlist:"10.0.0.0/24,10.0.1.0/24,10.0.2.0/24"})

cluster.rescan()

Bibliography