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 3 supports 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, you can find comprehensive and free database knowledge on our community forum or blog posts. For professional support and services, contact our Percona Database Experts.

Community Forum Get a Percona Expert