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:
  • Architecture (HLD/LLD)
  • Upgrade section
  • Release Notes
  • Requirements
  • Users
  • Statuses
  • Development
  • Testing reference
  • Legacy charm
  • Contacts
• 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!