XtraBackup for fast and reliable hot-backups
October 29, 2020

XtraBackup for fast and reliable hot-backups

Douglas Doo | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Percona XtraBackup

Percona XtraBackup is used to run non-locking backups on our replicas. We usePercona XtraBackup to run full backups and daily incrementals on some of the larger database servers, [which allows] us to do point-in-time restores and thus satisfy compliance regulations or scale our reads by seamlessly firing up more replicas. The speed of Percona XtraBackup is crucial and allows us to complete the backups during a specified window.

Pros

  • 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.

Cons

  • 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.
  • Secure, reliable, fast and consistent backups. Open source with zero cost.
  • We satisfy our regulatory requirements.
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.
Backups and restores can be done in a couple of basic commands, but [it] has the option to tune many parameters when needed. In most cases the defaults are perfect, but it is great to have the option. Percona XtraBackup is easily scripted due to its ease of use and flexibility.
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.

Do you think Percona XtraBackup delivers good value for the price?

Yes

Are you happy with Percona XtraBackup's feature set?

Yes

Did Percona XtraBackup live up to sales and marketing promises?

Yes

Did implementation of Percona XtraBackup go as expected?

Yes

Would you buy Percona XtraBackup again?

Yes

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

Percona XtraBackup Feature Ratings

Data Center Backup
10.0
Encryption
10

Comments

More Reviews of Percona XtraBackup

  1. Home
  2. Data Center Backup Solutions
  3. Percona XtraBackup Reviews
  4. User Review of Percona XtraBackup