mysql 利用xtrabackup进行增量备份详细过程汇总
xtrabackup下载、安装以及全量备份请参考：
mysql管理之使用xtrabackup进行热备
mysql开源备份工具xtrabackup备份部署
mysql xtrabackup备份和恢复
用xtrabackup实现mysql的主从复制快速部署【主不锁表】
安装和使用 percona 推出的 xtrabackup 备份 mysql
1，创建mysql备份用户
mysql -uroot --password= -ecreate user 'backup'@'192.168.%' identified by '123456';
mysql -uroot --password= -egrant reload, lock tables, replication client, create tablespace, superon *.* to 'backup'@'192.168.%';
2，xtrabackup进行全量备份
备份命令：
xtrabackup --defaults-file=/etc/my.cnf--user=backup --password=123456 --port=3306 --backup--target-dir=/data/backups/mysql/full_incre_$(date +%y%m%d)
ps: 2>/tmp/fullbackup.log 将备份信息放入文件中。
备份过程信息如下：
[root@data01 ~]# xtrabackup--defaults-file=/etc/my.cnf --user=backup --password=123456--port=3306 --backup --target-dir=/data/backups/mysql/full_incre_$(date+%y%m%d)
xtrabackup version 2.2.9 based on mysqlserver 5.6.22 linux (x86_64) (revision id: )
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /home/data/mysql/data
xtrabackup: open files limit requested 0,set to 1024
xtrabackup: using the following innodbconfiguration:
xtrabackup:  innodb_data_home_dir = ./
xtrabackup:  innodb_data_file_path =ibdata1:128m;ibdata2:128m:autoextend
xtrabackup:  innodb_log_group_home_dir = ./
xtrabackup:  innodb_log_files_in_group = 3
xtrabackup:  innodb_log_file_size = 67108864
>> log scanned up to (423920168)
xtrabackup: generating a list of tablespaces
[01] copying ./ibdata1 to/data/backups/mysql/full_incre_20150319/ibdata1
>> log scanned up to (423920168)
>> log scanned up to (423920168)
[01]      ...done
[01] copying ./ibdata2 to/data/backups/mysql/full_incre_20150319/ibdata2
>> log scanned up to (423920168)
>> log scanned up to (423920168)
[01]      ...done
[01] copying ./mysql/slave_master_info.ibdto /data/backups/mysql/full_incre_20150319/mysql/slave_master_info.ibd
[01]      ...done
[01] copying ./mysql/slave_relay_log_info.ibdto /data/backups/mysql/full_incre_20150319/mysql/slave_relay_log_info.ibd
[01]      ...done
[01] copying ./mysql/innodb_index_stats.ibdto /data/backups/mysql/full_incre_20150319/mysql/innodb_index_stats.ibd
[01]      ...done
[01] copying ./mysql/slave_worker_info.ibdto /data/backups/mysql/full_incre_20150319/mysql/slave_worker_info.ibd
[01]      ...done
[01] copying ./mysql/innodb_table_stats.ibdto /data/backups/mysql/full_incre_20150319/mysql/innodb_table_stats.ibd
[01]      ...done
[01] copying ./sbtest/sbtest1.ibd to/data/backups/mysql/full_incre_20150319/sbtest/sbtest1.ibd
[01]      ...done
[01] copying ./sbtest/sbtest5.ibd to/data/backups/mysql/full_incre_20150319/sbtest/sbtest5.ibd
[01]      ...done
[01] copying ./sbtest/sbtest8.ibd to/data/backups/mysql/full_incre_20150319/sbtest/sbtest8.ibd
[01]      ...done
[01] copying ./sbtest/sbtest4.ibd to/data/backups/mysql/full_incre_20150319/sbtest/sbtest4.ibd
[01]      ...done
[01] copying ./sbtest/sbtest2.ibd to/data/backups/mysql/full_incre_20150319/sbtest/sbtest2.ibd
[01]      ...done
[01] copying ./sbtest/sbtest6.ibd to/data/backups/mysql/full_incre_20150319/sbtest/sbtest6.ibd
[01]      ...done
[01] copying ./sbtest/sbtest7.ibd to /data/backups/mysql/full_incre_20150319/sbtest/sbtest7.ibd
[01]      ...done
[01] copying ./sbtest/sbtest3.ibd to/data/backups/mysql/full_incre_20150319/sbtest/sbtest3.ibd
[01]      ...done
[01] copying ./test/t1.ibd to/data/backups/mysql/full_incre_20150319/test/t1.ibd
[01]      ...done
[01] copying ./test/t3.ibd to/data/backups/mysql/full_incre_20150319/test/t3.ibd
[01]      ...done
[01] copying ./test/t.ibd to/data/backups/mysql/full_incre_20150319/test/t.ibd
[01]      ...done
[01] copying ./user_db/t1.ibd to/data/backups/mysql/full_incre_20150319/user_db/t1.ibd
[01]      ...done
[01] copying ./user_db/test.ibd to/data/backups/mysql/full_incre_20150319/user_db/test.ibd
[01]      ...done
[01] copying ./user_db/test2.ibd to/data/backups/mysql/full_incre_20150319/user_db/test2.ibd
[01]      ...done
[01] copying ./user_db/t3.ibd to/data/backups/mysql/full_incre_20150319/user_db/t3.ibd
[01]      ...done
[01] copying ./user_db/uc_user.ibd to/data/backups/mysql/full_incre_20150319/user_db/uc_user.ibd
>> log scanned up to (423920168)
[01]      ...done
[01] copying ./user_db/t.ibd to/data/backups/mysql/full_incre_20150319/user_db/t.ibd
[01]      ...done
xtrabackup: the latest check point (forincremental): '423920168'
xtrabackup: stopping log copying thread.
.>> log scanned up to (423920168)
xtrabackup: transaction log of lsn(423920168) to (423920168) was copied.
[root@data01 ~]#
3，xtrabackup进行增量备份
3.1先录入一张表，，实现第一次增量数据：