Revision 240

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	240	8.0.36	3.4.3+

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

Features

• New workload version MySQL 8.0.36

• Async replication between clouds [PR#375][DPE-2957]

• Ubuntu PRO support (ubuntu-advantage & landscape-client subordination) [PR#413]

• Add COS Tempo tracing support [#456][DPE-4367]

• Add new config options:

  • profile-limit-memory [PR#331][DPE-2654]

  • experimental-max-connections [#429][DPE-3706]

• log rotation for general/error/slowquery text logs [PR#329][DPE-1796]

• TLS CA chain support [PR#396]

• Labels for internal Juju secrets in [PR#348][DPE-2886]

• Internal disable operator mode [DPE-2184]

• Updated data-platform-libs for external secrets [PR#333]

• Snap aliases for MySQL server / Router [PR#417][DPE-3702]

• Allure Report [PR#391]

Bug fixes

• Fixed MAAS deployment [PR#444][DPE-3115]

• Fixed single unit upgrade [PR#340][DPE-2662]

• Fixed date format in logrotate config to avoid causing filename conflicts after 24hrs of uptime [PR#363][DPE-3063]

• Stops logging FLUSH LOG statements to the MySQL binlog which is causing GTID conflicts and prevents the member from self-healing [PR#336]

• Fixed rollback for unsupported MySQL datadir [DPE-3392]

• Updated TLS test lib and test charm [PR#392][DPE-3403]

• Fixed floor value for max_connections [PR#398]

• Fixed max_connections calculation [#429]DPE-3706

• Fixed KeyError when no ca-chain [PR#403][DPE-3688]

• Fixed broken state (after the restart) [PR#381][DPE-2618]

• Fixed error messaging when no bucket for backup [PR#350][DPE-2758]

• Avoid setting secret upon TLS relation broken if using juju secrets [PR#360][DPE-2677]

• Fixed logrotate file path [PR#374]

• Started using labels for internal secrets [PR#348][DPE-2886]

Canonical Data issues are now public on both Jira and GitHub platforms.
GitHub Releases provide a detailed list of bug fixes, PRs, and commits for each revision.

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

Inside the charms

• Charmed MySQL ships the latest MySQL 8.0.36-0ubuntu0.22.04.1

• mysql-shell CLI tool updated to 8.0.36+dfsg-0ubuntu0.22.04.1~ppa4

• Backup tools xtrabackup/xbcloud updated to 8.0.35-30

• The Prometheus mysqld-exporter is 0.14.0-0ubuntu0.22.04.1~ppa2

• VM charms based on Charmed MySQL snap (Ubuntu LTS 22.04.4) revision 103

• Principal charms supports Ubuntu LTS series 22.04 only

Technical notes

• Upgrade (juju refresh) is possible from revision 196+

• Use this operator together with a modern operator MySQL Router

• Please check restrictions from previous release notes

• Ensure system requirements are met.

Contact us

Charmed MySQL is an open source project that warmly welcomes community contributions, suggestions, fixes, and constructive feedback.

• Raise software issues or feature requests on GitHub

• Report security issues through Launchpad

• Contact the Canonical Data Platform team through our Matrix channel.