Backup command innobackupex --defaults-file=/etc/my.cnf --slave-info --safe-slave-backup --user=** --password=**** --stream=xbstream --parallel=2 /data/backup/ | ssh root@10.100.16.** "xbstream -x -C /data/mysql/" & Prepare:
innobackupex --apply-log --use-memory=50G /data/mysql &
backup-my.cnf
[mysqld] innodb_checksum_algorithm=innodb innodb_log_checksum_algorithm=strict_crc32 innodb_data_file_path=ibdata1:10M:autoextend innodb_log_files_in_group=2 innodb_log_file_size=2096103424 innodb_fast_checksum=false innodb_page_size=16384 innodb_log_block_size=512 innodb_undo_directory=./ innodb_undo_tablespaces=0 server_id=10250283
redo_log_version=1
no log file generated during the backup and prepare
Backup command file=/etc/ my.cnf --slave-info --safe-slave-backup --user=** --password=**** --stream=xbstream --parallel=2 /data/backup/ | ssh root@10.100.16.** "xbstream -x -C /data/mysql/" &
innobackupex --defaults-
Prepare:
innobackupex --apply-log --use-memory=50G /data/mysql &
backup-my.cnf
[mysqld] checksum_ algorithm= innodb log_checksum_ algorithm= strict_ crc32 data_file_ path=ibdata1: 10M:autoextend log_files_ in_group= 2 log_file_ size=2096103424 fast_checksum= false page_size= 16384 log_block_ size=512 undo_directory= ./ undo_tablespace s=0
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
server_id=10250283
redo_log_version=1
no log file generated during the backup and prepare