Logical backups and restores

Logical backup is the copying of the actual database data. A pbm-agent connects to the database, retrieves the data, and writes it to the remote backup storage.

Logical restore is the reverse process: The pbm-agent retrieves the backup data from the storage and inserts it on every primary node in the cluster. The remaining nodes receive the data during the replication process.

The following diagram shows the restore flow.

Logical backups allow for point-in-time recovery.

Advantages	Disadvantages
- Easy to operate with, using a single command - Support for point-in-time recovery - The backup size is smaller as it includes only the data	- Much slower than physical backup / restore - Adds database overhead on reading and inserting the data

Make a backup Restore a backup

Contact Us

For free technical help, visit the Percona Community Forum.

To report bugs or submit feature requests, open a JIRA ticket.

For paid support and managed or consulting services , contact Percona Sales.

---

Last update: May 31, 2023
Created: May 31, 2023