Xtrabackup : Perfect Backup Solution for Large MySQL Databases
October 28, 2020

Xtrabackup : Perfect Backup Solution for Large MySQL Databases

Anil Yadav | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Percona XtraBackup

Every organization that uses any database always thinks about BCP. Backups are very much required for any organization. Xtrabackup is an online backup solution for MySQL, MariaDB, and Percona Server for MySQL. Xtrabackup is a fast and non-blocking backup and Restore process for Datastore. We are using it for all of our MySQL fleet.

It's solving the problem of backup /disaster recovery and BCP.

Xtrabackup supports full and incremental backup. Backup can be stored either locally or in any cloud storage. Basis of database size/RTO/RPO. You can plan what type of backup you want to schedule and what will be the frequency of backup. For our setup, we are taking full backup once in a day and Incremental backup every 6 hours. This backup can be utilized for all-purpose(rebuilding replicas/ test database or recovery from disaster (accidental data drop or machinefailure).
  • 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
  • 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.
  • Improved BCP plan
  • Cost optimization : Backup can be taken from the same server.
  • Scalability : Rebuilding replicas are easy.
  • Improved RPO
  • Improved RTO
  • Cost optimization
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.
Xtrabackup is a complete backup solution for MySQL. The feature set (NonBlocking, Scalable, Reliable) makes it perfect for Large MySQL deployments.

Users can configure alerting on top of this to get timely reports for the status of the backup. Feature set of XtraBackup (Stability/Backup Time/ Storage /CostOptimization)make it useable for all MySQL related (MySQL, MariaDB, Percona Server for MySQL) deployments.

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


Are you happy with Percona XtraBackup's feature set?


Did Percona XtraBackup live up to sales and marketing promises?

I wasn't involved with the selection/purchase process

Did implementation of Percona XtraBackup go as expected?


Would you buy Percona XtraBackup again?


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.

Percona XtraBackup Feature Ratings