Charmed MySQL K8s

  • By Canonical Data Platform
Channel Revision Published Runs on
8.0/stable 75 20 Apr 2023
Ubuntu 22.04
8.0/candidate 75 20 Apr 2023
Ubuntu 22.04
8.0/beta 75 20 Apr 2023
Ubuntu 22.04
8.0/edge 83 26 May 2023
Ubuntu 22.04
juju deploy mysql-k8s --channel 8.0/stable
Show information

Platform:

How to manage related applications

Modern mysql_client interface:

Relations to new applications are supported via the “mysql_client” interface. To create a relation:

juju relate mysql-k8s application

To remove a relation:

juju remove-relation mysql-k8s application

Legacy mysql interface:

This charm also supports the legacy relation via the mysql interface. Please note that these interface is deprecated.

juju relate mysql-k8s:mysql wordpress-k8s

Also extended permissions can be requested using mysql-root endpoint:

juju relate mysql-k8s:mysql-root wordpress-k8s

Rotate applications password

To rotate the passwords of users created for related applications, the relation should be removed and related again. That process will generate a new user and password for the application, while retaining the requested database and data.

juju remove-relation application mysql-k8s
juju add-relation application mysql-k8s

Internal operator user

The operator user is used internally by the Charmed MySQL Operator, the set-password action can be used to rotate its password.

  • To set a specific password for the operator user
juju run-action mysql-k8s/leader set-password password=<password> --wait
  • To randomly generate a password for the operator user
juju run-action mysql-k8s/leader set-password --wait

Help us improve this documentation

Most of this documentation can be collaboratively discussed and changed on the respective topic in the doc category of the Charmhub forum. See the documentation guidelines if you’d like to contribute.

Last updated a month ago. Help improve this document in the forum.