MySQL Compressed Backup - 数据库编程

on-innodb files. 131103 23:38:16 mysqlbackup: INFO: A copied database page was modified at 3406075519. (This is the highest lsn found on page) Scanned log up to lsn 3406078687. Was able to parse the log up to lsn 3406078687. Maximum page number for a log record 316 131103 23:38:16 mysqlbackup: INFO: All tables unlocked 131103 23:38:16 mysqlbackup: INFO: All MySQL tables were locked for 13.426 seconds. 131103 23:38:16 mysqlbackup: INFO: Compressed 496 MB of data files to 200573 kbytes (compression 60.51%). 131103 23:38:16 mysqlbackup: INFO: Compress Backup operation completed successfully. 131103 23:38:16 mysqlbackup: INFO: Backup created in directory '/backup/meb_compressed' 131103 23:38:16 mysqlbackup: INFO: MySQL binlog position: filename ZWC-TEST.000015, position 16895

-------------------------------------------------------------  
   Parameters Summary           
-------------------------------------------------------------  
   Start LSN                  : 3406075392  
   End LSN                    : 3406078687  
-------------------------------------------------------------  
mysqlbackup completed OK!  
real    0m29.922s  
user    0m9.333s  
sys     0m1.924s  
[root@test backup]#   
[root@test backup]#   
[root@test backup]# du -sh /backup/meb_compressed  
684M    /backup/meb_compressed  
[root@test zwc]# ll -h /backup/meb_compressed/datadir/zwc  
total 680M  
-rw-r--r-- 1 root root   61 Nov  3 23:38 db.opt  
-rw-r--r-- 1 root root 8.5K Nov  3 23:38 t1.frm  
-rw-r--r-- 1 root root 191M Nov  3 23:38 t1.MYD  
-rw-r--r-- 1 root root 295M Nov  3 23:38 t1.MYI  
-rw-r--r-- 1 root root 8.4K Nov  3 23:38 t2.frm  
-rw-r--r-- 1 root root 195M Nov  3 23:38 t2.ibz  
Innodb Tablespace compressed independently .ibz suffix, MyISAM uncompressed!
Using XtraBackup
normal backup
[root@test backup]# time innobackupex --defaults-file=/service/mysql5.5/my.cnf  --rsync --user=root --no-timestamp --password=root /backup/xtra_normal  
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:17:55  innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/service/mysql5.5/my.cnf;mysql_read_default_group=xtrabackup' as 'root'  (using password: YES).  
131104 00:17:55  innobackupex: Connected to MySQL server  
IMPORTANT: Please check that the backup run completes successfully.  
           At the end of a successful backup run innobackupex  
           prints "completed OK!".  
innobackupex: Using mysql server version 5.5.25-log  
innobackupex: Created backup directory /backup/xtra_normal  
131104 00:17:55  innobackupex: Starting ibbackup with command: xtrabackup_55  --defaults-file="/service/mysql5.5/my.cnf"  --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/backup/xtra_normal --tmpdir=/tmp  
innobackupex: Waiting for ibbackup (pid=4569) to suspend  
innobackupex: Suspend file '/backup/xtra_normal/xtrabackup_suspended_2'  
xtrabackup_55 version 2.1.5 for Percona Server 5.5.31 




Linux (x86_64) (revision id: 680)  
xtrabackup: uses posix_fadvise().  
xtrabackup: cd to /data/mysql5.5  
xtrabackup: using the following InnoDB configuration:  
xtrabackup:   innodb_data_home_dir = ./  
xtrabackup:   innodb_data_file_path = ibdata1:10M:autoextend  
xtrabackup:   innodb_log_group_home_d

MySQL Compressed Backup(五)