3

We're evaluating two tools incremental backup: MySQL Enterprise Backup and Percona XtraBackup. The only comparison I found is by Percona which has obvious cause for bias From this comparison, Percona XtraBackup is better suited for incremental backups as it is faster and supports streaming compression.

Which solution is likely to be more reliable and less of a load on the server.

  1. I would like to understand if there can be trouble when working with one of these tools.

    For example, I accidentally stumbled upon "Note" on this page which says that under high load on the server, creating a backup can, in principle will fail.

  2. Load on the server. This is especially important for Backup-point-in-time, because it will allow you to execute it more often.

0
2

ZFS beats both by light years with snapshots and incremental transfers and transparent compression.

ZFS snapshots can be transferred incrementally. You only transfer the blocks that have changed between the two snapshots. And you get lz4 compression on everything for close to free, and the snapshot sending doesn't have to decompress and recompress.

It is guaranteed to be consistent. ZFS being copy-on-write, either the entire transaction sticks, or the entire transaction is lost, nothing in-between. Unless, of course, you disabled safeties at database level, in which case all bets are off anyway. - gordan-bobic

1
  • Thank. Incremental backups with ZFS are an interesting solution, but this method requires several conditions to be met. More details can be found here. serverfault.com/questions/805257/… We are not using ZFS at the moment, but we may transfer to it.
    – Ivan Gusev
    Sep 16 '20 at 13:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.