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.
Currently, PMM provides Backup and Restore functionality to work with:
- 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
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.
For information on restoring sharded backups, check the PBM documentation
To learn how to create and restore backups, check out subtopics below:
Here are some external resources for learning more about databases backups:
- Amazon Web Services S3
- Percona Backup for MongoDB
- 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.