##################################################################################
######
###### , ,
###### :innobackupex --user=root --password=banma --defaults-file=/etc/my.cnf --database=testinnodb /tmp/data/
###### 2 innobackupex --user=root --password=banma --apply-log /tmp/data/2013-08-23_16-09-10/
[root@localhost 2013-08-23_16-09-10]# rsync -avz testinnodb ib* /usr/local/mysql_data/data/
chown -R mysql:mysql /usr/local/mysql_data/data/
######
######
######
######
##################################################################################
、
1.
wget http://www.percona.com/redir/downloads/XtraBackup/XtraBackup-1.6.7/binary/Linux/x86_64/xtrabackup-1.6.7.tar.gz
2.
yum install cmake gcc gcc-c++ libaio libaio-devel automake autoconf bzr bison libtool ncurses-devel zlib-devel
3、
tar zxvf xtrabackup-1.6.7.tar.gz
4、
cd xtrabackup-1.6.7
5、
cd bin
cp * /usr/bin
,
:
innobackupex ;
xtrabackup innobackupex ,innobackupex ;
xtrabackup_51 xtrabackup ;
tar4ibd tar 。
、
6、
innobackupex --user=root --password=123456 --defaults-file=/etc/mysql/my.cnf --database=test --stream=tar /tmp/data/ 2>/tmp/data/info.log|gzip 1>/tmp/data/test.tar.gz
:
--database=test test ,
2>/tmp/data/info.log
1>/tmp/data/test.tar.gz
(
mysql> create table test (id int);
Query OK, 0 rows affected (0.06 sec)
mysql> insert into test values(1);
Query OK, 1 row affected (0.04 sec)
)
7、
(1)
mkdir /tmp/restore
cd /tmp/data
tar -izxvf test.tar.gz -C /tmp/restore
[root@localhost data]# ll /tmp/restore/
131096
-rw-r--r-- 1 root root 263 8 23 14:38 backup-my.cnf
-rw-rw---- 1 mysql mysql 134217728 8 23 14:22 ibdata1
drwxr-xr-x 2 root root 4096 8 23 14:53 test
-rw-r--r-- 1 root root 13 8 23 14:38 xtrabackup_binary
-rw-r--r-- 1 root root 21 8 23 14:38 xtrabackup_binlog_info
-rw-r--r-- 1 root root 73 8 23 14:38 xtrabackup_checkpoints
-rw-r--r-- 1 root root 2560 8 23 14:38 xtrabackup_logfile
(2) ( , ,
--apply-log , )
[root@localhost restore]# innobackupex --user=root --password=banma --apply-log /tmp/restore/
[root@localhost restore]# ll
526356
-rw-r--r-- 1 root root 263 8 23 14:38 backup-my.cnf
-rw-rw---- 1 mysql mysql 134217728 8 23 14:59 ibdata1
-rw-r--r-- 1 root root 134217728 8 23 14:59 ib_logfile0
-rw-r--r-- 1 root root 134217728 8 23 14:59 ib_logfile1
-rw-r--r-- 1 root root 134217728 8 23 14:59 ib_logfile2
drwxr-xr-x 2 root root 4096 8 23 14:53 test
-rw-r--r-- 1 root root 13 8 23 14:38 xtrabackup_binary
-rw-r--r-- 1 root root 21 8 23 14:38 xtrabackup_binlog_info
-rw-r--r-- 1 root root 73 8 23 14:59 xtrabackup_checkpoints
-rw-r--r-- 1 root root 2097152 8 23 14:59 xtrabackup_logfile
(3)
test /usr/local/mysql_data/data
[root@localhost restore]# rsync -avz test ib* /usr/local/mysql_data/data
sending incremental file list
ib_logfile0
ib_logfile1
ib_logfile2
ibdata1
test/
test/test.MYD
test/test.MYI
test/test.frm
sent 529692 bytes received 149 bytes 13762.10 bytes/sec
total size is 536880534 speedup is 1013.29
[root@localhost restore]#chown -R mysql:mysql /usr/local/mysql_data/data
、
(1)
insert into test values(10);
insert into test values(11);
insert into test values(12);
insert into test values(13);
insert into test values(14);
insert into test values(15);
(2)
[root@localhost data]# innobackupex --user=root --password=banma --database=test --incremental --incremental-basedir=/tmp/restore/ /tmp/data
,--incremental ,--incremental-basedir 。
InnoDB, MyISAM , 。
, , test
(3)
[root@localhost data]# innobackupex -user=root --password=banma --defaults-file=/etc/my.cnf --apply-log /tmp/restore/ --incremental-dir=/tmp/data/2013-08-23_15-22-54/
/tmp/data
[root@localhost 2013-08-23_15-22-54]# ll
172
-rw-r--r-- 1 root root 263 8 23 15:22 backup-my.cnf
-rw-r--r-- 1 root root 147456 8 23 15:22 ibdata1.delta
-rw-r--r-- 1 root root 18 8 23 15:22 ibdata1.meta
drwxr-xr-x 2 root root 4096 8 23 15:23 test
-rw-r--r-- 1 root root 13 8 23 15:23 xtrabackup_binary
-rw-r--r-- 1 root root 21 8 23 15:23 xtrabackup_binlog_info
-rw-r--r-- 1 root root 75 8 23 15:23 xtrabackup_checkpoints
-rw-r--r-- 1 root root 2560 8 23 15:23 xtrabackup_logfile
[root@localhost 2013-08-23_15-22-54]# rsync -avz test ib* /usr/local/mysql_data/data/