Not the answer you need?
Register and ask your own question!

Incremental streaming backups and restore

kevkev EntrantLegacy User Role Beginner
Hi,

I'm new to Percona and have just been getting my head around the features it has. My ultimate goal is to be able to stream incremental backups to a remote server and to restore/rebuild the database on the remote host.

So far I've got to the point of streaming the increments according to this guide (at the very end):
https://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/incremental_backups_innobackupex.html
#innobackupex --incremental --incremental-lsn=LSN-number --stream=xbstream ./ | ssh [email protected] " cat - | xbstream -x -C > /backup-dir/" My questions are:
1. How can I send the incremental backups without the need to refer to the LSN-number?
2. How can I rebuild the increments or rather prepare the backups on the remote host ?

Suggestions are most welcome!

Comments

  • scott.nemesscott.nemes MySQL Sage Current User Role Patron
    Hi kev;

    The "incremental-basedir" allows you to do the incremental without specifying the LSN. You give it the backup you want to build the incremental off of, and it figures out where to start from that.

    The guide you linked shows you how to prepare the incremental and base backups, however below is another guide if you want to give it a try to see if it makes more sense to you:

    https://www.percona.com/doc/percona-xtrabackup/2.2/howtos/recipes_ibkx_inc.html

    -Scott
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.