Revision 240¶

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

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.