Comment 4 for bug 1645774

Revision history for this message
James chen (baoxiao) wrote :

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