mysql 8.0.19-0ubuntu4 has new permissions requirements

[David Ames]

Mysql router is unable to bootstrap due to missing permissions:

ERROR juju-log Failed to bootstrap mysqlrouter: Error: Error executing MySQL query "select cluster_type from mysql_innodb_cluster_metadata.v2_this_instance": View 'mysql_innodb_cluster_metadata.v2_this_instance' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)

mysql 8.0.19-0ubuntu4 is a recent update.

[David Ames (thedac)]

The view mysql_innodb_cluster_metadata.v2_this_instance references performance_schema.global_variables which the mysqlrouter user does not have permissions for.

 v2_this_instance | CREATE ALGORITHM=UNDEFINED DEFINER=`clusteruser`@`10.5.0.4` SQL SECURITY INVOKER VIEW `v2_this_instance` AS select `i`.`cluster_id` AS `cluster_id`,`i`.`instance_id` AS `instance_id`,`c`.`cluster_name` AS `cluster_name`,`c`.`cluster_type` AS `cluster_type` from (`v2_instances` `i` join `clusters` `c` on((`i`.`cluster_id` = `c`.`cluster_id`))) where (`i`.`mysql_server_uuid` = (select convert(`performance_schema`.`global_variables`.`VARIABLE_VALUE` using ascii) from `performance_schema`.`global_variables` where (`performance_schema`.`global_variables`.`VARIABLE_NAME` = 'server_uuid'))) | utf8mb4 | utf8mb4_0900_ai_ci |

Adding charmhelpers to the bug. Needs: "GRANT SELECT ON performance_schema.global_variables"

[David Ames (thedac)]

Grant is in charm helpers
https://github.com/juju/charm-helpers/pull/455

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/720305
Committed: https://git.openstack.org/cgit/openstack/charm-mysql-innodb-cluster/commit/?id=96ddade852a751f601f98f5d2ac1c600722fc1e2
Submitter: Zuul
Branch: master

commit 96ddade852a751f601f98f5d2ac1c600722fc1e2
Author: David Ames <email address hidden>
Date: Mon Apr 13 15:26:14 2020 -0700

    Pass wait timeout all the way through to clients

    Wait timeout is the non-interactive idle timeout setting. The default of
    3600 is aligned to OpenStack's idle_timeout configuration default.

    Along with changes to the mysql-shared and mysql-router interfaces, this
    change passes the wait timeout value all the way through to the client.

    Depends-On: I6ec40bc65f719e1938d9b0ccdb7ad00236f435d0
    Closes-Bug: #1841063
    Closes-Bug: #1873331
    Change-Id: Ie2b2ad2856cbe1d830f1b7e674a2fb867d81de12