XtraBackup recovery point objective (RPO)

  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    Point in time recovery is works with percona xtrabackup.
    For further reading check http://www.percona.com/doc/percona-x...overy_ibk.html & https://www.percona.com/doc/percona-...nary_logs.html


    • #3
      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.