xtrabackup-0.5, bugfixes, incremental backup introduction

April 8, 2009

Author

Vadim Tkachenko

Percona Software

Share this Post:

I am happy to announce next build of 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, at the end of procedure you can see output:

<br>The latest check point (for incremental): '1319:813219999'<br>>> log scanned up to (1319 813701532)<br>Transaction log of lsn (1318 3034677302) to (1319 813701532) was copied.<br>090404 06:03:29  innobackupex: All tables unlocked<br>090404 06:03:29  innobackupex: Connection to database server closed<br><br>innobackupex: Backup created in directory '/mnt/data/tmp'<br>innobackupex: MySQL binlog position: filename 'db02-bin.001271', position 247627478<br>090404 06:07:58  innobackupex: innobackup completed OK!<br>innobackupex: You must use -i (--ignore-zeros) option for extraction of the tar stream.<br>

1

The latest check point (for incremental): '1319:813219999' >> log scanned up to (1319 813701532) Transaction log of lsn (1318 3034677302) to (1319 813701532) was copied. 090404 06:03:29 innobackupex: All tables unlocked 090404 06:03:29 innobackupex: Connection to database server closed innobackupex: Backup created in directory '/mnt/data/tmp' innobackupex: MySQL binlog position: filename 'db02-bin.001271', position 247627478 090404 06:07:58 innobackupex: innobackup completed OK! innobackupex: You must use -i (--ignore-zeros) option for extraction of the tar stream.

which gives start point 1319:813219999 for further incremental backup. This point is LSN of last checkpoint operations. Now next time when you want only copy changed pages you can do:

<br>xtrabackup --incremental_lsn=1319:813219999 --backup --target-dir=/data/backup/increment_day1<br>

1	<br>xtrabackup --incremental_lsn=1319:813219999 --backup --target-dir=/data/backup/increment_day1<br>

and only changed pages (ones with LSN greater than given) will be copied to specified dir. You may have several incremental dir, and apply them one-by-one.

Current version does not allow to copy incremental changes to remote box or to stream, it is only local copy for now, but we are going to change it in next release. Beside putting last checkpoint LSN to output we also store it in xtrabackup_checkpoint file to use it in scripts.
More about incremental you can read on our draft page https://www.percona.com/docs/wiki/percona-xtrabackup:spec:incremental

You can download current binaries RPM for RHEL4 and RHEL5 (compatible with CentOS also), DEB for Debian/Ubuntu and tar.gz for Mac OS / Intel 64bit there:
https://www.percona.com/mysql/xtrabackup/0.5/.
By the same link you can find general .tar.gz with binaries which can be run on any modern Linux distribution.
By the same link you can download source code if you do not want to deal with bazaar and Launchpad.

The project lives on Launchpad : https://launchpad.net/percona-xtrabackup and you can report bug to Launchpad bug system:
https://launchpad.net/percona-xtrabackup/+filebug. The documentation is available on our Wiki

For general questions use our Pecona-discussions group, and for development question Percona-dev group.

For support, commercial and sponsorship inquiries contact Percona