There are a number of similar bugs to this one open for mysql-innodb-cluster:
- Deployment blocked with "Cluster is inaccessible from this instance" (https://bugs.launchpad.net/charm-mysql-innodb-cluster/+bug/1926449) - Stuck on "Cluster has no quorum as visible from <leader_ip> and cannot process write transactions. 2 members are not active" (https://bugs.launchpad.net/charm-mysql-innodb-cluster/+bug/1917332)
See more at: https://bugs.launchpad.net/charm-mysql-innodb-cluster
I think it boils down to: the payload mysql-innodb-cluster is either a) currently not configured in a way that recovers from cluster outages, b) isn't actually very good at coming back from cluster outages (i.e. a problem in the product).
Looking at https://dev.mysql.com/doc/mysql-shell/8.0/en/troubleshooting-innodb-cluster.html it seems it might be tricky to actually fully automate this.
There are a number of similar bugs to this one open for mysql-innodb- cluster:
- Deployment blocked with "Cluster is inaccessible from this instance" (https:/ /bugs.launchpad .net/charm- mysql-innodb- cluster/ +bug/1926449) /bugs.launchpad .net/charm- mysql-innodb- cluster/ +bug/1917332)
- Stuck on "Cluster has no quorum as visible from <leader_ip> and cannot process write transactions. 2 members are not active" (https:/
See more at: https:/ /bugs.launchpad .net/charm- mysql-innodb- cluster
I think it boils down to: the payload mysql-innodb- cluster is either a) currently not configured in a way that recovers from cluster outages, b) isn't actually very good at coming back from cluster outages (i.e. a problem in the product).
Looking at https:/ /dev.mysql. com/doc/ mysql-shell/ 8.0/en/ troubleshooting -innodb- cluster. html it seems it might be tricky to actually fully automate this.