Charmed MySQL

  • By Canonical Data Platform
  • Cloud
Channel Revision Published Runs on
8.0/stable 196 29 Sep 2023
Ubuntu 22.04
8.0/candidate 203 14 Dec 2023
Ubuntu 22.04
8.0/beta 205 03 Jan 2024
Ubuntu 22.04
8.0/edge 210 28 Feb 2024
Ubuntu 22.04
juju deploy mysql --channel 8.0/stable
Show information

Platform:

Ubuntu
22.04

The Charmed MySQL Operator delivers automated operations management from day 0 to day 2 on the MySQL Community Edition relational database. It is an open source, end-to-end, production-ready data platform on top of Juju. As a first step this tutorial shows you how to get Charmed MySQL up and running, but the tutorial does not stop there. Through this tutorial you will learn a variety of operations, everything from adding replicas to advanced operations such as enabling Transport Layer Security (TLS). In this tutorial we will walk through how to:

  • Set up your environment using LXD and Juju.
  • Deploy MySQL using a single command.
  • Access the admin database directly.
  • Add high availability with MySQL InnoDB Cluster, Group Replication.
  • Request and change the admin password.
  • Automatically create MySQL users via Juju relations.
  • Reconfigure TLS certificate in one command.

While this tutorial intends to guide and teach you as you deploy Charmed MySQL, it will be most beneficial if you already have a familiarity with:

  • Basic terminal commands.
  • MySQL concepts such as replication and users.

Step-by-step guide

Here’s an overview of the steps required with links to our separate tutorials that deal with each individual step:


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