Making Incremental on a prepared base full backup and making differential backups

3 views
Skip to first unread message

Johann Tagle

unread,
Dec 20, 2019, 10:08:05 PM12/20/19
to Percona Discussion
Hi all.  Quick questions: 

1.  If you have already performed `xtrabackup --prepare --apply-log-only` on a full backup, can you still use it as a base for new incremental backups?  
2.  If you keep using the same base full backup directory for --incremental-basedir when taking multiple incremental backups, you are effectively creating differential backups, right?  So restore should only involve the base full backup and the latest incremental/differential backup? 

My objective here is to have the quickest restore time possible by preparing the backups.  So, I'm studying if I can prepare the full backup and either apply the incremental daily or have the differential ready for application.

Thanks!

Johann
Reply all
Reply to author
Forward
0 new messages