mysql xtrabackup 使用说明

谁践踏了优雅 2022-10-16 11:25 191阅读 0赞

--------------------

### mysql xtrabackup 使用说明 ###

### \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* ###

**xtrabackup 安装及删除**

**xtrabackup 安装**

yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm
    percona-release enable-only tools release
    yum install percona-xtrabackup-80
    
    #使用压缩功能，选装qpress
    yum install qpress

**xtrabackup 删除：yum remove percona-xtrabackup**

### \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* ###

**[命令格式][Link 1]**

**用法：xtrabackup \[--defaults-file\] mode options，xtrabackup支持以下模式**

**--backup：**备份数据

**--prepare：**修复备份文件数据

**--copy-back：**复制prepare后的数据到指定目录

**--move-back：**移动prepare后的数据到指定目录

**--stats：**扫描指定的数据文件、输出统计数据

[root@centos ~]# xtrabackup --help
    xtrabackup: recognized server arguments: --datadir=/var/lib/mysql 
    xtrabackup version 8.0.25-17 based on MySQL server 8.0.25 Linux (x86_64) (revision id: d27028b)
    Open source backup tool for InnoDB and XtraDB
    
    Copyright (C) 2009-2019 Percona LLC and/or its affiliates.
    Portions Copyright (C) 2000, 2011, MySQL AB & Innobase Oy. All Rights Reserved.
    
    This program is free software; you can redistribute it and/or
    modify it under the terms of the GNU General Public License
    as published by the Free Software Foundation version 2
    of the License.
    
    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.
    
    You can download full text of the license on http://www.gnu.org/licenses/gpl-2.0.txt
    
    Usage: [xtrabackup [--defaults-file=#] --backup | xtrabackup [--defaults-file=#] --prepare] [OPTIONS]
    
    #默认参数读取顺序
    Default options are read from the following files in the given order:
    /etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf 
    
    
    The following groups are read: xtrabackup mysqld
    
    
    # xtrabackup 第一个参数
    The following options may be given as the first argument:
    --print-defaults        Print the program argument list and exit.        #输出参数列表，然后退出
    --no-defaults           Don't read default options from any option file, 
                            except for login file.                           #除了login file文件，不从其他文件中读取参数配置信息
    --defaults-file=#       Only read default options from the given file #. #指从指定的文件中读取默认参数信息
    --defaults-extra-file=# Read this file after the global files are read.  #读取全局文件后，再读取该文件
    --defaults-group-suffix=# Read the configuration groups with the given suffix
                            Also read groups with concat(group, suffix)      #根据指定后缀读取配置文件组
    --login-path=#          Read this path from the login file.              #从login file的指定路径下读取配置信息
    
    
    # xtrabackup mode，只能选择其中之一
      --backup            take backup to target-dir                                  #备份数据到指定目录
      --prepare           prepare a backup for starting mysql server on the backup.  #对备份后的数据进行预处理
      --copy-back         Copy all the files in a previously made backup from the
                          backup directory to their original locations.              #复制prepare后的数据到数据目录
      --move-back         Move all the files in a previously made backup from the
                          backup directory to the actual datadir location. Use with
                          caution, as it removes backup files.                       #移动prepare后的备份数据到数据目录，谨慎使用
      --stats             calc statistic of datadir (offline mysqld is recommended)  #统计目录信息
    
    
      -v, --version       print xtrabackup version information
    
    
    # 用户名、密码、主机、端口
      -u, --user=name     This option specifies the MySQL username used when
                          connecting to the server, if that's not the current user.
                          The option accepts a string argument. See mysql --help
                          for details.
      -p, --password[=name] 
                          This option specifies the password to use when connecting
                          to the database. It accepts a string argument.  See mysql
                          --help for details.
      -H, --host=name     This option specifies the host to use when connecting to
                          the database server with TCP/IP.  The option accepts a
                          string argument. See mysql --help for details.
      -P, --port=#        This option specifies the port to use when connecting to
                          the database server with TCP/IP.  The option accepts a
                          string argument. See mysql --help for details.
    
    
    # 数据目录，需要与配置文件中的数据目录一致，如果不一致，需要使用该参数指定
      -h, --datadir=name  Path to the database root.
    
    # 临时数据目录，用 : 间隔
      -t, --tmpdir=name   Path for temporary files. Several paths may be specified,
                          separated by a colon (:), in this case they are used in a
                          round-robin fashion.
    
    # 备份数据存储目录
      --target-dir=name   destination directory
    
    
    # 二进制日志配置
      --log[=name]        Ignored option for MySQL option compatibility
      --log-bin[=name]    Base name for the log sequence    # 二进制日志的basename，默认为 /var/lib/mysql/binlog，如果不一致，需自行设置
      --log-bin-index=name                                  # 二进制日志索引文件名称，默认为 /var/lib/mysql/binlog.index，如果不一致，需自行设置
                          File that holds the names for binary log files.
      --log-copy-interval=# 
                          time interval between checks done by log copying thread
                          in milliseconds (default is 1 second).
    
    
    
    
    # 指定复制的表，格式：databaseName[.tableName]，可为正则表达式
      --tables=name       filtering by regexp for table names.
    
    # 指定复制的数据库，不支持正则表达式，格式：databaseName[.tablename]
    # 如果不指定[.tablename]，则复制数据库下所有的表
      --databases=name    filtering by list of databases.
    
    # 在文件中指定复制的数据库、表，格式同上
      --tables-file=name  filtering by list of the exact database.table name in the
                          file.
      --databases-file=name 
                          filtering by list of databases in the file.
    
    # 不复制的数据库、表，优先级更高
      --tables-exclude=name 
                          filtering by regexp for table names. Operates the same
                          way as --tables, but matched names are excluded from
                          backup. Note that this option has a higher priority than
                          --tables.
      --databases-exclude=name 
                          Excluding databases based on name, Operates the same way
                          as --databases, but matched names are excluded from
                          backup. Note that this option has a higher priority than
                          --databases.
    
    
    # 增量复制
      --incremental-lsn=name 
                          (for --backup): copy only .ibd pages newer than specified
                          LSN 'high:low'. ##ATTENTION##: If a wrong LSN value is
                          specified, it is impossible to diagnose this, causing the
                          backup to be unusable. Be careful!
      --incremental-basedir=name 
                          (for --backup): copy only .ibd pages newer than backup at
                          specified directory.
    When creating an incremental backup, this is the directory containing 
    the full backup that is the base dataset for the incremental backups
    增量复制时使用，该目录包含全量数据，是制作增量复制的基础数据集
    
      --incremental-force-scan
                          Perform a full-scan incremental backup even in the
                          presence of changed page bitmap data
                          #增量复制时，强制扫描所有的数据页
    
      --incremental-history-name=name 
                          This option specifies the name of the backup series
                          stored in the PERCONA_SCHEMA.xtrabackup_history history
                          record to base an incremental backup on. Xtrabackup will
                          search the history table looking for the most recent
                          (highest innodb_to_lsn), successful backup in the series
                          and take the to_lsn value to use as the starting lsn for
                          the incremental backup. This will be mutually exclusive
                          with --incremental-history-uuid, --incremental-basedir
                          and --incremental-lsn. If no valid lsn can be found (no
                          series by that name, no successful backups by that name)
                          xtrabackup will return with an error. It is used with the
                          --incremental option.
      --incremental-history-uuid=name 
                          This option specifies the UUID of the specific history
                          record stored in the PERCONA_SCHEMA.xtrabackup_history to
                          base an incremental backup on.
                          --incremental-history-name, --incremental-basedir and
                          --incremental-lsn. If no valid lsn can be found (no
                          success record with that uuid) xtrabackup will return
                          with an error. It is used with the --incremental option.
    
    
    
    # prepare使用参数
      --incremental-dir=name 
                          (for --prepare): apply .delta files and logfile in the
                          specified directory.
    When preparing an incremental backup, this is the directory where the 
    incremental backup is combined with the full backup to make a new full backup
    在增量复制数据prepare阶段，使用该目录下的数据和全量数据制作生成新的全量数据
    
    
    # 增量复制prepare阶段，只应用日志，不进行回滚
      --apply-log-only    stop recovery process not to progress LSN after applying
                          log when prepare.
    
    # 部分复制prepare阶段，新建文件用于导入另一个数据库中
      --export            create files to import to another database when prepare.
    
    
    # 复制限流
      --throttle=#        limit count of IO operations (pairs of read&write) per
                          second to IOS values (for '--backup')
    
    
    
      --print-param       print parameter of mysqld needed for copyback.
      --use-memory=#      The value is used instead of buffer_pool_size
      --extra-lsndir=name (for --backup): save an extra copy of the
                          xtrabackup_checkpoints file in this directory.
      --to-archived-lsn=# Don't apply archived logs with bigger log sequence
                          number.
      --create-ib-logfile ** not work for now** creates ib_logfile* also after
                          '--prepare'. ### If you want create ib_logfile*, only
                          re-execute this command in same options. ###
      --stream=name       Stream all backup files to the standard output in the
                          specified format. Currently supported formats are 'tar'
                          and 'xbstream'.
    
    # 文件复制并行线程数，默认为1
      --parallel=#        Number of threads to use for parallel datafiles transfer.
                          The default value is 1.
    
    # prepare、rebuild-index使用的线程数
      --rebuild-threads=# Use this number of threads to rebuild indexes in a
                          compact backup. Only has effect with --prepare and
                          --rebuild-indexes.
    
    #压缩、解压
      --compress[=name]   Compress individual backup files using the specified
                          compression algorithm. Supported algorithms are 'quicklz'
                          and 'lz4'. The default algorithm is 'quicklz'.            #支持的压缩算法：quicklz（默认）、lz4
      --compress-threads=# 
                          Number of threads for parallel data compression. The
                          default value is 1.                                       #压缩线程，默认为1
      --compress-chunk-size=# 
                          Size of working buffer(s) for compression threads in
                          bytes. The default value is 64K.                          #压缩缓存块，默认为64k
      --decompress        Decompresses all files with the .qp extension in a backup
                          previously made with the --compress option.               #解压缩，与compress对应
    
    
    # 加密、解密
      --encrypt=name      Encrypt individual backup files using the specified
                          encryption algorithm.
      --encrypt-key=name  Encryption key to use.
      --encrypt-key-file=name 
                          File which contains encryption key to use.
      --encrypt-threads=# Number of threads for parallel data encryption. The
                          default value is 1.
      --encrypt-chunk-size=# 
                          Size of working buffer(S) for encryption threads in
                          bytes. The default value is 64K.
      --decrypt=name      Decrypts all files with the .xbcrypt extension in a
                          backup previously made with --encrypt option.
    
    
    
    # 备份Percona-XtraDB-Cluster时使用
      --galera-info       This options creates the xtrabackup_galera_info file
                          which contains the local node state at the time of the
                          backup. Option should be used when performing the backup
                          of Percona-XtraDB-Cluster. Has no effect when backup
                          locks are used to create the backup.
    
    # 备份从节点时使用，输出主节点的日志偏移量、名称，将change master写入xtrabackup_slave_info文件
      --slave-info        This option is useful when backing up a replication slave
                          server. It prints the binary log position and name of the
                          master server. It also writes this information to the
                          "xtrabackup_slave_info" file as a "CHANGE MASTER"
                          command. A new slave for this master can be set up by
                          starting a slave server on this backup and issuing a
                          "CHANGE MASTER" command with the binary log position
                          saved in the "xtrabackup_slave_info" file.
      --safe-slave-backup This option stops slave SQL thread at the start of the
                          backup and waits to start backup until
                          Slave_open_temp_tables in "SHOW STATUS" is zero. If there
                          are no open temporary tables, the backup will take place,
                          otherwise the SQL thread will be started and stopped
                          until there are no open temporary tables. The backup will
                          fail if Slave_open_temp_tables does not become zero after
                          --safe-slave-backup-timeout seconds. The slave SQL thread
                          will be restarted when the backup finishes.
    
    # 锁相关参数
      --no-lock           Use this option to disable lock-ddl and table lock with
                          "FLUSH TABLES WITH READ LOCK". Use it only if ALL your
                          tables are InnoDB and you DO NOT CARE about the binary
                          log position of the backup. This option shouldn't be used
                          if there are any DDL statements being executed or if any
                          updates are happening on non-InnoDB tables (this includes
                          the system MyISAM tables in the mysql database),
                          otherwise it could lead to an inconsistent backup. If you
                          are considering to use --no-lock because your backups are
                          failing to acquire the lock, this could be because of
                          incoming replication events preventing the lock from
                          succeeding. Please try using --safe-slave-backup to
                          momentarily stop the replication slave thread, this may
                          help the backup to succeed and you then don't need to
                          resort to using this option.
      --lock-ddl          Issue LOCK TABLES/LOCK INSTANCE FOR BACKUP if it is
                          supported by server at the beginning of the backup to
                          block all DDL operations.
                          (Defaults to on; use --skip-lock-ddl to disable.)
      --lock-ddl-timeout=# 
                          If LOCK TABLES FOR BACKUP does not return within given
                          timeout, abort the backup.
      --lock-ddl-per-table 
                          Lock DDL for each table before xtrabackup starts the copy
                          phase and until the backup is completed.
      --backup-lock-timeout=# 
                          Timeout in seconds for attempts to acquire metadata
                          locks.
      --backup-lock-retry-count=# 
                          Number of attempts to acquire metadata locks.
      --no-backup-locks   This option controls if backup locks should be used
                          instead of FLUSH TABLES WITH READ LOCK on the backup
                          stage. It will disable lock-ddl. The option has no effect
                          when backup locks are not supported by the server. This
                          option is disabled by default, disable with
                          --no-backup-locks.
    
    
      --dump-innodb-buffer-pool 
                          Instruct MySQL server to dump innodb buffer pool by
                          issuing a SET GLOBAL innodb_buffer_pool_dump_now=ON 
      --dump-innodb-buffer-pool-timeout=# 
                          This option specifies the number of seconds xtrabackup
                          waits for innodb buffer pool dump to complete
      --dump-innodb-buffer-pool-pct=# 
                          This option specifies the percentage of buffer pool to be
                          dumped 
    
    
    
      --close-files       do not keep files opened. Use at your own risk.
      --core-file         Write core on fatal signals
      --rsync             Uses the rsync utility to optimize local file transfers.
                          When this option is specified, innobackupex uses rsync to
                          copy all non-InnoDB files instead of spawning a separate
                          cp for each file, which can be much faster for servers
                          with a large number of databases or tables.  This option
                          cannot be used together with --stream.
      --force-non-empty-directories 
                          This option, when specified, makes --copy-back or
                          --move-back transfer files to non-empty directories. Note
                          that no existing files will be overwritten. If
                          --copy-back or --nove-back has to copy a file from the
                          backup directory which already exists in the destination
                          directory, it will still fail with an error.
      --no-server-version-check 
                          This option allows backup to proceed when the server
                          version is greater (newer) than the PXB supported version
      --no-version-check  This option disables the version check which is enabled
                          by the --version-check option.
      --tables-compatibility-check 
                          This option enables engine compatibility warning.
                          (Defaults to on; use --skip-tables-compatibility-check to disable.)
      --rollback-prepared-trx 
                          Force rollback prepared InnoDB transactions.
    
      -S, --socket=name   This option specifies the socket to use when connecting
                          to the local database server with a UNIX domain socket. 
                          The option accepts a string argument. See mysql --help
                          for details.
      --remove-original   Remove .qp and .xbcrypt files after decryption and
                          decompression.
      --ftwrl-wait-query-type=name 
                          This option specifies which types of queries are allowed
                          to complete before innobackupex will issue the global
                          lock. Default is all.
      --kill-long-query-type=name 
                          This option specifies which types of queries should be
                          killed to unblock the global lock. Default is "all".
      --history[=name]    This option enables the tracking of backup history in the
                          PERCONA_SCHEMA.xtrabackup_history table. An optional
                          history series name may be specified that will be placed
                          with the history record for the current backup being
                          taken.
      --kill-long-queries-timeout=# 
                          This option specifies the number of seconds innobackupex
                          waits between starting FLUSH TABLES WITH READ LOCK and
                          killing those queries that block it. Default is 0
                          seconds, which means innobackupex will not attempt to
                          kill any queries.
      --ftwrl-wait-timeout=# 
                          This option specifies time in seconds that innobackupex
                          should wait for queries that would block FTWRL before
                          running it. If there are still such queries when the
                          timeout expires, innobackupex terminates with an error.
                          Default is 0, in which case innobackupex does not wait
                          for queries to complete and starts FTWRL immediately.
      --ftwrl-wait-threshold=# 
                          This option specifies the query run time threshold which
                          is used by innobackupex to detect long-running queries
                          with a non-zero value of --ftwrl-wait-timeout. FTWRL is
                          not started until such long-running queries exist. This
                          option has no effect if --ftwrl-wait-timeout is 0.
                          Default value is 60 seconds.
      --debug-sleep-before-unlock=# 
                          This is a debug-only option used by the XtraBackup test
                          suite.
      --safe-slave-backup-timeout=# 
                          How many seconds --safe-slave-backup should wait for
                          Slave_open_temp_tables to become zero. (default 300)
      --check-privileges  Check database user privileges before performing any
                          query.
      --read-buffer-size[=#] 
                          Set datafile read buffer size, given value is scaled up
                          to page size. Default is 10Mb.
      --server-public-key-path=name 
                          File path to the server public RSA key in PEM format.
      --get-server-public-key 
                          Get server public key
      --server-public-key-path=name 
                          File path to the server public RSA key in PEM format.
      --transition-key[=name] 
                          Transition key to encrypt tablespace keys with.
      --xtrabackup-plugin-dir=name 
                          Directory for xtrabackup plugins.
      --plugin-load=name  List of plugins to load.
      --generate-new-master-key 
                          Generate new master key when doing copy-back.
      --generate-transition-key 
                          Generate transition key and store it into keyring.
      --keyring-file-data[=name] 
                          Path to keyring file.
      --component-keyring-file-config[=name] 
                          Path to load keyring component config. Used for
                          --prepare, --move-back, --copy-back and --stats.
      --strict            Fail with error when invalid arguments were passed to the
                          xtrabackup.
      --rocksdb-checkpoint-max-age=# 
                          Maximum ROCKSB checkpoint age in seconds.
      --rocksdb-checkpoint-max-count=# 
                          Maximum count of ROCKSB checkpoints.
    
    
    # InnoDB相关参数
      --innodb[=name]     Ignored option for MySQL option compatibility
      --innodb-adaptive-hash-index 
                          Enable InnoDB adaptive hash index (enabled by default). 
                          Disable with --skip-innodb-adaptive-hash-index.
                          (Defaults to on; use --skip-innodb-adaptive-hash-index to disable.)
      --innodb-autoextend-increment=# 
                          Data file autoextend increment in megabytes
      --innodb-buffer-pool-size=# 
                          The size of the memory buffer InnoDB uses to cache data
                          and indexes of its tables.
      --innodb-checksums  Enable InnoDB checksums validation (enabled by default).
                          Disable with --skip-innodb-checksums.
                          (Defaults to on; use --skip-innodb-checksums to disable.)
      --innodb-data-file-path=name 
                          Path to individual files and their sizes.
      --innodb-data-home-dir=name 
                          The common part for InnoDB table spaces.
      --innodb-io-capacity[=#] 
                          Number of IOPs the server can do. Tunes the background IO
                          rate
      --innodb-file-io-threads=# 
                          Number of file I/O threads in InnoDB.
      --innodb-read-io-threads=# 
                          Number of background read I/O threads in InnoDB.
      --innodb-write-io-threads=# 
                          Number of background write I/O threads in InnoDB.
      --innodb-file-per-table 
                          Stores each InnoDB table to an .ibd file in the database
                          dir.
      --innodb-flush-log-at-trx-commit[=#] 
                          Set to 0 (write and flush once per second), 1 (write and
                          flush at each commit) or 2 (write at commit, flush once
                          per second).
      --innodb-flush-method=name 
                          With which method to flush data.
      --innodb-force-recovery=# 
                          Helps to save your data in case the disk image of the
                          database becomes corrupt.
      --innodb-log-buffer-size=# 
                          The size of the buffer which InnoDB uses to write log to
                          the log files on disk.
      --innodb-log-file-size=# 
                          Size of each log file in a log group.
      --innodb-log-files-in-group=# 
                          Number of log files in the log group. InnoDB writes to
                          the files in a circular fashion. Value 3 is recommended
                          here.
      --innodb-log-group-home-dir=name 
                          Path to InnoDB log files.
      --innodb-max-dirty-pages-pct=# 
                          Percentage of dirty pages allowed in bufferpool.
      --innodb-open-files=# 
                          How many files at the maximum InnoDB keeps open at the
                          same time.
      --innodb-use-native-aio 
                          Use native AIO if supported on this platform.
      --innodb-page-size=# 
                          The universal page size of the database.
      --innodb-log-block-size=# 
                          The log block size of the transaction log file. Changing
                          for created log file is not supported. Use on your own
                          risk!
      --innodb-buffer-pool-filename=name 
                          Filename to/from which to dump/load the InnoDB buffer
                          pool
      --innodb-checksum-algorithm=name 
                          The algorithm InnoDB uses for page checksumming. [CRC32,
                          STRICT_CRC32, INNODB, STRICT_INNODB, NONE, STRICT_NONE]
      --innodb-log-checksums 
                          Whether to compute and require checksums for InnoDB redo
                          log blocks
                          (Defaults to on; use --skip-innodb-log-checksums to disable.)
      --innodb-undo-directory=name 
                          Directory where undo tablespace files live, this path can
                          be absolute.
      --innodb-directories=name 
                          List of directories 'dir1;dir2;..;dirN' to scan for
                          tablespace files. Default is to scan
                          'innodb-data-home-dir;innodb-undo-directory;datadir'
      --innodb-undo-tablespaces=# 
                          Number of undo tablespaces to use.
      --innodb-redo-log-encrypt 
                          Enable or disable Encryption of REDO tablespace.
      --innodb-undo-log-encrypt 
                          Enable or disable Encrypt of UNDO tablespace.
    
    
    
      --debug-sync=name   Debug sync point. This is only used by the xtrabackup
                          test suite
      --temp-tablespaces-dir=name 
                          Directory where temp tablespace files live, this path can
                          be absolute.
    
      --defaults-group=name 
                          defaults group in config file (default "mysqld").
      --open-files-limit=# 
                          the maximum number of file descriptors to reserve with
                          setrlimit().
      --server-id=#       The server instance being backed up
      --rocksdb-datadir=name 
                          RocksDB data directory
      --rocksdb-wal-dir=name 
                          RocksDB WAL directory
    
    
    
    #默认参数值
    Variables (--variable-name=value)
    and boolean options {FALSE|TRUE}  Value (after reading options)
    --------------------------------- ----------------------------------------
    datadir                           /var/lib/mysql
    tmpdir                            /tmp
    log                               (No default value)
    log-bin                           (No default value)
    log-bin-index                     (No default value)
    innodb                            (No default value)
    innodb-adaptive-hash-index        TRUE
    innodb-autoextend-increment       8
    innodb-buffer-pool-size           8388608
    innodb-checksums                  TRUE
    innodb-data-file-path             (No default value)
    innodb-data-home-dir              (No default value)
    innodb-io-capacity                200
    innodb-file-io-threads            4
    innodb-read-io-threads            4
    innodb-write-io-threads           4
    innodb-file-per-table             FALSE
    innodb-flush-log-at-trx-commit    1
    innodb-flush-method               littlesync
    innodb-force-recovery             0
    innodb-log-buffer-size            16777216
    innodb-log-file-size              50331648
    innodb-log-files-in-group         2
    innodb-log-group-home-dir         (No default value)
    innodb-max-dirty-pages-pct        75
    innodb-open-files                 300
    innodb-use-native-aio             FALSE
    innodb-page-size                  16384
    innodb-log-block-size             512
    innodb-buffer-pool-filename       (No default value)
    debug-sync                        (No default value)
    innodb-checksum-algorithm         crc32
    innodb-log-checksums              TRUE
    innodb-undo-directory             (No default value)
    innodb-directories                (No default value)
    temp-tablespaces-dir              (No default value)
    innodb-undo-tablespaces           2
    innodb-redo-log-encrypt           FALSE
    innodb-undo-log-encrypt           FALSE
    defaults-group                    mysqld
    open-files-limit                  0
    server-id                         0
    rocksdb-datadir                   (No default value)
    rocksdb-wal-dir                   (No default value)
    
    Variables (--variable-name=value)
    and boolean options {FALSE|TRUE}  Value (after reading options)
    --------------------------------- ----------------------------------------
    version                           FALSE
    target-dir                        /root/xtrabackup_backupfiles/
    backup                            FALSE
    stats                             FALSE
    prepare                           FALSE
    export                            FALSE
    apply-log-only                    FALSE
    print-param                       FALSE
    use-memory                        104857600
    throttle                          0
    log                               (No default value)
    log-copy-interval                 1000
    extra-lsndir                      (No default value)
    incremental-lsn                   (No default value)
    incremental-basedir               (No default value)
    incremental-dir                   (No default value)
    to-archived-lsn                   0
    tables                            (No default value)
    tables-file                       (No default value)
    databases                         (No default value)
    databases-file                    (No default value)
    tables-exclude                    (No default value)
    databases-exclude                 (No default value)
    create-ib-logfile                 FALSE
    stream                            (No default value)
    compress                          (No default value)
    compress-threads                  1
    compress-chunk-size               65536
    encrypt                           NONE
    encrypt-key-file                  (No default value)
    encrypt-threads                   1
    encrypt-chunk-size                65536
    rebuild-threads                   1
    incremental-force-scan            FALSE
    close-files                       FALSE
    copy-back                         FALSE
    move-back                         FALSE
    galera-info                       FALSE
    slave-info                        FALSE
    no-lock                           FALSE
    lock-ddl                          TRUE
    lock-ddl-timeout                  31536000
    lock-ddl-per-table                FALSE
    backup-lock-timeout               31536000
    backup-lock-retry-count           0
    dump-innodb-buffer-pool           FALSE
    dump-innodb-buffer-pool-timeout   10
    dump-innodb-buffer-pool-pct       0
    safe-slave-backup                 FALSE
    rsync                             FALSE
    force-non-empty-directories       FALSE
    no-server-version-check           FALSE
    no-version-check                  FALSE
    tables-compatibility-check        TRUE
    no-backup-locks                   FALSE
    rollback-prepared-trx             FALSE
    decompress                        FALSE
    user                              (No default value)
    host                              (No default value)
    port                              0
    socket                            (No default value)
    incremental-history-name          (No default value)
    incremental-history-uuid          (No default value)
    decrypt                           NONE
    remove-original                   FALSE
    ftwrl-wait-query-type             ALL
    kill-long-query-type              SELECT
    kill-long-queries-timeout         0
    ftwrl-wait-timeout                0
    ftwrl-wait-threshold              60
    debug-sleep-before-unlock         0
    safe-slave-backup-timeout         300
    check-privileges                  FALSE
    read-buffer-size                  10485760
    server-public-key-path            (No default value)
    get-server-public-key             FALSE
    server-public-key-path            (No default value)
    xtrabackup-plugin-dir             (No default value)
    plugin-load                       (No default value)
    generate-new-master-key           FALSE
    generate-transition-key           FALSE
    keyring-file-data                 (No default value)
    component-keyring-file-config     (No default value)
    parallel                          1
    strict                            FALSE
    rocksdb-checkpoint-max-age        0
    rocksdb-checkpoint-max-count      0

[Link 1]: https://www.percona.com/doc/percona-xtrabackup/LATEST/xtrabackup_bin/xbk_option_reference.html#cmdoption-backup