---

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

 

 

**********************

命令格式

 

用法：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