… 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 binary…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… stream incremental backups, lifting a limitation from previous versions where it was only possible to stream full backups. Parallel compression Percona XtraBackup… at once. tar4ibd functionality is replaced by functionality in the xtrabackup binary itself. The xbstream utility is added This utility has…
Comment: Announcing Percona XtraBackup 2.0.0 GA
April 25, 2012 By 11 Comments
… into the issue with xtrabackup_checkpoints.qp as well. The only way for me to run an incremental on top of a compressed full backup (or a compressed incremental) is to extract the xtrabackup_checkpoints file first… sitting there for 2 weeks. https://bugs.launchpad.net/percona-xtrabackup/+bug/977652 This combined with the inability to create streamed…
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
… copy changed pages you can do: xtrabackup –incremental_lsn=1319:813219999 –backup –target-dir=/data/backup/increment_day1 and only changed pages (ones…. More about incremental you can read on our draft page http://www.percona.com/docs/wiki/percona-xtrabackup:spec:incremental You can download…
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… the solutions? If you are using all InnoDB tables, an XtraBackup incremental backup should be much faster than using binary logs.Â…
Post: Percona XtraBackup 1.6
April 12, 2011 By 15 Comments
… Tkachenko) Added option –incremental-lsn to innobackupex. If specified, this option is passed directly to the xtrabackup script and –incremental-basedir is ignored. (Vadim Tkachenko) Added option –incremental-dir to innobackupex. This option is passed directly to the xtrabackup…
Post: Percona XtraBackup 1.4
November 22, 2010 By 10 Comments
Percona XtraBackup 1.4 is now available for download. Version 1.4 fixes problems related to incremental backups. If you do incremental backups… in “xtrabackup“. (Yasufumi Kinoshita) Miscellaneous important fixes related to incremental backups. Release Notes for this and previous releases of Percona Xtrabackup can be…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
…is the current stable release of Percona XtraBackup. In this release we now compile the xtrabackup binary against more recent MySQL and…InnoDB tables. Bug Fixed: #859546 (Lachlan Mulcahy) When the –incremental and –incremental-lsn options were specified together, innobackupexwould give an erroneous …
Post: Statistics of InnoDB tables and indexes available in xtrabackup
September 14, 2009 By 6 Comments
…_message_id` (`from_message_id`,`link_id`) ) ENGINE=InnoDB AUTO_INCREMENT=26141165 DEFAULT CHARSET=utf8; And size of file is about…:41 link_out104.ibd So to get statistics we run: xtrabackup –stats –tables=art.link* –datadir=/mnt/data/mysql/ which will… factor should be quite good. To check that, there is xtrabackup –stats for index domain_id created for table in Barracuda…
