[MySQL] CentOS 6.5下Percona Xtrabackup的安装及使用

[root@Web1 ~]# wget http://www.percona.com/redir/downloads/XtraBackup/LATEST/binary/redhat/6/x86_64/percona-xtrabackup-2.2.3-4982.el6.x86_64.rpm

[root@Web1 ~]# rpm -ivh percona-xtrabackup-2.2.3-4982.el6.x86_64.rpm
warning: percona-xtrabackup-2.2.3-4982.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
error: Failed dependencies:
    libaio.so.1()(64bit) is needed by percona-xtrabackup-2.2.3-4982.el6.x86_64
    libaio.so.1(LIBAIO_0.1)(64bit) is needed by percona-xtrabackup-2.2.3-4982.el6.x86_64
    libaio.so.1(LIBAIO_0.4)(64bit) is needed by percona-xtrabackup-2.2.3-4982.el6.x86_64
    perl(DBD::mysql) is needed by percona-xtrabackup-2.2.3-4982.el6.x86_64
    perl(Time::HiRes) is needed by percona-xtrabackup-2.2.3-4982.el6.x86_64
安装以下依赖包：
[root@Web1 ~]# yum -y install perl perl-devel libaio libaio-devel perl-Time-HiRes perl-DBD-MySQL

[root@Web1 ~]# innobackupex --user=root --password=123456 /data/backup
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.
Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p
140630 09:14:48  innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root'  (using password: YES).
140630 09:14:48  innobackupex: Connected to MySQL server
140630 09:14:48  innobackupex: Executing a version check against the server...
140630 09:14:48  innobackupex: Done.
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 10.0.10-MariaDB-log
Warning: Using unique option prefix open_files instead of open_files_limit is deprecated and will be removed in a future release. Please use the full name instead.
innobackupex: Created backup directory /data/backup/2014-06-30_09-14-48
140630 09:14:48  innobackupex: Starting ibbackup with command: xtrabackup  --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/data/backup/2014-06-30_09-14-48 --tmpdir=/tmp --extra-lsndir='/tmp'
innobackupex: Waiting for ibbackup (pid=3844) to suspend
innobackupex: Suspend file '/data/backup/2014-06-30_09-14-48/xtrabackup_suspended_2'
Warning: Using unique option prefix open_files instead of open_files_limit is deprecated and will be removed in a future release. Please use the full name instead.
xtrabackup version 2.2.3 based on MySQL server 5.6.17 Linux (x86_64) (revision id: )
xtrabackup: uses posix_fadvise().
xtrabackup: cd to
xtrabackup: open files limit requested 65535, set to 65535
xtrabackup: using the following InnoDB configuration:
xtrabackup:   innodb_data_home_dir = ./
xtrabackup:   innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup:   innodb_log_group_home_dir = ./
xtrabackup:   innodb_log_files_in_group = 2
xtrabackup:   innodb_log_file_size = 50331648
2014-06-30 09:14:48 7f0abfdd0720  InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: File ./ib_logfile0: 'open' returned OS error 71. Cannot continue operation
innobackupex: Error: The xtrabackup child process has died at /usr/bin/innobackupex line 2672.

basedir = /data/mysql
datadir = /data/mysql/data

[root@Web1 ~]# innobackupex --user=root --password=123456 /data/backup
innobackupex: Backup created in directory '/data/backup/2014-06-30_11-33-24'
innobackupex: MySQL binlog position: filename 'mysql-bin.000003', position 312
140630 09:51:59  innobackupex: Connection to database server closed
140630 09:51:59  innobackupex: completed OK!

[root@Web1 ~]# innobackupex --apply-log /data/backup/2014-06-30_11-33-24

[root@Web1 ~]# service mysqld stop
[root@Web1 ~]# mv /data/mysql/data /data/mysql/data_old
[root@Web1 ~]# mkdir -p /data/mysql/data
[root@Web1 ~]# innobackupex --copy-back /data/backup/2014-06-30_11-33-24
[root@Web1 ~]# chown -R mysql.mysql /data/mysql/data
[root@Web1 ~]# service mysqld start

[root@Web1 ~]# innobackupex --user=root --password=123456 --incremental /data/backup --incremental-basedir=/data/backup/2014-06-30_11-33-24

[root@Web1 ~]# innobackupex --apply-log --redo-only /data/backup/2014-06-30_11-33-24
[root@Web1 ~]# innobackupex --apply-log --redo-only /data/backup/2014-06-30_11-33-24 --incremental-dir=/data/backup/2014-06-30_13-06-25

innobackupex --apply-log --redo-only BACKUPDIR 
innobackupex --apply-log --redo-only BACKUPDIR --incremental-dir=INCREMENTDIR-1
innobackupex --apply-log --redo-only BACKUPDIR --incremental-dir=INCREMENTDIR-2

innobackupex --user=root --password=123456 --stream=tar  /data/backup | gzip > /data/backup/`date +%F_%H-%M-%S`.tar.gz