InnoDB Cluster Repair

Databases

MySQL

MySQL High Availability

InnoDB Cluster

"status": "(MISSING)"

ERROR: group_replication has stopped with an error

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

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

Bibliography

InnoDB Cluster Diagnostics

"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

https://dba.stackexchange.com/questions/186268/how-to-resolve-innodb-cluster-conflicthttps://dba.stackexchange.com/questions/246099/relay-log-read-fail-relay-or-master-log-currupt-how-to-repairhttps://dba.stackexchange.com/questions/53893/mysql-relay-log-corrupted-how-do-i-fix-it-tried-but-failed
https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-innodb-cluster-working-with-cluster.htmlhttps://dev.mysql.com/doc/mysql-shell/8.0/en/troubleshooting-innodb-cluster.html
https://ahelpme.com/software/mysql/recovery-of-mysql-8-cluster-instance-after-server-crash-and-corrupted-data-in-log-event/
https://forums.oracle.com/ords/apexds/post/mysql-innodb-cluster-node-stucked-on-recovering-2196