Revision 99

A new stable revision of Charmed MySQL for K8s has been published in the 8.0/stable channel on Charmhub.

See also: System requirements, How to upgrade

Architecture	Charm revision	MySQL version	Minimum Juju version
amd64	99	8.0.34	3.1.6+

If you are jumping over several stable revisions, make sure to check previous release notes before upgrading to this revision.

Features

• Add Juju 3 support (Juju 2 is still supported) [DPE-1790]

• Peer secrets are now stored in Juju secrets [DPE-1813]

• Charm minor upgrades and minor rollbacks [DPE-2206]

• Profiles configuration support [DPE-2154]

• Workload updated to MySQL 8.0.34 [DPE-2426]

• Support juju expose [DPE-1215]

• Add the first Prometheus alert rule (COS Loki) [PR#244]

• New documentation:

  • Architecture (HLD/LLD)

  • Upgrade section

  • Release Notes

  • Requirements

  • Users

  • Statuses

  • Development

  • Testing reference

  • Legacy charm

  • Contacts

Bug fixes

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

• DPE-1919 Fixed GKE deployment support

• DPE-1519 Stabilized integration with mysql-route-k8s

• DPE-2069 Fixed MySQL max_connections auto tune

• DPE-2225 Fixed MySQL memory allocation (use K8s Allocatable memory instead of free + consider group_replication_message_cache_size)

• DPE-988 Fixed standby units (9+ cluster members are waiting to join the cluster)

• DPE-2352 Start mysqld-exporter on COS relation only + restart upon monitoring password change

• DPE-1512 Auto-generate username/database when config values are empty (for legacy mysql relation)

• DPE-2178 Stop configuring mysql user root@% (removed as no longer necessary)

Full Changelog: https://github.com/canonical/mysql-k8s-operator/compare/rev75…rev99

What is inside the charms

• Charmed MySQL K8s 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”

• K8s charms based on our ROCK OCI (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 75 to the current-revision 99 is NOT supported!!! The upgrade functionality is new and supported for revision 99+ only!

• Please check additionally the previously posted restrictions.

• Ensure the charm requirements met.

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!