mysql xtrabackup 增量复制

---

mysql xtrabackup 增量复制

 

官方文档：https://www.percona.com/doc/percona-xtrabackup/LATEST/backup_scenarios/incremental_backup.html

 

 

***********************

增量复制

 

xtrabackup支持增量复制：只复制自上次备份后发生变化的数据

xtrabackup supports incremental backups, which means that they 
can copy only the data that has changed since the last backup

You can perform many incremental backups between each full backup, 
so you can set up a backup process such as 
a full backup once a week and an incremental backup every day, 
or full backups every day and incremental backups every hour
# 每周进行一次全量复制，并且每天进行一次增量复制
# 或者每天进行一次全量复制，每小时进行一次增量复制

 

增量复制原理

# InnoDB数据页有一个LSN，增量复制复制当前LSN比上次全量复制或者增量复制LSN大的数据页
An incremental backup copies each page whose LSN is newer than the previous incremental or 
full backup’s LSN. 

# 有两种算法查找需要复制的数据页
There are two algorithms in use to find the set of such pages to be copied. 

# 第一种：扫描所有的数据页
The first one, available with all the server types and versions,