Charmed MySQL

  • By Canonical Data Platform
  • Cloud
Channel Revision Published Runs on
8.0/stable 240 20 Jun 2024
Ubuntu 22.04
8.0/candidate 240 17 Jun 2024
Ubuntu 22.04
8.0/beta 240 17 Jun 2024
Ubuntu 22.04
8.0/edge 255 Today
Ubuntu 22.04
8.0/edge 254 Today
Ubuntu 22.04
juju deploy mysql --channel 8.0/edge
Show information




Warning: The feature is currently available in the channel 8.0/candidate only (revision 186+) and will be released to the channel 8.0/stable soon.

Charmed MySQL resource utilization depends on the chosen profile:

juju deploy mysql --config profile=testing

Profile values

Value Description Tech details
Maximum performance ~75% of unit memory granted for MySQL
max_connections=RAM/12MiB (max safe value)
testing Minimal resource usage innodb_buffer_pool_size = 20MB

Config change

Note: Pre-deployed application profile change is planned but currently is NOT supported.

To change the profile, use juju config (see all charm configs):

juju deploy mysql --config profile=testing && \
juju config mysql profile=production

Juju Constraints

Juju constraints allows RAM/CPU limits for Juju units:

juju deploy mysql --constraints cores=8 mem=16G

Juju constraints can be used together with charm profile:

juju deploy mysql --constraints cores=8 mem=16G --config profile=testing

Help improve this document in the forum (guidelines). Last updated 4 months ago.