Charmed MySQL

  • By Canonical Data Platform
  • Cloud
Channel Revision Published Runs on
8.0/stable 196 29 Sep 2023
Ubuntu 22.04
8.0/candidate 239 10 Jun 2024
Ubuntu 22.04
8.0/beta 239 10 Jun 2024
Ubuntu 22.04
8.0/edge 239 10 Jun 2024
Ubuntu 22.04
juju deploy mysql --channel 8.0/stable
Show information



Charmed MySQL revision 196

September 29, 2023

Dear community, this is to inform you that new Canonical Charmed MySQL is published in 8.0/stable charmhub channel for IAAS/VM.

The features you can start using today:

Bugfixes included:

Canonical Data issues are now public on both Jira and GitHub platforms.
GitHub Releases provide a detailed list of bugfixes/PRs/Git commits for each revision.
Highlights for the current revision:

  • #209 Use special user for backups + miscellaneous backups fixes
  • #216 Fix/join units refactor by
  • #223 Add auto-tuning for max_connections
  • #224 Optimize mysqlsh calls on library by
  • #254 Miscellaneous improvements to the mysql legacy relation
  • #296 Fixed MySQL memory allocation, consider ‘group_replication_message_cache_size’
  • DPE-1626 Add timeout kwarg to run_mysqlcli_script
  • DPE-2215 Fix wait timeout for shared-db
  • DPE-2089 Improve charm to add snap alias charmed-mysql.mysql → mysql
  • DPE-2352 Restart mysql exporter upon monitoring password change
  • DPE-1979 Fixed machine deployments where hosts are not resolvable
  • DPE-1519 Stabilized integration with mysql-route
  • DPE-2455 Fix bug that caused unnecessary truncation of the mysql hosts cache
  • DPE-2214 Avoid resetting workload if recovery from unreachable state unsuccessful
  • DPE-2478 Use actual observer pid in databag + reduce volume of secrets related logs
  • DPE-2217 Preemptively switch primary on scale-down
  • DPE-2401 Hold snap revision by default
  • DPE-2485 Resolve race condition when restarting after configure_instance
  • DPE-988 Fixed standby units (9+ cluster members are waiting to join the cluster)
  • DPE-2177 Stop configuring mysql user root@% (removed as no longer necessary)

What is inside the charms:

  • Charmed MySQL ships the latest MySQL “8.0.34-0ubuntu0.22.04.1”
  • CLI mysql-shell updated to “8.0.34-0ubuntu0.22.04.1~ppa1”
  • Backup tools xtrabackup/xbcloud updated to “8.0.34-29”
  • The Prometheus mysqld-exporter is “0.14.0-0ubuntu0.22.04.1~ppa1”
  • VM charms based on Charmed MySQL SNAP (Ubuntu LTS “22.04” - ubuntu:22.04-based)
  • Principal charms supports the latest LTS series “22.04” only.
  • Subordinate charms support LTS “22.04” and “20.04” only.

Technical notes:

  • Upgrade (juju refresh) from the old-stable revision 151 to the current-revision 196 is NOT supported!!! The upgrade functionality is new and supported for revision 196+ only!

Please check additionally the previously posted restrictions.

How to reach us:

If you would like to chat with us about your use-cases or ideas, you can reach us at Canonical Mattermost public channel or Discourse. Check all other contact details here.

Consider opening a GitHub issue if you want to open a bug report.
Contribute to the project!


Please check all the previous release notes if you are jumping over the several stable revisions!

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