Shulou(Shulou.com)06/01 Report--

-- defaults-file

Same as xtrabackup-- defaults-file parameter

-- apply-log

Encapsulation of xtrabackup-- prepare parameters

-- copy-back

Copy the backup data files to the datadir of the MySQL server during data recovery

-- remote-host=HOSTNAME

Store backup data on the process server through ssh

-- stream= [tar]

Backup file output format, tar using tar4ibd, the file can be obtained in the XtarBackup binary file. If you back up

When-- stream=tar is specified, the directory where the tar4ibd file is located must be in $PATH (because tar4ibd decompression is used

Indent, which is available in the binary package of XtraBackup).

When using the parameter stream=tar backup, your xtrabackup_logfile may be temporarily placed in the / tmp directory

If you write too much when backing up, the xtrabackup_logfile may be very large (5G +) and will probably fill you up.

The / tmp directory of, you can solve this problem by specifying the directory with the parameter-- tmpdir.

-- tmpdir=DIRECTORY

When-- remote-host or-- stream is specified, the directory where the transaction log is temporarily stored is MySQL configuration file by default.

The temporary directory tmpdir specified in the

-redo-only-apply-log group

Force only redo to be backed up when backing up the log, skipping rollback. This is necessary when doing incremental backups.

-- use-memory=#

This parameter is used in prepare to control the amount of memory used by innodb instances in prepare.

-- throttle=IOS

Same as xtrabackup-- throttle parameter

-- sleep= is used by ibbackup to specify how many milliseconds the process stops copying for every 1m of data backed up.

Minimize the impact on normal business when backing up

-- compress [= LEVEL]

Compression of backup data rows, which only supports ibbackup,xtrabackup, has not been implemented yet

-- include=REGEXP

The encapsulation of the xtrabackup parameter, tables, also supports ibbackup. Backup the included library tables, for example:-- include= "test.*"

It means to back up all the tables in the test library. Omit this parameter if you need a full backup; if you need to back up the test library

The two tables under: test1 and test2 are written as:-- include= "test.test1 | test.test2". You can also use wildcards

Such as:-- include= "test.test*".

-- databases=LIST

List the databases that needs to be backed up. If this parameter is not specified, all database containing MyISAM and InnoDB tables will be backed up

-- uncompress

Decompress the backup data file and support ibbackup,xtrabackup. This function has not been implemented yet.

-- slave-info

Backup from the library, plus-- slave-info backup directory will generate an extra xtrabackup_slave_info file, which will be guaranteed here

Save the master log file and the offset location, the file content is similar to: CHANGE MASTER TO MASTER_LOG_FILE=''

MASTER_LOG_POS=0

-- socket=SOCKET

Specify the location of the mysql.sock so that the backup process logs in to mysql

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.