Percona XtraBackup Reviews

4 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.8 out of 100

Do you work for this company? Learn how we help vendors

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Reviews (1-3 of 3)

Companies can't remove reviews or game the system. Here's why.
October 28, 2020
Douglas Doo | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
  • 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.
  • 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.
Well suited to databases < 10TB.
For larger than this, I would go with snapshots.
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.
Read Douglas Doo's full review
October 28, 2020
Anil Yadav | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
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.
Read Anil Yadav's full review
October 24, 2020
Harjit Lakhan | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
All online MySQL backups are done using XtraBackup. It's 100% reliable, and we have done restores with no problems. The alternative is to do a cold backup, but shutdown of a prod DB is not practical. Also, doing MySQL dump is not practical for large databases.
  • Reliable backups without locking the DB
  • Easy to restore from
  • No downtime whilst backing up
  • Better online documentation on how to use
Online backups for databases using innodb is ideal. If you have too many myisam tables it still needs to lock the tables before backing up so may be not ideal.
If you pay for support it is great, otherwise you have to google.
Read Harjit Lakhan's full review

Feature Scorecard Summary

Encryption (2)
8.6

What is Percona XtraBackup?

Percona XtraBackup is a free, open source, online backup solution for all versions of Percona Server for MySQL, MySQL, and MariaDB. Percona XtraBackup performs online non-blocking, tightly compressed, secure backups of InnoDB, XtraDB, and HailDB storage engines on transactional systems, so that applications remain fully available during planned maintenance windows. Percona XtraBackup can perform streaming, compressed, and incremental MySQL backups.

Percona XtraBackup aims to ensure higher uptime by providing fast and reliable backups, with uninterrupted transaction processing. It enables users to save on disk space and network bandwidth due to better compression and includes automatic backup verification. Percona XtraBackup brings immediate, noticeable, and long-lasting benefits, allowing you to meet your budget and business needs.
Categories:  Data Center Backup

Percona XtraBackup Features

Data Center Backup Features

Has featureEncryption
Additional Features
Has featureCompression
Has featureIncremental Backup
Has featureDisaster Recovery
Has featureDifferential Backup
Has featureBackup Scheduling
Has featureVM Backup
Has featureContinuous Backup
Has featureBare-Metal Restore

Percona XtraBackup Screenshots

Percona XtraBackup Video

Percona XtraBackup Downloadables

Percona XtraBackup Integrations

Percona XtraBackup Competitors

AWS Backup, MySQL Enterprise Backup, MySQLDumper

Percona XtraBackup Pricing

  • Has featureFree Trial Available?Yes
  • Has featureFree or Freemium Version Available?Yes
  • Has featurePremium Consulting/Integration Services Available?Yes
  • Entry-level set up fee?Optional

Free and open-source

Percona XtraBackup Support Options

 Free VersionPaid Version
Forum/Community
FAQ/Knowledgebase
Social Media
Video Tutorials / Webinar
Phone
Live Chat
Email

Percona XtraBackup Technical Details

Deployment Types:On-premise
Operating Systems: Linux
Mobile Application:No