Common parameters of Xtrabackup

Basic command:

--defaults-file: Indicates the server's configuration file, this parameter must be the first parameter of the Innobackupex, otherwise the error

--host: Indicates the host

--user: Indicates the user name of the backup

--password: Indicates the password for the backup user name

--backup: indicated as a backup, this parameter can be ignored

/tmp/backup: The directory to be backed up

--backup: Indicates a backup

--apply-log: Indicate redo log

--copy-back: Indicates the recovery

--slave-info: Back up the show slave status information from the library, used only when backing up from the library

--no-lock: Does not lock the table, only applies to the storage engine is InnoDB, and does not care about the backup location point when using

Incremental backup:

--incremental: Indicates an incremental backup

--incremental-basedir: Indicates that this incremental backup is based on which previous backup, incremental backup only for InnoDB and XTRADB engines

--redo-only: Redo log again for incremental backup during recovery

--incremental-dir: When restoring an incremental backup, indicate the directory for the incremental backup

Partial backup:

--include: Use regular expressions to back up the matches to, for example: Back up the user table in the MySQL library, --include= ' ^mysql[. User '

--table-files: If you are backing up more than one table, you can write multiple tables to a file in the form "database name. Table name" and specify this file when backing up

--databases: You can back up the entire library, or you can back up a table in the library by backing up the table with the "Library name. Table Name" method

--export: This option is used when recovering with partial backups, which differs from full and incremental backups

Advanced command:

Xtrabackup waits for a global lock when performing a backup, and for long-executed statements, it raises the issue of lock contention!

--lock-wait-timeout: Indicates the wait time before flush tables with read lock, 0 means not waiting for the direct execution of the lock Table command, the unit is S, if there is a long time to execute the query beyond the time set by this parameter, The xtrabackup terminates the operation

--lock-wait-query-type: Can be all and update, and if set to all, indicates waiting for all types of statements to execute before executing flush tables with read lock; If you set update, you wait for the SQL statement to complete except Select, and then perform a lock table operation

--kill-long-queries-timeout: Number of seconds to wait after executing flush tables with read lock

--kill-long-query-type: Can be all and select; If all, indicates the number of seconds to wait, forcing all queries to be terminated, or select to force termination of a query of select type

This article is from the "burning Years of Passion" blog, please be sure to keep this source http://liuzhengwei521.blog.51cto.com/4855442/1882510

Common parameters of Xtrabackup