Percona xtrabackup. xn--p1ai/y5stujqh/angel-numbers-list.

Jun 22, 2023 · Percona XtraBackup knows where your data is by reading your my. Defines the server credentials. The following example downloads the a tarball: The output FIFO data sink¶. / > backup. Percona XtraBackup will use Backup locks where available as a lightweight alternative to FLUSH TABLES WITH READ LOCK. $ xtrabackup --backup --stream=xbstream --target-dir=. mysqldump connects to mysql and run SELECT * to get access to the data, while xtrabackup physically accesses the files on disk. Stream the backup into an archived named backup. mysql --version mysql Ver 8. Percona Xtrabackup can also prepare the backup files for restoration, apply incremental In order to make a compressed backup you’ll need to use the xtrabackup –compress option: $ xtrabackup --backup --compress --target-dir = /data/compressed/. Percona Xtrabackup is a tool that allows you to create backups of MySQL or MariaDB databases. 34-29 added the redo-log-arch-dir option. cnf as follows: . Offered free as an open source solution, it drives down backup costs while providing unique features for MySQL backups. This component provides a list of pages modified since the last backup, and Percona XtraBackup copies only those pages. Percona XtraBackup is the world’s only open source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. Build PS servers in debug mode. Install Percona XtraBackup 2. 6 and 5. In order to clean up the backup directory you should use --remove-original option. The xtrabackup binary reads the [mysqld] and [xtrabackup] sections from any configuration files, in that order. GLACIER. 0 from the official Percona software repositories using the appropriate package manager for your system: Use an APT repo to install Percona XtraBackup. If your backup is from a server with binary logging enabled, xtrabackup will create a file named xtrabackup_binlog_info in the target directory. 4 versions of XtraBackup; Generate autoxtrabackup . STANDARD_IA. There is only one caveat about partial backups: do not copy back Percona XtraBackup needs to be able to connect to the database server and perform operations on the server and the datadir when creating a backup, when preparing in some scenarios and when restoring it. Percona XtraBackup is the world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. With Percona XtraBackup, you can achieve the following benefits: Percona XtraBackup makes MySQL hot backups for all versions of Percona Server for MySQL, and MySQL. Percona XtraBackup copies the InnoDB data files, which results in data that is internally inconsistent; then the prepare phase performs crash recovery on the files to make a consistent, usable database again. The default storage class depends on the provider. Have anyone from your internal team has tried this before and verified that it works? Yes, this has been tested and works: Jul 19, 2022 · Percona XtraBackup will refuse to take backups from MySQL 8. You need a full datadir as a base, and then you can apply a series of operations from the binary Jul 11, 2024 · ZRM with \Percona XtraBackup provides resource utilization management by providing throttling based on the number of IO operations per second. Jul 11, 2024 · Configure xtrabackup. Percona Xtrabackup can also prepare the backup files for restoration, apply incremental Feb 12, 2021 · Please send us the full output of your xtrabackup prepare command, the output of xtrabackup when you originaly created this backup and the output of ls to list the files from target-dir. supports all features and syntax as 2. 5 days ago · You can control whether Percona XtraBackup encrypts data during State Snapshot Transfer (SST) using the encrypt option in your configuration. cnf . Percona XtraBackup supports storing the backups history on the server. Do not copy back the prepared backup. Stream the backup into a compressed archive named backup. This following script defines the server details like hostname, username, password, data directory, and backup directory. To start, go to the Percona release page for Ubuntu to find the latest . Jul 10, 2023 · Implemented in Percona XtraBackup 8. Get an open source backup solution for all versions of Percona Server for MySQL and MySQL that performs online non-blocking and highly secure full backups on transactional systems so that applications remain fully available during Percona XtraBackup needs to be able to connect to the database server and perform operations on the server and the datadir when creating a backup, when preparing in some scenarios and when restoring it. , innobackupex will not be able to backup Jun 21, 2024 · Percona XtraBackup is an open-source command-line utility. --keyring-file-data option (and also xtrabackup --server-id option, needed for MySQL prior to 5. NOTE If you use the GLACIER storage class, the object must be restored to S3 before restoring the backup. 1 Like ajstark123 February 22, 2021, 9:28pm About Percona XtraBackup. This operation removes the need to scan the pages in the database. This applies the delta files to the files in /data/backups/base, which rolls Jun 21, 2024 · The version numbers for Percona XtraBackup 8. We recommend that you install Percona XtraBackup 8. Note that the binary log contains the operations that modified the database from a point in the past. It copies your InnoDB data files, which results in data that is internally inconsistent; but then it performs crash recovery on the files to make them a consistent, usable database again. If the majority of pages have not been modified Learn how to use Percona XtraBackup, an open source hot backup utility for MySQL-based servers, to take backups of InnoDB, XtraDB, MyISAM, and MyRocks tables. 34, and MySQL 8. The xtrabackup tool can print out the contents of a my. e. The supported values are: AES128, AES192, and AES256. This operation may lead to database inconsistencies. 3 and 2. It is not recommended to run Feb 4, 2024 · This feature was implemented in Percona XtraBackup 2. Increasing the size of the redo logs, so they are not wrapped while mysql is working. As of Percona XtraBackup 8. Jul 11, 2024 · For an authenticated user or an application to access an encrypted F tablespace, InnoDB uses the master encryption key to decrypt the tablespace key. Uses xtrabackup with the --backup flag for a full backup. This feature was implemented in Percona XtraBackup 2. You also must specify the --target-dir option, which is where the backup is stored. The option does not affect long-running queries. All the xtrabackup configuration is done through options, which behave exactly like standard MySQL program options: they can be specified either at the command-line, or through a file such as /etc/my. XTRABACKUP_HISTORY table. cnf. The master encryption key is stored in a keyring. 2 version did, but is now. Task. Percona XtraBackup is able to take backups seamlessly from Percona Server for MySQL, as the corruption issues have been fixed in the upcoming Jun 12, 2024 · It will notify you that the database was not shut down normally. We do not by using the –copy-back option. deprecated and will be removed in next major release. Find installation guides, backup management, supported versions, and limitations. providing a list of databases. deb packages for installing the repository Jul 11, 2024 · To ensure consistent backups, use the FLUSH TABLES WITH READ LOCK option before taking a non-InnoDB file backup. The variable is only used in place of the --encrypt_key=name option. The feature is in tech preview. If Percona XtraBackup does not have the appropriate permissions, the If your backup is from a server with binary logging enabled, xtrabackup creates a file named xtrabackup_binlog_info in the target directory. See the xtrabackup documentation for more details. To use this feature, simply add the option to a local backup, for example: $ xtrabackup --backup --parallel =4 --target-dir = /path/to/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 Percona XtraBackup. It also uses the –use-memory option. 21. 7. Create the full backup with a following command: Percona XtraBackup Manual. Jul 10, 2023 · Create a partial backup. An increase in base version resets the minor build version to 0. This feature is available in Percona Server for MySQL 5. 25 Linux (x86_64) (revision id: d27028b) Percona XtraBackup (PXB) is a 100% open source backup solution for all versions of Percona Server for MySQL and MySQL® that performs online non-blocking, tightly compressed, highly secure full backups on transactional systems. This means that you must run xtrabackup as a user who has permission to write the data files. This file contains the binary log file name and position of the exact point in the binary log to which the prepared Percona XtraBackup copies all the MyRocks files each time it takes a backup. mylogin. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Percona XtraBackup is a free, open source, complete online backup solution for all versions of Percona Server for MySQL, MySQL® and MariaDB®. 13). Running OPTIMIZE TABLE on affected tables will bring them back to a safe state. Percona XtraBackup is a free, online, open source, complete database backups solution for all versions of Percona Server for MySQL and MySQL®. Here is a way to get a long-running query with the employees database: 1. You can start a replica server with this backup and issue the statement saved in the xtrabackup_slave_info file. Apr 10, 2020 · It is easy to backup and restore a table or a database using Percona XtraBackup, by using just a few commands. The improvement will depend on the number of tablespace files (IBDs) in the backup directory. Percona XtraBackup - an open source backup solution for all versions of Percona Server for MySQL and MySQL that performs online non-blocking, tightly compressed, highly secure full backups on transactional systems so that applications remain fully available during planned maintenance windows. Download the binary tarballs from the Linux - Generic section on Percona Product Downloads. You can perform the analysis on a running server, with some chance of errors due Jan 8, 2024 · Percona XtraBackup 8. If you have your configuration file in a non-standard place, you should use the flag --defaults-file =/location/of/my. Oct 11, 2013 · Aborting the backup if long queries are running. Percona XtraBackup works by remembering the log sequence number (LSN) when it starts, and then copying away the data files. If the InnoDB data or log files are not stored in the same directory, you must specify their location. At the same time, Percona XtraBackup runs a background process that watches the Nov 27, 2017 · Clone percona-qa repo; Clone Percona Server for MySQL 5. You can have almost real-time backups in 6 simple steps by setting up a replication environment with Percona XtraBackup. PXC helps enterprises minimize unexpected downtime and data loss, reduce costs, and improve performance and scalability of your database environments supporting your critical business Jul 11, 2024 · Create a full backup. Percona XtraBackup supports the following keyring components and plugins: These components are stored in the plugin directory. 0-1 (2024-03-27) Get expert help¶. If you don’t want to save your backup, you can use the --move-back option which will move the backed up data to the datadir. we observed slowness while execution of Backups. The --compress option uses either the quicklz , lz4 , or ZSTD compression algorithm to compress all output data. Nov 1, 2023 · Physical (Percona XtraBackup, RDS/LVM Snapshots, MySQL Enterprise Backup), and also you can use cp or rsync command lines to copy the datadir as long as mysql is down/stopped. Jul 4, 2023 · In my case I am having higher version of xtrabackup than mysql version. It was designed to back up XtraDB/InnoDB tables but can also back up other storage engines. The time taken for a new node to join the PXC Cluster is also significantly reduced as the SST process will complete faster. Logical (mysqldump, mydumper, mysqlpump, mysql shell only for mysql 8) Additionally, it’s recommended to create copies of binlog files. innobackupex is the symlink for *xtrabackup*. See Percona XtraBackup Overview: Compatibility with MariaDB for more information. However, if backups are both compressed and encrypted, they need to be decrypted before uncompressing. We recommend that you install Percona XtraBackup 2. This option is useful for setting up a new replica for this source. Storing backup history on the server was implemented to provide users with additional information about backups that are being taken. The name options are the following: STANDARD. Support for encrypted InnoDB tablespace backups with keyring_file has been implemented in Percona XtraBackup 2. Restoring partial backups should be done by importing the tables. xbstream. 23-14 for Linux on x86_64 (Percona Server (GPL), Release '14', Revision '3558242') xtrabackup --version xtrabackup version 8. During the backup process, you should see a lot of output showing the data files being copied, as well as the log file Install Percona XtraBackup 8. Percona XtraBackup performs online non-blocking, tightly compressed, highly Jul 11, 2024 · Create an incremental backup. 24 in the xbcloud binary. xtrabackup. The write speed is too slow which usually is a sign of IO congestion or network congestion. cnf file that are needed to restore the data and log files. In this case, xbcloud will probe. Percona XtraBackup is a set of following tools: innobackupex. If any of the matched or listed tables is deleted Nov 2, 2023 · Percona XtraBackup 8. For example, a chunk upload or download may fail if you have an unstable network connection or other network issues. The xtrabackup binary writes a file called xtrabackup_checkpoints into the backup’s target directory. mysql> select count(*) from employees. Starting with version 8. 7 from github. Use a YUM repo to install Percona XtraBackup. Jul 11, 2024 · Percona Xtrabackup is a tool that allows you to create backups of MySQL or MariaDB databases. Mariabackup is the recommended backup method to use instead of Percona XtraBackup. 6+. The xtrabackup --compress uses the qpress tool that you can install via the percona-release package configuration tool as follows: $ sudo percona-release enable tools. You can combine this with the –tables option to limit the files to examine. If you specify a relative path, the target directory will be relative to the current directory. Jul 11, 2024 · Percona XtraBackup supports encrypting and decrypting local and streaming backups with the upstream option, adding another protection layer. Install Percona 2022-07-19. Maintain fully available applications during planned maintenance windows with Percona XtraBackup. 4 using the following methods. STDOUT Datasink. There are three ways to create partial backups: Do not copy back the prepared backup. You can specify either --encrypt-key or --encrypt-key-file to provide the encryption key, but do not use both options. To do this, you should use the –stats option. With the FIFO data sink feature, users with a streaming capacity of 10Gbps (typically on a Local Area Network (LAN)) can benefit from faster backups by streaming data in parallel to an object storage. Find out the latest release notes, features, support options, and how to contact Percona for help. Jun 21, 2024 · To make a compressed backup, use the --compress option along with the --backup and --target-dir options. Jul 16, 2024 · Percona XtraBackup (PXB) is a 100% open source backup solution for all versions of Percona Server for MySQL and MySQL® that performs online non-blocking, tightly compressed, highly secure full backups on transactional systems. Specifies that xbstream automatically decrypts encrypted files when extracting input stream. By using the xbstream in streaming backups, you can additionally speed up the compression process with the --compress-threads option. Percona XtraDB Cluster (PXC) is a 100% open source, enterprise-grade, highly available clustering solution for MySQL multi-master setups based on Galera. 0 International License. Specifically, Percona XtraBackup 8. Enabling FLUSH TABLES WITH READ LOCK when the server has long-running queries can leave the server in a read-only mode until the queries finish. In order to keep it simple, here is a list of the things you Jan 19, 2024 · The xbcrypt binary overview. Jan 4, 2023 · The Percona XtraBackup tools provide a method of performing a hot backup of your MySQL data while the system is running. --incremental-dir = /data/backups/inc1. Percona XtraBackup is based on InnoDB’s crash-recovery functionality. Things you need¶ Setting up a replica for replication with Percona XtraBackup is a straightforward procedure. 35-31 supports taking backups of the following MySQL-compatible databases: Percona Server for MySQL 8. 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. These options are only recognized by xtrabackup binary i. You can use the environment variable or command For paid support and managed or consulting services , contact Percona Sales. 1. If the archiving directory is not configured in MySQL, Percona XtraBackup creates a temporary directory for the archive file. Jul 25, 2023 · Percona XtraBackup facilitates streaming through the use of an auxiliary tool called xbcloud. 35. 3 How Percona XtraBackup works How Percona XtraBackup works About Percona XtraBackup Percona XtraBackup features Oct 26, 2023 · Configure xtrabackup. Percona XtraBackup is based on how [ crash recovery] works. Percona XtraBackup does not automatically remove the compressed files. Recovering up to particular moment in database’s history can be done with xtrabackup and the binary logs of the server. This file contains a line showing the to_lsn, which is the database’s LSN at the end of the backup. providing a list of table names in a file. Percona XtraBackup is an open source tool for performing hot backups of MariaDB, MySQL and Percona Server databases. This is the default setting. The read speed is too slow which usually is a sign of IO congestion. Jul 11, 2024 · Point-in-time recovery. Data transferred during SST won’t be encrypted. salaries; Now let’s run a backup which will automatically aborts if it cannot take the global lock after waiting for some time: 1. --parallel can be used with --decompress option to decompress multiple files simultaneously. Command-line tools have limited interaction with the background operations and the logs provide the progress of an operation or more information about errors. This diagram displays the process of streaming a backup to object storage utilizing the current STDOUT datasink: XtraBackup spawns multiple copy threads. To create an incremental backup with page tracking, Percona XtraBackup uses the MySQL mysqlbackup component. 29 tables that have been modified using this algorithm. Percona Server for MySQL 8. In order to do so, there are privileges and permission requirements on its execution that must be fulfilled. 26-18. Jun 21, 2024 · Percona XtraBackup is designed to solve this problem. This feature adds an exponential backoff, or sleep Jun 21, 2024 · Percona XtraBackup 8. The --prepare phase has the following operations: As a Create a partial backup. 3 How Percona XtraBackup works How Percona XtraBackup works About Percona XtraBackup Percona XtraBackup features Jun 12, 2024 · To start the backup process run: $ xtrabackup --backup --target-dir = /data/backups/. a compiled *C* binary that provides functionality to Feb 9, 2024 · Usage: --decrypt=name. The encryption is implemented using the libgcrypt library from GnuPG. Get 2. To apply the first incremental backup to the full backup, run the following command: $ xtrabackup --prepare --apply-log-only --target-dir = /data/backups/base \. Open source tool for performing hot backups of MariaDB, MySQL and Percona Server databases. The project maintains its own repositories that we can add to our MySQL server to gain access to the packages. innobackupex still. 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. For convenience, xtrabackup binary has the --copy-back option to copy the backup to the datadir of the server: $ xtrabackup --copy-back --target-dir = /data/backups/. 1. Then it copies all the datafiles and InnoDB redo logs. You can redirect this output into a file in the target directory of the backup. 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. 0. You can perform many incremental backups between each full backup, so you can set up a backup process such as a full backup once a week and an incremental backup every day, or full backups every day and incremental backups every hour. 0, xtrabackup no longer creates the xtrabackup_binlog_pos_innodb file. cnf file. Options ¶ The following are the options, environment variables, and descriptions for uploading a backup to Azure using the REST API. xtrabackup --print-param prints out something like the following: # This MySQL options file was generated by XtraBackup. Mariabackup is a fork of Percona XtraBackup designed to Feb 15, 2023 · Percona XtraBackup documentation is (C)2009-2023 Percona LLC and/or its affiliates and is distributed under the Creative Commons Attribution 4. Jun 12, 2024 · Backup needs to be prepared before it can be restored. 33-28 and lower versions. Dec 1, 2018 · xtrabackup: Error: xtrabackup_copy_logfile () failed. To use this option, you must run Percona XtraBackup as the same owner as mysqld. Minor build version - an internal number that denotes the version of the software. The instructions to install Percona XtraBackup 8. The xtrabackup binary reads the mysqld and xtrabackup sections from any configuration files, in that order. ibd file. 28-20 implements the XBCRYPT_ENCRYPTION_KEY environment variable. To start the backup process run: $ xtrabackup --backup --target-dir = /data/backups/. It connects to the database and retrieves information about it, and executes commands that are required during the process. 2. Percona XtraBackup can perform compressed, incremental and streaming backups. 2 by implementing xtrabackup. Encryption Disabled (Default): Set encrypt=0 to disable encryption. 0-1 define the following information: Base version - the leftmost numbers indicate the MySQL 8. Nov 2, 2023 · Dictionary cache. Apr 4, 2024 · The xtrabackup binary can analyze InnoDB data files in read-only mode to give statistics about them. If the target directory does not exist, xtrabackup creates it. 34-29, Percona XtraBackup supports backing up databases compatible with MySQL 8. This file contains the binary log file name and position of the exact point when the backup was taken. The first thing we need to do is install the actual Percona backup utilities. 0-1 (2023-11-02) Quickstart Guide Quickstart Guide Quickstart Guide for Percona XtraBackup 8. 0-1 (2023-12-11) Percona XtraBackup 8. Nov 2, 2023 · Percona XtraBackup 8. 0 overview. Warning. Percona XtraBackup features partial backups, which means that you may backup only some specific tables or databases. 4. It is passed directly to the xtrabackup child process. Jul 11, 2024 · If the data is stored on a single file, this option has no effect. Specify the S3 storage class. 3, but the destination does. Oct 10, 2023 · Just FYI, mysqldump works fine but percona xtrabackup doesn’t. 0-1 (2024-03-27) Percona XtraBackup 8. 4 from the official Percona software repositories using the appropriate package manager for your system: Use an APT repo. Percona XtraBackup uses this automatically to copy non-InnoDB data to avoid blocking DML queries Both xtrabackup and innobackupex tools supports incremental backups, which means that it can copy only the data that has changed since the last full backup. Backup history information will be stored in the PERCONA_SCHEMA. Aug 21, 2023 · To create an incremental backup with page tracking, Percona XtraBackup uses the MySQL mysqlbackup component. 0 documentation. 0 are available in the Percona XtraBackup 8. Percona XtraBackup 8. This will store the backup at /data/backups/. Jul 11, 2024 · Percona XtraBackup supports storing the backups history on the server. Jun 21, 2024 · In this case, xbcloud will probe. There are three ways to create partial backups: matching the tables names with a regular expression. When this finishes, you should see an InnoDB shutdown with a message such as the following, where again All described in this section has no effect when backup locks are used. If the server is in either the Waiting Learn how to use Percona XtraBackup, an open-source tool that can back up data from InnoDB, XtraDB, and MyISAM tables without locking the database. Encryption Enabled (Recommended): The prepare step is very simple to use: you simply run xtrabackup with the --prepare option and tell it which directory to prepare, for example, to prepare the previously taken backup run: $ xtrabackup --prepare --target-dir = /data/backups/. 35, and MySQL 8. 34 and later. With Percona XtraBackup, you can export individual tables from any InnoDB database, and import them into Percona Server for MySQL with XtraDB or MySQL 8. That was required to overcome some limitations of traditional archive formats such as tar, cpio and others which did not allow streaming dynamically generated files, for Nov 12, 2020 · Percona XtraBackup 2. Exponential backoff increases the chances for the completion of a backup or a restore operation. If you want to skip writing the username and password every time you want to access MySQL , you can set it up in . Command. 25-17 based on MySQL server 8. Daily Full Backup Script. xtrabackup supports taking partial backups when the innodb_file_per_table option is enabled. To create a backup, run xtrabackup with the --backup option. During the backup process, you should see a lot of output showing the data files being copied, as well as the log file Nov 2, 2023 · Install from a binary tarball. 33-28, xtrabackup –prepare is faster and memory efficient with the dictionary cache. To support simultaneous compression and streaming, a new custom streaming format called xbstream was introduced to Percona XtraBackup in addition to the TAR format. Restoring partial backups should be done by importing the tables, not by using the –copy-back option. To support encryption and decryption of the backups, a new tool xbcrypt was introduced to Percona XtraBackup. 3 version used as a base. The reason for opening the files in read-write mode is that xtrabackup uses the embedded InnoDB libraries to open and read the files, and InnoDB opens Jun 21, 2024 · Take an incremental backup using page tracking. The quicklz algorithm is chosen by default. 34. Replace these with your actual values. Percona XtraBackup is not supported in MariaDB. Generates a timestamp with the date command for the full backup filename. By default, the --compress option uses the zstandard tool that you can install with the percona-release package configuration tool as follows: Enable the repository Jun 21, 2024 · Percona XtraBackup can export a table that is contained in its own . Each one will be reading a chunk of data from a specific file. The source doesn’t have to be XtraDB or MySQL 8. Extract the binary tarballs to any path. employees,employees. More details of this procedure can be found in How to setup a replica for replication in 6 simple steps with Percona XtraBackup. conf files for each version of PS and XtraBackup; Pass different combination of options to PS start command and initialize PS servers each time with different options Jul 11, 2024 · xtrabackup opens the source data files in read-write mode, although it does not modify the files. Jun 25, 2021 · To perform a backup, XtraBackup does a lot of different things. Binary tarballs contain precompiled executable files, libraries, and other dependencies and are compressed tar archives. Percona Toolkit for MySQL - a collection of advanced Jul 25, 2023 · As you can see, from Percona XtraBackup 8. This works because InnoDB maintains a redo log, also called the transaction log. Aug 30, 2017 · Installing the Percona Xtrabackup Tools. A local or streaming backup can be compressed or decompressed with xbstream. May 30, 2024 · Percona XtraBackup 8. 27-19, the xbcloud binary adds support for the Microsoft Azure Cloud Storage using the REST API. 33-28 implements a new data sink that uses the first in, first out (FIFO) method. –s3-storage-class=. Percona XtraBackup User Manual. As the contents of the datafiles change during the backup, the copy is inconsistent. Currently, the following algorithms are supported: AES128 , AES192 and AES256. Nov 10, 2022 · This option instructs xtrabackup to encrypt backup copies of InnoDB data files using the algorithm specified in the ENCRYPTION_ALGORITHM. . With Percona XtraBackup, you can achieve the following benefits: See the compatibility matrix in Percona Software and Platform Lifecycle to find out which versions of This can be done by either running xtrabackup --prepare or innobackupex --apply-log. When using --compress=quicklz or --compress , the resulting files have the qpress archive format. To make an incremental backup, begin with a full backup as usual. Percona XtraBackup based backups also allow for table level recovery even though the backup was done at the database level (needs the recovery database server to be Percona Server for MySQL with XtraDB Oct 6, 2023 · Percona XtraBackup has implemented --decompress option that can be used to decompress the backup. 3. Partial Backups. The tables you back up must be in separate tablespaces, as a result of being created or altered after you enabled the innodb_file_per_table option on the server. uq su be ta sf ld ft ae ot nf