Dell Avamar vs. Percona XtraBackup

This software is well suited for companies that want to be very in control of their backups but need a simple tool. It could be convenient for them to just buy their own node, locate it in a different location, and set up the jobs for their machines to backup to the cloud with the specific plugins. However, it would not be convenient for companies looking to have a tool that needs to be secure and compliant, and that need to have different other options for business continuity.

Incentivized

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

• Avamar performs data deduplication on the remote host. This greatly reduces the amount of traffic that each backup requires. This even applies to the virtual environment through change block tracking. Backup times are reduced from hours to minutes.
• The management interface makes it easy to configure and maintain data retention periods. Many times certain data must be kept for an extended period of time. There is a specific menu for managing retention periods.
• The system is able to recover itself from a hard failure with virtually no loss of backups. There is a checkpoint taken each day that provides a recovery point in the event of a catastrophic failure. Since this is a node based system, the loss of more than one node could require a recovery be performed.
• While another grid must be purchased, the replication utility allows all backups to be replicated to another grid at a remote location. This ensures the resilience of the backups in the event there is the loss of the primary data center.
• Also works on HCI devices performing image-level backups as in our primary data center environment
• There is also now an All-in-One appliance for smaller locations

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

• The client interface has constant JAVA issues and can be slow and chunky. We have often had issues with current versions of JAVA breaking it so it will not even run.
• The backup clients are split out for function. Although this makes them light, it also makes it cumbersome to upgrade clients. The naming scheme can also be confusing for the clients.

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.

I have been using the product for over five years. This has performed so well that with the current system reaching its End-of-Life with EMC next year, I have proposed replacing it with the latest version of the product. Now that it integrates with Data Domain, the cost has been greatly reduced. Instead of the need to purchase many nodes, one Data Domain can replace them creating a significant cost savings.

Incentivized

The system overall is easy to monitor and see your backup/restore status. The user interface could use updating as it relies on Java and any updates to Java cause the interface to stop working need to be reinstalled

Incentivized

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

Incentivized

Support is very convincing, always eager to solve issues from the root rather than workaround, don't hesitate to take webex, describe the issues to the core and recommend configuration to avoid further issues. We can ask few questions other than the main issue. They don't hesitate to answer.

Incentivized

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

Incentivized

Avamar has simplied the back up approach in their VE edition and is much easier to use than Data Protector. Backing up multiple VMs takes minutes instead of hours now. Creating policies, retentions, and schedules, is vastly improved and much easier.

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.

• Absolute Zero ROI
• This appliance does not work in its current state and to update we need to wait 2-3 months
• Can't wait to get rid of it and replace it with something else. (not even sure if we will be able to get it running before that)
• [I think] this is one of the worst mistakes we made

Incentivized

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