… way for me to run an incremental on top of a compressed full backup (or a compressed incremental) is to extract the xtrabackup…/977652 This combined with the inability to create streamed tar backups has made 2.0.0 a fairly painful experience for…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… uncompress the entire backup to restore a single table). Percona XtraBackup now supports streaming incremental backups. In previous versions streaming backups were performed by the innobackupex script but incremental backups were done by the xtrabackup…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… incremental backups. It is now possible to stream incremental backups, lifting a limitation from previous versions where it was only possible to stream full backups… XtraBackup can now use multiple CPUs to perform a compressed backup, significantly reducing the amount of time needed. Parallel compression (‘–compress…
Comment: Announcing Percona XtraBackup 2.0.0 GA
April 9, 2012 By 11 Comments
Yes, you can do incremental backups on topo f a base backup that is compressed.
Comment: Announcing Percona XtraBackup 2.0.0 GA
April 8, 2012 By 11 Comments
Can you do incremental backups once the base backup has been compressed with –compress? AD
Comment: Announcing Percona XtraBackup 2.0.0 GA
April 9, 2012 By 11 Comments
@Stewart Smith Hmm.. I got an error when trying to run an incremental after a compressed base backup. The error was that it was not able to find the xtrabackup_checkpoints file. The base dir had the xtrabackup_checkpoints.qp instead.. AD
Post: xtrabackup-0.5, bugfixes, incremental backup introduction
April 7, 2009 By 6 Comments
… our backup tool. This version contains several bugfixes and introduces initial implementation of incremental backup. Incremental backup works in next way. When you do regular backup… tar stream. which gives start point 1319:813219999 for further incremental backup. This point is LSN of last checkpoint operations. Now next…
Post: Thoughs on Innodb Incremental Backups
November 10, 2008 By 8 Comments
… normal Innodb “hot” backups we use LVM or other snapshot based technologies with pretty good success. However having incremental backups remain the problem. First why do you need incremental backups at all ? Why not just take the full backups daily. The…
Post: Just how useful are binary logs for incremental backups?
July 21, 2009 By 6 Comments
… that it also limits the effectiveness of using it for incremental backup. Let me make up some numbers for the purposes… hours, the offpeak window is 12 hours. Provided that the backup method was raw data files, it shouldn’t take much… solutions? If you are using all InnoDB tables, an XtraBackup incremental backup should be much faster than using binary logs. You…
Post: What Are Full, Incremental, and Differential Backups?
January 23, 2012 By 2 Comments
… backup process can be significantly more efficient. An incremental backup is a modification of a differential backup. An incremental backup records the changes since the last backup of any type, be it a differential or full backup. The advantages of incremental backups…
