How to create and list backups

This guide contains recommended steps and useful commands for creating and managing backups to ensure smooth restores.

Prerequisites

• A deployed MySQL cluster
• Access to S3 storage
• Configured settings for S3 storage

Create a backup

Once juju status shows Charmed MySQL as active and idle, you can create your first backup with the create-backup command:

juju run mysql/leader create-backup

If you have a cluster of one unit, you can run the create-backup action on mysql-k8s/leader (which will also be the primary unit).

Otherwise, you must run the create-backup action on a non-primary unit. To find the primary, see juju status or run juju run mysql-k8s/leader get-cluster-status to find the primary unit).

List backups

You can list your available, failed, and in progress backups by running the list-backups command:

juju run mysql/leader list-backups