Charmed MySQL K8s Reference - Revision 99

[taurus (Alex Lutay)]

Charmed MySQL K8s revision 99

_{September 18, 2023}

Dear community, this is to inform you that new Canonical Charmed MySQL K8s is published in 8.0/stable charmhub channel for Kubernetes.

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-1813]
• Charm minor upgrades and minor rollbacks [DPE-2206]
• Profiles configuration support [DPE-2154]
• Workload updated to MySQL 8.0.34 [DPE-2426]
• Support juju expose [DPE-1215]
• Add the first Prometheus alert rule (COS Loki) [PR#244]
• 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:

• DPE-1919 Fixed GKE deployment support
• DPE-1519 Stabilized integration with mysql-route-k8s
• DPE-2069 Fixed MySQL max_connections auto tune
• DPE-2225 Fixed MySQL memory allocation (use K8s Allocatable memory instead of free + consider group_replication_message_cache_size)
• DPE-988 Fixed standby units (9+ cluster members are waiting to join the cluster)
• DPE-2352 Start mysqld-exporter on COS relation only + restart upon monitoring password change
• DPE-1512 Auto-generate username/database when config values are empty (for legacy mysql relation)
• DPE-2178 Stop configuring mysql user root@% (removed as no longer necessary)

What is inside the charms:

• Charmed MySQL K8s 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”
• K8s charms based on our ROCK OCI (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 75 to the current-revision 99 is NOT supported!!! The upgrade functionality is new and supported for revision 99+ 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!