xtrabackup-2.1.2-611安装(六)
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.
--safe-slave-backup-timeout
How many seconds --safe-slave-backup should wait for
Slave_open_temp_tables to become zero. (default 300)
--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.
--socket=SOCKET
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. It is passed to the mysql child process without
alteration. See mysql --help for details.
--stream=STREAMNAME
This option specifies the format in which to do the streamed backup.
The option accepts a string argument. The backup will be done to
STDOUT in the specified format. Currently, the only supported
formats are tar and xbstream. This option is passed directly to
xtrabackup's --stream option.
--tables-file=FILE
This option specifies the file in which there are a list of names of
the form database. The option accepts a string argument.table, one
per line. The option is passed directly to xtrabackup's
--tables-file option.
--throttle=
IOS
This option specifies a number of I/O operations (pairs of
read+write) per second. It accepts an integer argument. It is passed
directly to xtrabackup's --throttle option.
--tmpdir=DIRECTORY
This option specifies the location where a temporary file will be
stored. The option accepts a string argument. It should be used when
--stream is specified. For these options, the transaction log will
first be stored to a temporary file, before streaming. This option
specifies the location where that temporary file will be stored. If
the option is not specified, the default is to use the value of
tmpdir read from the server configuration.
--use-memory=B
This option accepts a string argument that specifies the amount of
memory in bytes for xtrabackup to use for crash recovery while
preparing a backup. Multiples are supported providing the unit (e.g.
1MB, 1GB). It is used only with the option --apply-log. It is passed
directly to xtrabackup's --use-memory option. See the xtrabackup
documentation for details.
--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. It is passed to the
mysql child process without
alteration. See mysql --help for details.
--defaults-group=GROUP-NAME
This option specifies the group name in my.cnf which should be used.