- By Canonical Data Platform
|8.0/stable||151||20 Apr 2023|
|8.0/candidate||151||20 Apr 2023|
|8.0/beta||151||20 Apr 2023|
|8.0/edge||161||26 May 2023|
juju deploy mysql --channel 8.0/stable
You will need Juju 2.9 to be able to run this command. Learn how to upgrade to Juju 2.9.
Deploy universal operators easily with Juju, the Universal Operator Lifecycle Manager.
How to restore foreign backup
This is a How-To for restoring a backup that was made from the a different cluster, (i.e. cluster migration via restore). To perform a basic restore please reference the Restore How-To
Restoring a backup from a previous cluster to a current cluster requires that you:
- Have a single unit Charmed MySQL deployed and running
- Access to S3 storage
- Have configured settings for S3 storage
- Have the backups from the previous cluster in your S3-storage
- Have the passwords from your previous cluster
When you restore a backup from an old cluster, it will restore the password from the previous cluster to your current cluster. Set the password of your current cluster to the previous cluster’s password:
juju run-action mysql/leader set-password username=root password=<previous cluster password> --wait juju run-action mysql/leader set-password username=clusteradmin password=<previous cluster password> --wait juju run-action mysql/leader set-password username=serverconfig password=<previous cluster password> --wait
To view the available backups to restore you can enter the command
juju run-action mysql/leader list-backups --wait
This shows a list of the available backups (it is up to you to identify which
backup-id corresponds to the previous-cluster):
backups: |- backup-id | backup-type | backup-status ---------------------------------------------------- YYYY-MM-DDTHH:MM:SSZ | physical | finished
To restore your current cluster to the state of the previous cluster, run the
restore command and pass the correct
backup-id to the command:
juju run-action mysql/leader restore backup-id=YYYY-MM-DDTHH:MM:SSZ --wait
Your restore will then be in progress, once it is complete your cluster will represent the state of the previous cluster.
Help us improve this documentation
Most of this documentation can be collaboratively discussed and changed on the respective topic in the doc category of the Charmhub forum. See the documentation guidelines if you’d like to contribute.