Revision 196

A new revision of Charmed MySQL 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	196	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-1812]

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

• Profiles configuration support [DPE-2154]

• Workload updated to MySQL 8.0.34 [DPE-2425]

• Support juju expose [DPE-1214]

• Switch to MySQL ClusterSet by default [DPE-1231]

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

• UX: Auto-generate db/user in legacy mysql (if not specified as config) [DPE-1511]

• Switch Charmed MySQL SNAP to Canonical binaries

• New documentation:

  • Architecture (HLD/LLD)

  • Upgrade section

  • Release Notes

  • Requirements

  • Users

  • Statuses

  • 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:

• #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)

Full Changelog: https://github.com/canonical/mysql-operator/compare/rev151…rev196

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 previous release notes.

• Ensure system requirements are 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!