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