Skip to content
Starting November 2023 Percona XtraBackup 2.4 has reached EOL status. If you have 5.7 databases, we encourage you to upgrade to 8.0 and then install Percona XtraBackup 8.0. Learn more

logo
Percona XtraBackup
Frequently Asked Questions
Initializing search
    percona/pxb-docs
    percona/pxb-docs
    • Home
      • About Percona XtraBackup
      • How Percona XtraBackup Works
      • Understand version numbers
      • Installing Percona XtraBackup 2.4
      • Installing Percona XtraBackup on Debian and Ubuntu
      • Installing Percona XtraBackup on Red Hat Enterprise Linux and CentOS
      • Installing Percona XtraBackup from a Binary Tarball
      • Compiling and Installing from Source Code
      • Running Percona XtraBackup in a Docker container
      • Connection and Privileges Needed
      • Configuring xtrabackup
      • The Backup Cycle - Full Backups
      • Incremental Backup
      • Compressed Backup
      • Encrypted Backup
      • Percona XtraBackup User Manual
      • Throttling Backups
      • Lockless binary log information
      • Encrypted InnoDB Tablespace Backups
      • lock-ddl-per-table Option Improvements
      • How-tos and Recipes
        • Release notes index
        • Percona XtraBackup 2.4.29 (2023-12-18)
        • Percona XtraBackup 2.4.28 (2023-04-04)
        • Percona XtraBackup 2.4.27 (2022-12-06)
        • Percona XtraBackup 2.4.26
        • Percona XtraBackup 2.4.25
        • Percona XtraBackup 2.4.24
        • Percona XtraBackup 2.4.23
        • Percona XtraBackup 2.4.22
        • Percona XtraBackup 2.4.21
        • Percona XtraBackup 2.4.20
        • Percona XtraBackup 2.4.19
        • Percona XtraBackup 2.4.18
        • Percona XtraBackup 2.4.17
        • Percona XtraBackup 2.4.16
        • Percona XtraBackup 2.4.15
        • Percona XtraBackup 2.4.14
        • Percona XtraBackup 2.4.13
        • Percona XtraBackup 2.4.12
        • Percona XtraBackup 2.4.11
        • Percona XtraBackup 2.4.10
        • Percona XtraBackup 2.4.9
        • Percona XtraBackup 2.4.8
        • Percona XtraBackup 2.4.7-2
        • Percona XtraBackup 2.4.7
        • Percona XtraBackup 2.4.6
        • Percona XtraBackup 2.4.5
        • Percona XtraBackup 2.4.4
        • Percona XtraBackup 2.4.3
        • Percona XtraBackup 2.4.2
        • Percona XtraBackup 2.4.1
      • The xtrabackup Option Reference
      • The innobackupex Option Reference
      • The xbcloud Binary
      • Exponential Backoff
      • Using the xbcloud binary with Microsoft Azure Cloud Storage
      • The xbcrypt binary
      • The xbstream binary
      • Known issues and limitations
      • Frequently Asked Questions
        • Do I need an InnoDB Hot Backup license to use Percona XtraBackup?
        • What’s the difference between innobackupex and innobackup?
        • Which Web-based backup tools are based on Percona XtraBackup?
        • xtrabackup binary fails with a floating point exception
        • How does xtrabackup handle the ibdata/ib_log files on restore if they are not in the MySQL datadir?
        • Backup fails with Error 24: ‘Too many open files’
        • How to deal with skipping of redo logs for DDL operations?
      • Glossary
      • Index of files created by Percona XtraBackup
      • Trademark policy
      • Copyright and licensing information
      • Version Checking

    • Do I need an InnoDB Hot Backup license to use Percona XtraBackup?
    • What’s the difference between innobackupex and innobackup?
    • Which Web-based backup tools are based on Percona XtraBackup?
    • xtrabackup binary fails with a floating point exception
    • How does xtrabackup handle the ibdata/ib_log files on restore if they are not in the MySQL datadir?
    • Backup fails with Error 24: ‘Too many open files’
    • How to deal with skipping of redo logs for DDL operations?

    Frequently Asked Questions¶

    Do I need an InnoDB Hot Backup license to use Percona XtraBackup?¶

    No. Although innobackupex is derived from the same GPL and open-source wrapper script that InnoDB Hot Backup uses, it does not execute ibbackup, and the xtrabackup binary does not execute or link to ibbackup. You can use Percona XtraBackup without any license; it is completely separate from InnoDB Hot Backup.

    What’s the difference between innobackupex and innobackup?¶

    The innobackupex binary is a patched version of the Oracle innobackup script (renamed mysqlbackup). They are similar, and familiarity with innobackup might be helpful.

    Besides the available options for specific features of innobackupex, the main differences are:

    • Prints to STDERR instead of STDOUT which enables the innobackupex --stream option

    • Detects the configuration file - my.cnf - is automatically (or set with innobackupex --defaults-file) instead of requiring the configuration file as the the first argument

    • Defaults to xtrabackup as binary to use in the innobackupex --ibbackup

    See The innobackupex Option Reference for more details.

    Which Web-based backup tools are based on Percona XtraBackup?¶

    Zmanda Recovery Manager is a commercial tool that uses Percona XtraBackup for Non-Blocking Backups:

    “ZRM provides support for non-blocking backups of MySQL using Percona XtraBackup. ZRM with Percona XtraBackup provides resource utilization management by providing throttling based on the number of IO operations per second. Percona XtraBackup based backups also allow for table-level recovery even though the backup was done at the database level. This operation requires the recovery database server to be Percona Server for MySQL with XtraDB.”

    xtrabackup binary fails with a floating point exception¶

    In most of the cases this is due to not having installed the required libraries (and version) by xtrabackup. Installing the GCC suite with the supporting libraries and recompiling xtrabackup will solve the issue. See Compiling and Installing from Source Code for instructions on the procedure.

    How does xtrabackup handle the ibdata/ib_log files on restore if they are not in the MySQL datadir?¶

    If the ibdata and ib_log files are located in different directories outside of the datadir, you move them to their proper place after the logs have been applied.

    Backup fails with Error 24: ‘Too many open files’¶

    This error usually occurs when the database being backed up contains large amount of files and Percona XtraBackup can’t open all of them to create a successful backup. In order to avoid this error the operating system should be configured appropriately so that Percona XtraBackup can open all its files. On Linux, this can be done with the ulimit command for specific backup session or by editing the /etc/security/limits.conf to change it globally

    Note

    The maximum possible value that can be set up is 1048576 which is a hard-coded constant in the Linux kernel.

    How to deal with skipping of redo logs for DDL operations?¶

    To prevent creating corrupted backups when running DDL operations, Percona XtraBackup aborts if it detects that redo logging is disabled. In this case, the following error is printed:

    [FATAL] InnoDB: An optimized (without redo logging) DDL operation has been performed. All modified pages may not have been flushed to the disk yet.
    Percona XtraBackup will not be able to take a consistent backup. Retry the backup operation.
    

    Note

    Redo logging is disabled during a sorted index build

    To avoid this error, Percona XtraBackup can use metadata locks on tables while they are copied:

    • To block all DDL operations, use the xtrabackup --lock-ddl option that issues LOCK TABLES FOR BACKUP.

    • If LOCK TABLES FOR BACKUP is not supported, you can block DDL for each table before XtraBackup starts to copy it and until the backup is completed using the xtrabackup --lock-ddl-per-table option.

    Contact us

    For free technical help, visit the Percona Community Forum.

    To report bugs or submit feature requests, open a JIRA ticket.

    For paid support and managed or consulting services , contact Percona Sales.

    2022-11-10
    Percona LLC and/or its affiliates, © 2024 Cookie Preferences
    Made with Material for MkDocs