MySQL InnoDB Cluster Charm

  1. Bug #2064127
  2. Comment #10

Comment 10 for bug 2064127

Revision history for this message
macchese (max-liccardo) wrote (last edit ): Re: new added units try to join a new cluster

Hi Alex,
looking into one of myql-router unit-conf I see that MRUP_allowed_units and mysqlrouter_allowed_units are not the same on all themysql-innodb-cluster units and even some removed units still exist (vault-mysql-router/4 vault-mysql-router/5)

#juju show-unit vault-mysql-router/6 |egrep "mysql-innodb-cluster||MRUP_allowed_units|mysqlrouter_allowed_units"

mysql-innodb-cluster/13:
  MRUP_allowed_units: '"vault-mysql-router/4 vault-mysql-router/5 vault-mysql-router/6"'
  mysqlrouter_allowed_units: '"vault-mysql-router/4 vault-mysql-router/5 vault-mysql-router/6"'
mysql-innodb-cluster/14:
  MRUP_allowed_units: '"vault-mysql-router/6 vault-mysql-router/481"'
  mysqlrouter_allowed_units: '"vault-mysql-router/481 vault-mysql-router/482
mysql-innodb-cluster/15:
  MRUP_allowed_units: '"vault-mysql-router/4 vault-mysql-router/5 vault-mysql-router/6"'
  mysqlrouter_allowed_units: '"vault-mysql-router/4 vault-mysql-router/5 vault-mysql-router/6"'

what if I remove the actual well-clustered unit (vault/5) and add another one and then initialize the vault?