MySQL Compressed Backup(一)

2014-11-24 17:02:57 · 作者: · 浏览: 8
MySQL Compressed Backup
[root@test zwc]# ls -lh  
total 953M  
-rw-rw---- 1 mysql mysql   61 Nov  3 22:03 db.opt  
-rw-rw---- 1 mysql mysql 8.5K Nov  3 22:10 t1.frm  
-rw-rw---- 1 mysql mysql 191M Nov  3 22:25 t1.MYD  
-rw-rw---- 1 mysql mysql 295M Nov  3 22:42 t1.MYI  
-rw-rw---- 1 mysql mysql 8.4K Nov  3 22:11 t2.frm  
-rw-rw---- 1 mysql mysql 468M Nov  3 22:40 t2.ibd  
Using MEB
normal backup
[root@test backup]# time /service/mysql5.5/bin/mysqlbackup --user=root --backup-dir=/backup/meb_normal backup-and-apply-log --socket=/data/mysql5.5/mysql.sock --password  
MySQL Enterprise Backup version 3.8.2 [2013/06/18]   
Copyright (c) 2003, 2012, Oracle and/or its affiliates. All Rights Reserved.  
 mysqlbackup: INFO: Starting with following command line ...  
/service/mysql5.5/bin/mysqlbackup --user=root   
        --backup-dir=/backup/meb_normal backup-and-apply-log   
        --socket=/data/mysql5.5/mysql.sock --password   

Enter password:
mysqlbackup: INFO: MySQL server version is '5.5.25-log'.
mysqlbackup: INFO: Got some server configuration information from running server.
IMPORTANT: Please check that mysqlbackup run completes successfully.
At the end of a successful 'backup-and-apply-log' run mysqlbackup
prints "mysqlbackup completed OK!".
--------------------------------------------------------------------  
                       Server Repository Options:  
--------------------------------------------------------------------  
  datadir = /data/mysql5.5/  
  innodb_data_home_dir =   
  innodb_data_file_path = ibdata1:10M:autoextend  
  innodb_log_group_home_dir = /data/mysql5.5/  
  innodb_log_files_in_group = 3  
  innodb_log_file_size = 536870912  
  innodb_page_size = Null  
  innodb_checksum_algorithm = innodb  
--------------------------------------------------------------------  
                       Backup Config Options:  
--------------------------------------------------------------------  
  datadir = /backup/meb_normal/datadir  
  innodb_data_home_dir = /backup/meb_normal/datadir  
  innodb_data_file_path = ibdata1:10M:autoextend  
  innodb_log_group_home_dir = /backup/meb_normal/datadir  
  innodb_log_files_in_group = 3  
  innodb_log_file_size = 536870912  
  innodb_page_size = 16384  
  innodb_checksum_algorithm = innodb  

mysqlbackup: INFO: Unique generated backup id for this is 13834928576619365  
 mysqlbackup: INFO: Uses posix_fadvise() for performance optimization.  
mysqlbackup: INFO: Creating 14 buffers each of size 16777216.  
131103 23:34:19 mysqlbackup: INFO: Full Backup operation starts with following threads  
                1 read-threads    6 process-threads    1 write-threads  
131103 23:34:19 mysqlbackup: INFO: System tablespace file format is Antelope.  
131103 23:34:19 mysqlbackup: INFO: Starting to copy all innodb files...  
131103 23:34:19 mysqlbackup: INFO: Copying /data/mysql5.5/ibdata1 (Antelope file format).  
131103 23:34:19 mysqlbackup: INFO: Found checkpoint at lsn 3406071002.  
131103 23:34:19 mysqlbackup: INFO: Starting log scan from lsn 3406070784.  
131103 23:34:19 mysqlbackup: INFO: Copying log...  
131103 23:34:19 mysqlbackup: INFO: Log copied, lsn 3406071002.  
131103 23:34:19 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_global_qs_variables.ibd (Antelope file format).  
131103 23:34:19 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_global_script_report