XtraBackup recovery point objective (RPO)

Hi all,

I manage a lot of PostgreSQL and MySQL (Percona) servers on behalf of my customers.
For PostgreSQL servers, I use Barman ( http://www.pgbarman.org/ ) to achieve a recovery point objective (RPO) of 5 minutes. So in case of “big problems”, I’m sure to never lose more than 5 minutes of data.

Is it possible to achieve a RPO of 5 minutes with XtraBackup ? Currently I launch XtraBackup in incremental mode twice a day at midnight and midday, except on Sunday midday when I make a full backup.

Thank you for your help :slight_smile:

Point in time recovery is works with percona xtrabackup.
For further reading check http://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/pit_recovery_ibk.html & https://www.percona.com/doc/percona-xtrabackup/2.1/xtrabackup_bin/working_with_binary_logs.html

Hi mirfan,

I’m not talking about point-in-time recovery (PITR) but recovery point objective (RPO).
I need to ensure to never lose more than 5 minutes of data in case of server failure.