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

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

---

Last update: April 24, 2024
Created: April 24, 2024