How do I use Xtrabackup?
Back Up MySQL with Percona Xtrabackup
- Prerequisites. For this tutorial, you will need the following items:
- Install MariaDB.
- Install Percona XtraBackup.
- Configure MariaDB.
- Perform Full Backup with Innobackupex.
- Incremental Backups with Innobackupex.
- Restore Full Backup with Innobackupex.
How does percona Xtrabackup work?
XtraBackup works by remembering the log sequence number (LSN) when it starts, and then copying away the data files. During this step, XtraBackup performs crash recovery against the copied data files, using the copied transaction log file. After this is done, the database is ready to restore and use.
How do I install Xtrabackup?
Installing Percona XtraBackup from Percona apt repository
- Install the downloaded package with dpkg. To do that, run the following commands as root or with sudo:
- Remember to update the local cache: $ sudo apt-get update.
- After that you can install the package: $ sudo apt-get install percona-xtrabackup.
How does percona work?
Percona XtraBackup works by remembering the log sequence number (LSN) when it starts, and then copying away the data files. It takes some time to do this, so if the files are changing, then they reflect the state of the database at different points in time.
How does Percona xtrabackup work for crash recovery?
During the prepare phase, Percona XtraBackup performs crash recovery against the copied data files, using the copied transaction log file. After this is done, the database is ready to restore and use.
Is there a hot backup tool for MySQL?
Percona XtraBackup is an open-source hot backup utility for MySQL – based servers that doesn’t lock your database during the backup. It can easily be installed using official repositories on Debian/Ubuntu or RedHat/CentOS.
How to decrypt MySQL Backup in xbstream format?
When you compress and/or encrypt the backups in xbstream format you have to use the xbstream tool first to extract all the files, then using innobackupex to decrypt and/or uncompress the files.