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.

MySQL backups

For MySQL, use MySQL Backups under Apps > MySQL Backups. It supports XtraBackup, Mydumper, and Binlog, with local storage, S3, GCS, and rsync upload, and is the primary MySQL backup option going forward.

Legacy MySQL backup feature deprecated

The MySQL backup feature under Backups > All backups is deprecated and will be replaced by MySQL Backups when the SEP integration reaches GA. Both options are currently in Tech Preview. Backups created in one are not visible in the other.

MongoDB backups

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

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

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

• 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