功能
原理描述
备份步骤描述
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