Xtrabackup parameters that need attention during Hot Backup

Common Xtrabackup parameters during Hot Backup are as follows: -- defaults-file = # default configuration file path. If the parameter is not set, xtrabackup searches for the configuration file/etc/my. cnf,/etc/mysql/my. cnf,/usr/local/etc/my. cnf ,~ /. My. cnf and read the [mysqld] and [xtrabackup] configuration segments in the configuration file. In [mysqld], you only need to specify datadir, innodb_data_home_dir, innodb_data_file_path, innodb_log_group_home_dir, innodb_log_files_in_group, and other parameters to make xtrabackup work normally. -- Defaults-extra-file = # If this parameter is used, after reading the global configuration file, will read the specified configuration file -- target-dir = name backup file storage directory path -- backup implementation backup to target-dir -- prepare implementation of backup file preparation before recovery (generate InnoDB log file) -- print-param: The parameter required for backup or recovery -- use-memory = # this parameter is used in prepare, control the amount of memory used by the innodb instance during prepare-suspend-at-end generates an xtrabackup_suincluded file in the target-dir directory and suspends the xtrabackup process, the changes in data files are constantly synchronized to the backup files until you manually delete the xtrabackup_suincluded file -- throttle = # IO times per second, limiting the number of times of backup I/O operations used to minimize the impact of backup on the normal business of the database -- log-stream is used in backup, and the xtrabackup_logfile content is output to the standard output, when this parameter is used, the suspend-at-end parameter is automatically used. This parameter is used in stream mode of innobackupex script. -- Incremental-lsn = name When performing incremental backup, only copy the ibd pages with the new value specified by this parameter, the LSN of the previous backup can be used to check the xtrabackup_checkpoints file of the previous backup set -- incremental-basedir = name. this parameter is used during backup, backup is the new idb pages -- incremental-dir = name in the backup set specified by this parameter. this parameter is used in prepare and is generated when prepare is specified. storage path of delta files and log files -- tables = name is used when backing up file-per-table data files, use the regular expression to specify the innodb table to be backed up -- datadir = name the data file directory of the MySQL database.