Charmed MySQL K8s

Channel Revision Published Runs on
8.0/stable 153 27 Jun 2024
Ubuntu 22.04
8.0/candidate 153 26 Jun 2024
Ubuntu 22.04
8.0/beta 160 15 Jul 2024
Ubuntu 22.04
8.0/beta 161 15 Jul 2024
Ubuntu 22.04
8.0/edge 163 18 Jul 2024
Ubuntu 22.04
8.0/edge 162 18 Jul 2024
Ubuntu 22.04
juju deploy mysql-k8s --channel 8.0/stable
Show information


Charm types “legacy” vs “modern”

Historically, there were several operators/charms to provide MySQL/MariaDB functionality: “MariaDB”, “OSM MariaDB”, “Percona Cluster” and “Mysql Innodb Cluster”. All of them are named “legacy” charms.

This “Charmed MySQL” operator is a modern “Charmed Operator SDK”-based charm to replace all legacy operators providing all juju-interfaces of legacy charms.

The legacy charm provided endpoints mysql and mysql-root (for the interface mysql). The modern charm provides old endpoints as well + new endpoint database (for the interface mysql_client). Read more detail about the available endpoints/interfaces for VM and K8s charms.

Note: Please choose one endpoint to use. No need to relate all of them simultaneously!

The default track “latest” vs “8.0”

The default track has been switched from the latest to 8.0 for both VM and K8s MySQL charms. It is to ensure all new deployments use a modern codebase. We strongly advise against using the latest track due to its implicit nature. In doing so, a future charm upgrade may result in a MySQL version incompatible with an integrated application. Track “8.0” guarantees MySQL 8.0 deployment only. The track latest is closed to avoid confusion.

How to migrate from “legacy” to “modern” charm

The “modern” charm provides temporary support for the legacy interfaces:

  • quick try: relate the current application with new charm using endpoint mysql (set the channel to 8.0/stable). No extra changes necessary:
    charm: mysql-k8s
    channel: 8.0/stable
    trust: true

Warning: NO in-place upgrades possible! Legacy charm cannot be upgraded to Operator-framework-based one. To move DB data, the second/modern DB application must be launched nearby and data should be copied from “legacy” application to the “modern” one. Canonical Data Platform team will prepare the copy&paste guide. Please contact us if you need migration instructions.

Note: the trust option must be enabled if Role Based Access Control (RBAC) is in use on your Kubernetes.

How to deploy old “legacy” mysql charm

Deploy the charm using the proper charm/channel:

    charm: charmed-osm-mariadb-k8s
    channel: latest/stable

    charm: mysql-innodb-cluster
    channel: 8.0/stable

Supported MySQL versions by modern charm

At the moment, both K8s and VM modern charms support MySQL 8.0 (based on Jammy/22.04 series) only. Please contact us if you need different versions/series.

Supported architectures: amd64, arm64, …

Currently, the charm supports architecture amd64 only. See the technical details in “Supported architectures”.

How to report issues and contact authors

The “modern charm” (from 8.0/stable) is stored on GitHub, here is the link to report modern charm issues.

Do you have questions? Contact us!

Help improve this document in the forum (guidelines). Last updated 10 months ago.