MySQL Compressed Backup(七)
ta/mysql5.5/performance_schema/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (18 files)
131104 00:18:13 Starting rsync as: rsync -t "/data/mysql5.5" --files-from="/tmp/xtrabackup_rsyncfiles_pass1" "/backup/xtra_normal"
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
131104 00:18:22 rsync finished successfully.
131104 00:18:22 innobackupex: Finished a prep copy of non-InnoDB tables and files
131104 00:18:22 innobackupex: Starting to lock all tables...
131104 00:18:23 innobackupex: All tables locked and flushed to disk
131104 00:18:23 innobackupex: Starting to backup non-InnoDB tables and files
innobackupex: in subdirectories of '/data/mysql5.5'
innobackupex: Backing up file '/data/mysql5.5/zwc/t2.frm'
innobackupex: Backing up file '/data/mysql5.5/zwc/db.opt'
innobackupex: Backing up file '/data/mysql5.5/zwc/t1.MYI'
innobackupex: Backing up file '/data/mysql5.5/zwc/t1.MYD'
innobackupex: Backing up file '/data/mysql5.5/zwc/t1.frm'
innobackupex: Backing up files '/data/mysql5.5/common_schema/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (95 files)
innobackupex: Backing up files '/data/mysql5.5/mysql/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (78 files)
innobackupex: Backing up files '/data/mysql5.5/performance_schema/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (18 files)
131104 00:18:23 Starting rsync as: rsync -t "/data/mysql5.5" --files-from="/tmp/xtrabackup_rsyncfiles_pass2" "/backup/xtra_normal"
131104 00:18:23 rsync finished successfully.
131104 00:18:23 innobackupex: Finished backing up non-InnoDB tables and files
131104 00:18:23 innobackupex: Waiting for log copying to finish
>
> log scanned up to (3406079293)
xtrabackup: The latest check point (for incremental): '3406079293'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (3406079293)
xtrabackup: Creating suspend file '/backup/xtra_normal/xtrabackup_log_copied' with pid '4569'
xtrabackup: Transaction log of lsn (3406079293) to (3406079293) was copied.
131104 00:18:24 innobackupex: All tables unlocked
innobackupex: Backup created in directory '/backup/xtra_normal'
innobackupex: MySQL binlog position: filename 'ZWC-TEST.000015', position 20185
131104 00:18:24 innobackupex: Connection to database server closed
131104 00:18:24 innobackupex: completed OK!
real 0m29.516s
user 0m3.302s
sys 0m3.911s
[root@test backup]#
[root@test backup]#
[root@test backup]# du -sh /backup/xtra_normal
984M /backup/xtra_normal
compressed backup
[root@test backup]# time innobackupex --defaults-file=/service/mysql5.5/my.cnf --user=root --no-timestamp --password=idontcare --stream=tar ./ | gzip - > /backup/xtra_compressed.tar.gz
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
131104 00:22:29 innoba