Sponsor of the Day:
Jerkmate
https://docs.percona.com/percona-xtrabackup/8.4/prepare-individual-partitions-backup.html
Prepare an individual partitions backup - Percona XtraBackup
For preparing partial backups, the procedure is analogous to restoring individual tables. Apply the logs and use xtrabackup --export:
backup percona xtrabackupprepareindividualpartitions
https://docs.percona.com/percona-xtrabackup/8.4/create-individual-partition-backup.html
Create an individual partitions backup - Percona XtraBackup
Percona XtraBackup lets you back up individual partitions because partitions are regular tables with specially formatted names. The only requirement for this...
backup percona xtrabackupcreateindividualpartitions
https://docs.percona.com/percona-xtrabackup/8.4/quickstart-docker.html
Start a Docker container and take a backup - Percona XtraBackup
In this scenario, Percona XtraBackup works in combination with a MySQL-compatible database instance. To use the tool, you must run Percona XtraBackup in a...
backup percona xtrabackupdocker containerstarttake
https://docs.percona.com/percona-xtrabackup/8.4/quickstart-restore-back.html
Restore the backup - Percona XtraBackup
The following steps describe how to restore your backup to another Percona Server container and check whether the data is available.
backup percona xtrabackuprestore
https://docs.percona.com/percona-xtrabackup/8.4/lru-dump-backup.html
LRU dump backup - Percona XtraBackup
Percona XtraBackup includes a saved buffer pool dump into a backup to enable reducing the warm up time. It restores the buffer pool state from ib_buffer_pool...
backup percona xtrabackuplrudump
https://docs.percona.com/percona-xtrabackup/8.4/create-compressed-backup.html
Create a compressed backup - Percona XtraBackup
Percona XtraBackup supports compressed backups. To make a compressed backup, use the --compress option along with the --backup and --target-dir options. A...
backup percona xtrabackupcreatecompressed
https://docs.percona.com/percona-xtrabackup/8.4/server-backup-version-comparison.html
Server version and backup version comparison - Percona XtraBackup
A MySQL change to a feature, such as the structure of a redo log record, can cause older versions of Percona XtraBackup to fail. To ensure that you can back up...
server versionpercona xtrabackupcomparison
https://docs.percona.com/percona-xtrabackup/8.4/store-backup-history.html
Store backup history on the server - Percona XtraBackup
Percona XtraBackup supports storing the backups history on the server. Storing backup history on the server was implemented to provide users with additional...
percona xtrabackupstorehistoryserver
https://docs.percona.com/percona-xtrabackup/8.4/generated-files.html
XtraBackup backup files - Percona XtraBackup
This document provides a guide to the files and directory structure generated by the Xtrabackup tool. This information is essential for system administrators...
backup filesxtrabackuppercona
https://docs.percona.com/percona-xtrabackup/8.4/backup-strategy.html
Backup strategy and backup policy - Percona XtraBackup
In conversation, “backup strategy,” “backup policy,” and “backup plan” are used interchangeably, but the terms have distinct meanings.
backup strategypolicy perconaxtrabackup
https://docs.percona.com/percona-xtrabackup/8.4/reduction-in-locks.html
Reduced backup lock time - Percona XtraBackup
The --lock-ddl=REDUCED option reduces the time the server remains locked by xtrabackup during full and incremental backups. This allows you to perform Data...
percona xtrabackupreducedlocktime
https://docs.percona.com/percona-xtrabackup/8.4/page-tracking.html
Take an incremental backup using page tracking - Percona XtraBackup
To create an incremental backup with page tracking, Percona XtraBackup uses the MySQL mysqlbackup component. This component provides a list of pages modified...
incremental backuppercona xtrabackuptakeusingtracking
https://docs.percona.com/percona-xtrabackup/8.4/backup-overview.html
Backup process overview - Percona XtraBackup
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...
overview percona xtrabackupprocess
https://docs.percona.com/percona-xtrabackup/8.4/accelerate-backup-process.html
Accelerate backup process - Percona XtraBackup
percona xtrabackupaccelerateprocess
https://docs.percona.com/percona-xtrabackup/8.4/example-full-incr.html
Backup example - Percona XtraBackup
This example demonstrates how to set up daily full backups and hourly incremental backups using Percona XtraBackup 8.4 with a MySQL 8.4-compatible database...
percona xtrabackupexample