performance_schema.session_status doesn't exist on mysql add-unit
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Percona Cluster Charm |
New
|
Undecided
|
Unassigned |
Bug Description
Using cs:percona-
During a mysql add-unit of an already clustered mysql, I saw that the new unit came up and reached idle state, but all three units were like this:
mysql/0* waiting idle 0 10.1.208.152 3306/tcp Unit waiting for cluster bootstrap
mysql-hacluster/2 active idle 10.1.208.152 Unit is ready and clustered
mysql/1 waiting idle 1 10.1.208.106 3306/tcp Unit waiting for cluster bootstrap
mysql-
mysql/3 waiting idle 3 10.1.208.54 3306/tcp Unit waiting for cluster bootstrap
mysql-hacluster/5 active idle 10.1.208.54 Unit is ready and clustered
Machine State DNS Inst id Series AZ Message
0 started 10.1.208.152 juju-1c7884-0 xenial Running
1 started 10.1.208.106 juju-1c7884-1 xenial Running
3 started 10.1.208.54 juju-1c7884-3 bionic Running
Something interesting about this new unit is that it is a bionic unit rather than a xenial unit.
mysql/3 was missing the bootstrap-uuid on the cluster relation.
This was caused by the mysql db on its unit not having the performance_
I was able to workaround this missing table with
https:/
I'm not sure this is a valid work around or not
The goal of this procedure was to drop one xenial unit at a time and replace with bionic units because working cloud lacked a safe way to DRU contrainers. This prevented the stable path of pause non-leaders, upgrade leader, etc...
As you can see above, i have two xenial-queens mysql units and one bionic-queens mysql unit.