#1 most frequent
United States of America
39.5%30 installations of 76
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 & Use Cases
Media
1 / 2
Screenshot of Percona XtraBackup: Backup and Restore of a Single Table or Database
Top Performing Features
Encryption
Data encryption to ensure that data is safe while being backed-up
Category average: 9.1
Areas for Improvement
Who Buys & Uses Percona XtraBackup
#2 most frequent
India
23.7%18 installations of 76
#3 most frequent
Brazil
5.3%4 installations of 76
XtraBackup for fast and reliable hot-backups
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.
Return on Investment
- Secure, reliable, fast and consistent backups. Open source with zero cost.
- We satisfy our regulatory requirements.
Usability
Other Software Used
Percona Server for MySQL, Percona Server for MongoDB, Percona XtraDB Cluster
Xtrabackup : Perfect Backup Solution for Large MySQL Databases
Pros
- 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
Cons
- 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.
Return on Investment
- Improved BCP plan
- Cost optimization : Backup can be taken from the same server.
- Scalability : Rebuilding replicas are easy.
- Improved RPO
- Improved RTO
- Cost optimization
Alternatives Considered
Zmanda Recovery Manager for MySQL
Usability
Other Software Used
Scylla, Couchbase, Amazon Elastic Load Balancing
XtraBackup is the industry standard
Use Cases and Deployment Scope
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.
Pros
- Reliable backups without locking the DB
- Easy to restore from
- No downtime whilst backing up
Cons
- Better online documentation on how to use
Return on Investment
- 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.
