Failed to connect to MySQL but vault is unsealed and mysql is ready (openstack base)

I can fix the issue following instruction in the link below. Thanks all a lot!

I follow this help

I fix the problem go the lxd container you install mysql-router then open the conf file in /var/lib/mysql/vault-mysql-router/mysqlrouter.conf i change

  • [metadata_cache:bootstrap] to [metadata_cache:jujuCluster]
  • [routing:bootstrap_rw] to [routing:jujuCluster_rw]
  • [routing:bootstrap_ro] to [routing:jujuCluster_ro]
  • [routing:bootstrap_x_rw] to [routing:jujuCluster_x_rw]
  • [routing:bootsrap_x_ro] to [routing:jujuCluster_x_ro]
  • remove the last [metadata_cache:jujuCluster]

Because the default cluster name is jujuCluster not bootstrap then restart the service for every mysql-router then it works

1 Like