Percona XtraBackup vs. Veeam Agent for Microsoft Windows

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

We use it as a Simple Deployment. As a simple deployment scenario, the roles of the backup server, VMware backup proxy, and backup repository are assigned to a single machine. These roles are assigned automatically to the machine where we installed Veeam Backup & Replication. The drawback of the simple deployment scenario is that only the backup server handles and stores all data which is a single point of failure.

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

• File level restore
• Backing up of difficult Laptops that are in and off the network
• Reporting
• Integration into other Veeam Products

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.

• Stop the backup job from the console instead of having to stop from the client.
• Don't consume too many resources while taking a backup.

Incentivized

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

Incentivized

Overall, Veeam Agent for Microsoft Windows is a great backup solution and supplies extremely useful tools to configure backups to suite our needs and our clients requirements. I have only taken some points off as the user interface could be easier to navigate when configuring backups and the ability to update Veeam Agent for Microsoft Windows from within the software would be appreciated.

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 just on another level compared to most other software vendors who tend to make backup solutions complicated. Veeam uses intuitive GUI's that make sense to most people and take the stress out of systems recovery at high and low levels by simply explaining the process step by step.

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