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:
- 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: Autogenerate db/user in legacy mysql (if not specified as config) [DPE-1511]
- Switch Charmed MySQL SNAP to Canonical binaries
- New documentation:
- All the functionality from the previous revisions
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.
- 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!
Hints:
Please check all the previous release notes if you are jumping over the several stable revisions!