MySQL Backup

Prerequisites

• MySQL database asset
• MySQL credentials
• Storage bucket asset
• Storage bucket asset credentials

Procedure from web console

• Navigate to the policy's page: Operations > Policies (or go directly to /home/operations/policies)
• Click on Create Policy button
• Select MySQL backup
• Fill out the MySQL backup policy form with the following information:
  • Policy name: Enter a descriptive name for your backup policy
  • The MySQL asset to backup: Select the MySQL instance from the dropdown
  • The credential name to access MySQL: Select the credential bound to the MySQL asset from the dropdown
  • The database name to backup: Specify the name of the database you want to backup
  • The Bucket asset where backups will be saved: Choose the storage bucket from the dropdown
  • The opts for MySQL backup: Configure additional backup options (optional)
  • The version for MySQL client version: Specify the MySQL client version to use (optional)
  • The credential name to access Bucket: Select the credential bound to the Bucket from the dropdown
  • The path inside the bucket where backup is saved: Define the storage path within the bucket
  • The backup schedule in Cron format: Set the backup frequency using cron syntax (e.g., 0 2 * * * for daily at 2 AM)
  • Enable GZIP compression: Check this option to compress backups
  • Click Next to continue with the policy configuration
• Select the target cluster where you want to deploy the policy (optional - if not specified, the policy will be deployed to the default cluster)
• Review the policy configuration summary
• Click Create Policy to deploy the MySQL backup policy

Procedure from CLI

Create a YAML file with the policy configuration:

apiVersion: operations.resiliency.io/v1alpha1
kind: Policy
metadata:
 name: <policy-name>
 namespace: resiliency-system
spec:
 templateName: mysql-backup
 params:
 - name: mysql-asset
   value: <mysql-asset-id>
 - name: bucket-asset
   value: <bucket-asset-id>
 - name: mysql-opts
   value: "<backup-options>"
 - name: mysql-version
   value: "<client-version>"
 - name: bucket-path
   value: "<path-in-bucket>"
 - name: schedule
   value: "<cron-schedule>"
 - name: use-gzip
   value: <true|false>
 - name: bucket-credential
   value: <bucket-credential-name>
 - name: mysql-credential
   value: <mysql-credential-name>
 placement:
   clusterName: <target-cluster-id>
   createNamespace: true
   credentialName: <cluster-credential-name>
 suspended: false

Apply the policy to the cluster:

    kubectl apply -f mysql-backup-policy.yaml

Note: Replace the placeholder values (<policy-name>, <mysql-asset-id>, etc.) with your actual configuration values.