Skip to content

Make a backup

In this tutorial, you will learn how to make a logical backup of your data manually. To learn more about backups, see the Backup and restore section.

Considerations and prerequisites

In this tutorial, we use the AWS S3 as the backup storage. You need the following S3-related information:

  • the name of the S3 storage
  • the name of the S3 bucket
  • the region - the location of the bucket
  • the S3 credentials to be used to access the storage.

If you don’t have access to AWS, you can use any S3-compatible storage like MinIO . Also check the list of supported storages.

Also, we will use some files from the Operator repository for setting up backups. So, clone the percona-server-mysql-operator repository:

$ git clone -b v0.7.0 https://github.com/percona/percona-server-mysql-operator
$ cd percona-server-mysql-operator

Note

It is important to specify the right branch with -b option while cloning the code on this step. Please be careful.

Configure backup storage

  1. Encode S3 credentials, substituting AWS_ACCESS_KEY_ID and AWS_SECRET_ACCESS_KEY with your real values:

    $ echo -n 'AWS_ACCESS_KEY_ID' | base64 --wrap=0
    $ echo -n 'AWS_SECRET_ACCESS_KEY' | base64 --wrap=0
    
    $ echo -n 'AWS_ACCESS_KEY_ID' | base64 
    $ echo -n 'AWS_SECRET_ACCESS_KEY' | base64 
    
  2. Edit the deploy/backup-s3.yaml example Secrets configuration file and specify the following:

    • the metadata.name key is the name which you use to refer your Kubernetes Secret
    • the base64-encoded S3 credentials
    deploy/backup-s3.yaml
    apiVersion: v1
    kind: Secret
    metadata:
      name: cluster1-s3-credentials
    type: Opaque
    data:
      AWS_ACCESS_KEY_ID: <YOUR_AWS_ACCESS_KEY_ID>
      AWS_SECRET_ACCESS_KEY: <YOUR_AWS_SECRET_ACCESS_KEY>
    
  3. Create the Secrets object from this yaml file. Specify your namespace instead of the <namespace> placeholder:

    $ kubectl apply -f deploy/backup-s3.yaml -n <namespace>
    
  4. Update your deploy/cr.yaml configuration. Specify the following parameters in the backup section:

    • set the storages.<NAME>.type to s3. Substitute the <NAME> part with some arbitrary name that you will later use to refer this storage when making backups and restores.
    • set the storages.<NAME>.s3.credentialsSecret to the name you used to refer your Kubernetes Secret (my-cluster-name-backup-s3 in the previous step).
    • specify the S3 bucket name for the storages.<NAME>.s3.bucket option
    • specify the region in the storages.<NAME>.s3.region option. Also you can use the storages.<NAME>.s3.prefix option to specify the path (a sub-folder) to the backups inside the S3 bucket. If prefix is not set, backups are stored in the root directory.
    ...
    backup:
      enabled: true
      ...
      storages:
        s3-us-west:
          type: s3
          s3:
            bucket: S3-BACKUP-BUCKET-NAME-HERE
            region: us-west-2
            credentialsSecret: cluster1-s3-credentials
          ...
    

    If you use a different S3-compatible storage instead of AWS S3, add the endpointURL key in the s3 subsection, which should point to the actual cloud used for backups. This value is specific to the cloud provider. For example, using Google Cloud involves the following endpointUrl:

    endpointUrl: https://storage.googleapis.com
    
  5. Apply the configuration. Specify your namespace instead of the <namespace> placeholder:

    $ kubectl apply -f deploy/cr.yaml -n <namespace>
    

Make a logical backup

Now when your have the configured storage in your Custom Resource, you can make your first backup.

  1. To make a backup, you need the configuration file. Edit the sample deploy/backup/backup.yaml configuration file and specify the following:

    • metadata.name - specify the backup name. You will use this name to restore from this backup
    • spec.clusterName - specify the name of your cluster. This is the name you specified when deploying Percona Server for MySQL cluster.
    • spec.storageName - specify the name of your already configured storage.
    deploy/backup/backup.yaml
    apiVersion: ps.percona.com/v1alpha1
    kind: PerconaServerMySQLBackup
    metadata:
      name: backup1
      finalizers:
        - delete-backup
    spec:
      clusterName: cluster1
      storageName: s3-us-west
    
  2. Apply the configuration. This instructs the Operator to start a backup. Specify your namespace instead of the <namespace> placeholder:

    $ kubectl apply -f deploy/backup/backup.yaml -n <namespace>
    
  3. Track the backup progress.

    $ kubectl get ps-backup -n <namespace>
    
    Output
    NAME      CLUSTER       STORAGE      DESTINATION                                      STATUS    COMPLETED   AGE
    backup1   cluster1      s3-us-west   s3://ps-operator-testing/2023-10-10T16:36:46Z   Running               43s
    

    When the status changes to Succeeded, backup is made.

Troubleshooting

You may face issues with the backup. To identify the issue, you can do the following:

  • View the information about the backup with the following command:
$ kubectl get ps-backup <backup-name> -n <namespace> -o yaml
$ kubectl logs pod/<pod-name> -c xtrabackup -n <namespace>

Congratulations! You have made the first backup manually. Want to learn more about backups? See the Backup and restore section for how to restore from a previously saved backup.

Next steps

Monitor the database

Get expert help

If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services. Join K8S Squad to benefit from early access to features and “ask me anything” sessions with the Experts.


Last update: 2024-06-24