功能

原理描述

备份步骤描述
1.xtrabackup first copies InnoDB data, runs the LOCK TABLES FOR BACKUP and then copies the MyISAM tables. Once this is done, the backup of the files will begin. It will backup .frm, .MRG, .MYD, .MYI, .ARM, .ARZ, .CSM, .CSV, .sdi and .par files.
2.After that xtrabackup will use LOCK BINLOG FOR BACKUP to block all operations that might change either binary log position or Exec_Master_Log_Pos or Exec_Gtid_Set 
3.InnoDB‘s data is rolled forward to the point at which the backup completed, not rolled back to the point at which it started. This point in time matches where the FLUSH TABLES WITH READ LOCK was taken

增量备份原理

 

恢复的步骤

 
 
 
增量恢复


 
指定时间点恢复

连接及需要的权限


原文:https://www.cnblogs.com/duanzexun/p/13032371.html