Skip to content

DBaaS backup and restore

Do not use for mission-critical workloads

DBaaS feature is deprecated. We encourage you to use Percona Everest instead. Check our Migration guide.

You can add a backup schedule while creating DB clusters in DBaaS. This feature is a fusion of backup management and DBaaS in PMM. Currently, DBaaS only supports scheduled backups, which can only be enabled when a database cluster is created.

To create a scheduled backup do the following:

Prerequisites

  1. Enable Backup management:

    From the main menu, navigate to {{icon.configuration}} Configuration SettingsAdvanced SettingsBackup Management to enable Backup management.

  2. Add a backup storage location:

    Note

    Currently, only S3 is supported.

    From the main menu, navigate to Backups → Storage Locations → Add storage location and enter all the required information to add a backup storage location. For details, see Prepare a storage location.

Create a backup schedule

To create a backup schedule do the following:

  1. From the main menu navigate to DBaaSDB Cluster.

  2. Click toggle in the Enable backups panel.

    !

  3. In the Backup Information panel, enter the backup details.

  4. Set the schedule for when scheduled backups should take place:

    From the drop-down select the Scheduled time when you want the backup to take place.

  5. Click Create.

Restore backup

You can create a DBaaS cluster from a backup stored on S3. You can use backups from an existing cluster to spin up a new database cluster from this backup.

To restore backup, do the following:

  1. From the main menu navigate to DBaaSDB Cluster.

  2. Click toggle in the Enable restore panel.

    !

  3. Enter the information on the Enable restore panel.

  4. Click Create.

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.