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):
#innobackupex --incremental --incremental-lsn=LSN-number --stream=xbstream ./ | ssh user@hostname " cat - | xbstream -x -C > /backup-dir/" My questions are:
- How can I send the incremental backups without the need to refer to the LSN-number?
- How can I rebuild the increments or rather prepare the backups on the remote host ?
Suggestions are most welcome!