Back up and restore

Losing your data can destroy your business. This is why backing up data is critical for all database operations. Even more important than backing up data, is the ability to restore it in the event of data loss. PMM enables you to do all this with zero downtime and minimal performance impact.

• MongoDB (Generally Available)
• MySQL (in Technical Preview)

Enable the Backup Management option in PMM’s Advanced Settings to activate the Backup page from where you can:

• Create and restore MongoDB and MySQL backups
• Automate backup scheduling
• Set retention policies
• Monitor your backup and restore activity

Supported setups

For MySQL databases, you can create and restore on-demand and scheduled physical backups. For MongoDB, you can create and restore physical, logical and Point-in-Time-Recovery (PITR) backups, both on-demand and scheduled.

Sharded MongoDB cluster configurations

PMM 2.38 added support for creating backups of sharded MongoDB clusters. However, the restoring process is not handled end-to-end, and requires you to manually restore the artifacts using the CLI in Percona Backup for MongoDB.

Start here

To learn how to create and restore backups, check out subtopics below:

• Prepare a storage location
• MongoDB backups
• MySQL backups

Additional resources

Here are some external resources for learning more about databases backups:

• Amazon Web Services S3
• Percona Backup for MongoDB
• PERCONA_QPRESS
• PERCONA_XBCLOUD
• PERCONA_XBSTREAM
• PERCONA_XTRABACKUP
• oplog slices
• Percona Server for MongoDB
• MongoDB Replication

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.

Community Forum Get a Percona Expert