AWS Backup vs. Percona XtraBackup

AWS [Backup] does what it intends on doing. AWS [Backup] is very fast, however, for that speed, you'll end up with a high bill at the end of the month. Compared to competitors, AWS [Backup] is a lot more expensive than others. However, I believe it makes it up in it's versatility - there's no company more compatible with others than AWS.

Incentivized

Xtrabackup has many excellent features that are supposed to be in any backup solution. It's well suited for all MySQL deployments but it's not appropriate for any other database. If you are using any MySQL flavor (MySQL, MariaDB, Percona Server for MySQL), it's your only and perfect solution for backup and disaster recovery.

• Centralized management - single pane of glass to manage backups for multiple AWS services.
• Encryption - integrates with KMS to encrypt backup data at rest and in transit.
• Cross Account management - manage backups across multiple AWS accounts with AWS organizations.

Incentivized

• The ability to stream backups (using netcat or socat) to a target destination has many uses, for example, 1)We do not need to store a backup locally on the database server 2) We can stream backups into object storage using GCSFUSE.
• The hot-backup functionality is probably the most important function. We are able to take backups of our primary instances with minimal impact on the database instance.
• XtraBackup has many parameters that can be tuned, allowing us to increase performance or reduce by using the parallel thread parameter for example.
• Partial backups.
• The ease of use when doing restores. Simplified, fast and accurate.

• Lacks built-in features for granular recovery, such as files or DB records, without restoring the entire backup.
• Complexity - managing backups with multiple rules and resources, with limitations on the number of tags and resources per plan.
• D/R recovery orchestration - does not offer advanced D/R orchestration.

Incentivized

• Remote execution: Xtrabackup doesn't support remote backup. The backup process has to run locally and have to store data locally.
• LifeCycle management: Xtrabackup doesn't support backup lifecycle management. Users have to manage it themself.
• Stability for large databases.

Overall because I can sell it white labeled and use my white labeled software like CloudBerry and the native backup apps on my synology NAS servers to store things in real time and do duplication and disaster recovery directly to it was game changing for my client in the advertising world they are never down now.

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

Great support, detailed online documentation, and examples in many scenarios. Bugs can be logged and are tracked. Great community support has been built-up due to Percona XtraBackup being a great product. Frequent releases ensure bug fixes are committed as soon as possible. Over and above this, the development team stays up to date with the latest releases of MySQL and ensures it is 100% reliable.

Linode requires a minimum data purchase for their S3 storage solution. While the convenience of being able to mount the drive directly is great, it isn't the best for small amounts of data for our different customers. I initially tried there other backup solution but they couldn't guarantee where the data would be stored in relation to the server we were using. The risk being an incident in our near our server could result in the loss of our backup as well.

Incentivized

Percona XtraBackup saves us time and money. Besides the performance and reliability, the support and documentation are top-notch. It's not just about the cost savings, but about the functionality and the minimal impact that XtraBackup has on the database server during a backup window. Percona XtraBackup has been integrated into Percona XtraDB Cluster which makes adding nodes easy and fast.

• With AWS Backup we can restore a resource in minutes
• With AWS Backup we don't need to worry if a resources is being backed up or not, the plan you can configure can cover all resources
• With AWS Backup you can plan for Disaster Recovery as it lets you copy the backup to other account or region

Incentivized

• It is free and the best backup tool that I know of. Using this for free means we save on having to purchase other backup software.
• As a DBA it is the standard backup tool that is used everywhere I have been.

Incentivized