Incremental database backup challenge. Any resolution please?

  • Filter
  • Time
  • Show
Clear All
new posts

  • Incremental database backup challenge. Any resolution please?

    Restoring incremental backup always come with a nightmare of having to restore sequence of snapshots taking from when the full backup was done and the subsequent incremental snapshots. These is a bit cumbersome and sometime the purpose would not be achieve. Please is there a way to mitigate this headache?

    ​And is there any hope of having differential backup for Percona server?

  • #2
    Hi sbuhari,

    Percona XtraBackup supports both incremental and differential backups, as does MySQL Enterprise Backup.

    Vadim Tkachenko and Alexey Kopytov presented on this a couple of years ago at the Percona Live MySQL Conference and Expo - and the slides are still available and might help. You can access those here: http://www.percona.com/live/mysql-conference-2012/sessions/percona-xtrabackup-install-usage-tricks

    And there is a white paper published last autumn titled "MySQL Backup and Recovery Best Practices" that might also help: Click Here
    Is this an emergency? Get immediate assistance from Percona Support 24/7. .