Backup process overview¶
Percona Xtrabackup is a tool that allows you to create backups of MySQL or MariaDB databases. It works by copying the data files and the binary log files of the server, while ensuring that the data is consistent and not corrupted by ongoing transactions. Percona Xtrabackup can also prepare the backup files for restoration, apply incremental backups, and stream the backup files to another server or storage device.
Backup types¶
You can take and prepare the following types of backups:
-
Full backup - a backup of all the contents of the database
-
Incremental backup - a backup of only the files that have changed since the last full backup
-
Compressed backup - a backup of all the contents of the database with applying a compression algorithm that reduces the size of the data to be stored
-
Partial backup - a backup of only the files that have changed in a specific folder or a set of folders, rather than the entire database
-
Individual partitions backup - a backup of an individual partition
Backup restoration¶
Need help?¶
Dive into our active community forum, where you can connect with fellow database enthusiasts, share experiences, and learn from experts.
For those seeking in-depth guidance and tailored solutions, our team of Percona Database Experts is ready to assist you.