AWS Backup vs. Percona XtraBackup

There is a cost involved with data retrieval. AWS Backup is truly that, a backup. If you need to access this data on a regular basis, there are better options out there. For long term, just in case incremental backups, AWS [Backup] checks all the boxes. Just set it up, start your backups, and rest assured your data is safe.

Incentivized

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

• Backups - it's what it does.

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

• Not so easy to use
• A little pricey
• The backup is in the cloud; make sure to keep an offline backup (the problem of all of this kind of solution)

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.

Very easy to use and is as plug and play as you can get. There are configuration options for multiple schemas that best fits your organization.

Incentivized

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

Incentivized

Support for AWS Backup is by Amazon itself so it is solid as always. If you have a business or higher level support plan you'll have no trouble getting engineers or other staff on the job to help you with whatever comes up.

Incentivized

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

Incentivized

Being an AWS service, AWS Backup integrates in a native way with other AWS services, providing an easy way to backup those services. Being able to create separate backup plans that meet specific business and regulatory compliance requirements provides us with capabilities to face auditing processes.

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.

• Being able to offer live hot storage in the cloud for production environments allows me to get more people in the creative space with vast demand for speed.
• Great integration with all my hardware, firewall and backup software was great.
• Being able to network path my files like a native drive to my computer from the cloud made the designer not complain so much able learning new stuff.

Incentivized

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