Percona XtraBackup vs. Veeam Agent for Microsoft Windows

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

Veeam is our top-tier solution for backing up a handful of old-school physical Windows servers, and it is very good at this. It is also top notch in user-friendly granular file restores and application specific object restores (AD, SQL, etc).

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

• Relatively speedy backups for a traditional backup solution
• Good efficiency solutions used to shrink backup sizes
• Robust synchronization capabilities for offsite backups
• Veeam can perform a full metal restore of a physical server
• If needed, Veeam can convert a backup of a physical server to a virtual server

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.

• Veeam could use more flexible job scheduling options
• The Veeam Backup and Replication GUI is good but could be simplified
• Veeam Support can be a bit slow at resolving some issues

Incentivized

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

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.

Veeam is vastly superior. It was the product we vetted and switched to from Cloudberry. CB can perform adequate backups but restores can be challenging and there are a lot of missing features compared to Veeam.

Incentivized

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

• It allows end users to easily self-serve their own file restores, freeing up IT resources
• It provides a seamless DR solution for the resources it backs up
• It frequently take a long time to resolve problems when they do occur

Incentivized