How-to guides

Key processes and common tasks for deploying, configuring, and operating Charmed MySQL.

Deployment and setup

Available deployment methods, clouds, and specialised setups:

• Deploy MySQL
  • VM clouds
  • K8s clouds
  • Terraform
  • Airgapped
  • Multi-AZ
  • Juju spaces

Usage and maintenance

Most common operations when operating a MySQL cluster:

• Integrate with applications
• Scale your cluster
• Manage passwords
• Enable TLS
• External network access
• Primary switchover

Back up and restore

Configuration of storage providers and backup management:

• Back up and restore
  • Configure S3 AWS
  • Configure S3 RadosGW
  • Create a backup
  • Restore a backup
  • Migrate a cluster

Monitoring (COS)

Integrate with observability services like Grafana, Prometheus, and Tempo:

• Monitoring (COS)
  • Enable monitoring
  • Enable alert rules
  • Enable tracing

Refresh (upgrade)

Instructions for upgrading a single or multiple clusters:

• Refresh (upgrade)
  • Upgrade Juju
  • Single cluster
  • Multi-cluster

Cluster-cluster replication

Walkthrough of a highly available cluster-cluster deployment and its primary operations:

• Cluster-cluster replication
  • Deploy
  • Clients
  • Switchover/failover
  • Recovery
  • Removal

Charm development

For charm developers looking to support MySQL integrations with their charm.

• Charm development
  • Integrate with your charm
  • Migrate data via mysqldump
  • Migrate data via mydumper
  • Migrate data via backup/restore