Re: innobackupex MySQL Incremental backup with Tar base backup?

[Morgan Pyne]

I use the the "--extra-lsndir" parameter when streaming backups. This will write the lsn info additionally to a file outside the archive, which can be used for subsequent incremental backups. Granted, I'm using xbtream instead of tar, but I presume the same principle applies.

Morgan

On 24/07/2012, at 7:04 PM, Paranoid SysAdmin wrote:

Hi,

How does everyone perform incremental backups when streaming to tar files?  The full backup's xtrabackup_checkpoints file is included in the tar archive so how can I get innobackupex to see it when performing an incremental backup?

I tried generating my own xtrabackup_checkpoints file using this (output from stderr during full backup):

xtrabackup: Streaming transaction log from a temporary file...

xtrabackup: Done.

xtrabackup: Transaction log of lsn (1096298065) to (1096298065) was copied.

So I made a script to generate an xtrabackup_checkpoints file using this 1096298065 as the to_lsn.

And this appeared to work, I could run incremental backups off it and they would have the from_lsn: 1096298065.

Then I tried performing a restore and found the following error:

xtrabackup_55 version 2.0.1 for MySQL server 5.5.17 Linux (x86_64) (revision id: undefined)

incremental backup from 1096298065 is enabled.

xtrabackup: cd to /root/New/20120723_test/

xtrabackup: This target seems to be already prepared.

xtrabackup: error: This incremental backup seems not to be proper for the target.

xtrabackup:  Check 'to_lsn' of the target and 'from_lsn' of the incremental.

It turns out, the xtrabackup_checkpoints file included in the tar archive has to_lsn = 1399401679.

Where does innobackupex pull this from??  It does not appear anywhere other than being included in the tar archive.

How does everyone else run incremental backups when streaming all backups to tar?

Cheers

--
You received this message because you are subscribed to the Google Groups "Percona Discussion" group.
To view this discussion on the web visit https://groups.google.com/d/msg/percona-discussion/-/1JIf0Gco2acJ.
To post to this group, send email to percona-d...@googlegroups.com.
To unsubscribe from this group, send email to percona-discuss...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/percona-discussion?hl=en.