Microsoft System Center Data Protection Manager (DPM) vs. Percona XtraBackup

Microsoft System Center Data Protection Manager is well suited for Windows domain environments where you need to make backups of Hyper-V virtual machines or bare metal servers. It is possible to backup SQL databases, works pretty well, but sometimes needs consistency checks on backups to properly continue to backup databases. Easy to restore anything to production or to another location.

Incentivized

Well suited to databases < 10TB. For larger than this, I would go with snapshots.

• Hyper-V backup /restore
• Bare-Metal backup/restore
• Good management console

Incentivized

• Non-blocking backup : Backup process will not put any lock on the database.
• Fast recovery : As it's a file level backup so it's quite fast in both backup and recovery.
• Consistent backup : Xtrabackup always ensures consistent backup.
• Easy to configure and Use.
• Integration with clouds

• Integration with some devices
• Web client
• Slow interface

Incentivized

• The only feature that could use some improvement is partial backup restores. For example, I have a multi-tenant database at the schema level running on a single Percona Server instance. As a tenant grows too large for the share instance or becomes a noisy neighbour we need to move a the tenants schema to its own instance with minimal downtime, meaning that we would run the new instance as a replica with replication filters until failover. In terms of doing a consistent backup, there may be challenges and it is currently possible with XtraBackup, but it would be great if the process was simplified and ensured to be consistent.

Takes a bit of getting used to when you first set it up.

Incentivized

If you pay for support it is great, otherwise you have to google.

Incentivized

Incentivized

We have evaluated Mysqldump and MySQL Enterprise backup. Mysqldump is not a scalable solution. MEB is a paid and closed source. As we are truly open-source, we were looking for an open-source solution that was reliable and scalable. Xtrbackup has all the required features to fulfill our requirements.

• It has saved us on licensing costs and through centralized management.

Incentivized

• Secure, reliable, fast and consistent backups. Open source with zero cost.
• We satisfy our regulatory requirements.