I am using innobackupex to run nightly full backups of a mysqld database
with great success. These are being streamed as tar, piped through gzip
and redirected to backup.tar.gz.
Now I would like to add incremental backups to this base backup. The
problem is, I need to be able to access the to_lsn value.
Is there any easy way to do this??
The only lsn I can find in stderr is xtrabackup:
Transaction log of lsn (1096298065) to (1096298065) was copied.
I wrote a script which grabbed this and generated an
'xtrabackup_checkpoints' file using this (1096298065) as the to_lsn.
The problem is, if I extract the xtrabackup_checkpoints file from the tar
archive, it has the to_lsn of: 1399401679
Where does innobackupex pull this from? I can't find it in the output
Surely I'm not the only one who wants to stream to tar and also run
incremental backups, am I? How does everyone else do it?