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 ( [url]http://www.pgbarman.org/[/url] ) 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 [url]Percona XtraBackup & [url]Percona XtraBackup

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.