Leader badge

What is Percona XtraBackup?

Percona XtraBackup is a free and open-source backup solution designed for Percona Server for MySQL and MariaDB, compatible with all versions. It offers online, non-blocking backups that are highly secure and tightly compressed for InnoDB, XtraDB storage engines, and HailDB in transactional systems, ensuring that applications remain operational during maintenance periods. Additionally, Percona XtraBackup supports the execution of streaming, compressed, and incremental backups for MySQL. The Percona XtraDB Cluster (PXC) plays a vital role in preserving and safeguarding data, as well as revenue streams, by delivering maximum availability for critical business applications, guaranteeing that they are perpetually accessible. By utilizing PXC, organizations can achieve cost reduction, eliminate licensing expenses, and adhere to budgetary limits. Furthermore, the integrated tools provided facilitate the optimization, maintenance, and monitoring of your cluster, allowing you to fully leverage the capabilities of your MySQL environment while enhancing overall performance. Thus, leveraging these solutions can significantly improve both operational efficiency and data reliability.

Pricing

Price Starts At:
Free
Price Overview:
Free and open-source
Free Version:
Free Version available.
Free Trial Offered?:
Yes

Screenshots and Video

Company Facts

Company Name:
Percona
Date Founded:
2006
Company Location:
USA
Company Website:
www.percona.com/software/mysql-database/percona-xtrabackup
Edit This Page

Product Details

Deployment
SaaS
Windows
Mac
Linux
Training Options
Documentation Hub
Online Training
Webinars
Support
24 Hour Support
Web-Based Support

Product Details

Target Company Sizes
Individual
1-10
11-50
51-200
201-500
501-1000
1001-5000
5001-10000
10001+
Target Organization Types
Mid Size Business
Small Business
Enterprise
Freelance
Nonprofit
Government
Startup
Supported Languages
English

Percona XtraBackup Categories and Features

Server Backup Software

Backup Scheduling
Bare-Metal Restore
Compression
Continuous Backup
Differential Backup
Disaster Recovery
Encryption
Incremental Backup
VM Backup

Database Backup Software

Automatic Backup
Backup Locations
Backup Scope Settings
Differential Backup
Filegroup Backup
Full Backup
Incremental Backup
Manual Backup
Multiple Backups
  • Reviewer Name: A Verified Reviewer
    Position: DBA
    Has used product for: 2+ Years
    Uses the product: Monthly
    Org Size (# of Employees): 1 - 25
    Feature Set
    Layout
    Ease Of Use
    Cost
    Customer Service
    Would you Recommend to Others?
    1 2 3 4 5 6 7 8 9 10

    Effective, efficient and handy tool - Percona XtraBackup

    Updated: Mar 15 2022
    Summary

    Initial day I was using only standard tool for backup but started facing challenges when database size was large, so started to find out how to tackle this and found the Percona utility free to use which gave me the real help and resolution.
    Also, I can say that this very effective and efficient tool for backup.

    Positive

    1. Proper detailed documentation.
    2. Simple and easy to use.
    3. Very efficient and effective with huge size
    4. Easy to do the setup of replication slave with ease , as the tool is capable to copy all the required files.
    5. Used for Linux OS MySQL
    6. 1.8 TB large database size.
    7. Streaming function made easy to complete the job.
    5. Usually not get failed.

    Negative

    There is no any cons for this but there is little bit of confusion in document, which one is to execute on source and target.

    Read More...
  • Reviewer Name: Puneet K.
    Position: Technology lead
    Has used product for: 2+ Years
    Uses the product: Daily
    Org Size (# of Employees): 20,000 or More
    Feature Set
    Layout
    Ease Of Use
    Cost
    Customer Service
    Would you Recommend to Others?
    1 2 3 4 5 6 7 8 9 10

    Tremendous Backup/Restore Tool

    Updated: May 03 2021
    Summary

    I can say Percona Xtrabackup is a solution to all backup and restore problems . Taking Incremental backups are literally so easy. I think it is best solution for every organization who needs a backup/restore tool.

    Positive

    - It is Free, Open source
    - Can be used with MySQL , MariaDB and MongoDB
    - Provides a consistent backup without any faults.
    - It can take huge DB backup in short time without locking anything.

    Negative

    Can't say it a cons but yes you should the knowledge Xtra backup queries.

    Read More...
  • Reviewer Name: A Verified Reviewer
    Position: DEVELOPER
    Has used product for: 6-12 Months
    Uses the product: Daily
    Org Size (# of Employees): 1 - 25
    Feature Set
    Layout
    Ease Of Use
    Cost
    Customer Service
    Would you Recommend to Others?
    1 2 3 4 5 6 7 8 9 10

    Streamlined and self-contained

    Date: Aug 25 2021
    Summary

    I used to pay thousands of dollars for software not as great as this one.
    In combination with AWS S3 and mysqlbinlog for streaming all transactions, this is a full very simple to use (cheap) backup strategy.

    Positive

    -Immediate s3 backups
    -metadata contained in database itself, no extra files for incremental backups.
    -Set and forget.
    -In combination with mysqlbinlog thread from the backup server, I can backup the whole database in real time. Problem occurs, I just download the last full backup and the incremental backup from S3, prepare the restore and start the database. Once it starts, I can check the last position of the binlog file and just recreate the transactions that where lost since the last incremental backup. Very simple to use. I sleep very well.

    Negative

    This tool works so well and so easy to use, I kinda feel bad charging customers for backups.

    Read More...
  • Reviewer Name: Anton S.
    Position: Devops
    Has used product for: 1-2 Years
    Uses the product: Daily
    Org Size (# of Employees): 1 - 25
    Feature Set
    Layout
    Ease Of Use
    Cost
    Customer Service
    Would you Recommend to Others?
    1 2 3 4 5 6 7 8 9 10

    The best friend for your backups

    Date: Jun 22 2021
    Summary

    This is designed for those who work with MySQL instances. It's easy to use and comfortable to work with. All the features you need. That's why I highly recommend it.

    Positive

    The best tool to create restore physical backups. It's just a required tool for everyone who faced an issue of slow logical backups.

    - free
    - ready to use solution
    - supports full cycle of create/restore backups
    - supports incremental backups
    - kind community that are ready to help you

    Negative

    The tool is really flexible but that means you need to investigate a some time to read all the documentation before use it.

    Read More...
  • Reviewer Name: Aryan V.
    Position: Engineer
    Has used product for: Free Trial
    Uses the product: Weekly
    Org Size (# of Employees): 100 - 499
    Feature Set
    Layout
    Ease Of Use
    Cost
    Customer Service
    Would you Recommend to Others?
    1 2 3 4 5 6 7 8 9 10

    One stop solution for your backup needs

    Date: Nov 15 2020
    Summary

    Easy to use.

    Positive

    Both Local and cloud support.
    Non-interfering backups without any disturbance in the workflow.

    Negative

    Slow verification which results in low reliability.

    Read More...
  • Reviewer Name: Hussain P.
    Position: DBA
    Has used product for: 2+ Years
    Uses the product: Daily
    Org Size (# of Employees): 20,000 or More
    Feature Set
    Layout
    Ease Of Use
    Cost
    Customer Service
    Would you Recommend to Others?
    1 2 3 4 5 6 7 8 9 10

    Great Backup Tool for Backing MySQL Databases

    Date: Oct 06 2020
    Summary

    100% recommended for backing production MySQL databases. Works well with other flavours of MySQL like mariadb and Oracle MySQL.

    Positive

    Faster, Easier, Reliable,Opensource Backup software for backing Percona\MySQL.

    Has great capability to stream backups to remote host and cloud.

    Negative

    None. I have been using it past several years and has never faced any issue.

    Read More...
  • Reviewer Name: Balchandar Reddy V.
    Position: Data Engineer
    Has used product for: 2+ Years
    Uses the product: Daily
    Org Size (# of Employees): 10,000 - 19,999
    Feature Set
    Layout
    Ease Of Use
    Cost
    Customer Service
    Would you Recommend to Others?
    1 2 3 4 5 6 7 8 9 10

    Faster and reliable

    Date: Oct 08 2020
    Summary

    Excellent backup tool.

    Positive

    Percona XtraBackup is a very good backup tool.
    It is very fast and reliable. it won't impact the db performance during backup.
    Very easy to use.

    Negative

    Need to improve in terms of single table and single db backups.

    Read More...
  • Reviewer Name: A Verified Reviewer
    Position: Student
    Has used product for: Less than 6 months
    Uses the product: Weekly
    Org Size (# of Employees): 1 - 25
    Feature Set
    Layout
    Ease Of Use
    Cost
    Customer Service
    Would you Recommend to Others?
    1 2 3 4 5 6 7 8 9 10

    Best tool for MYSQL backups

    Date: Nov 07 2020
    Summary

    Overall this 100/100 for this. It's fast, secure, reliable and what you want more is open source and and also free of cost.

    Positive

    Its reliable, fast, easy to operate and works pretty well and is better than the other tools out there to take daily backups. And is open-source thats a plus point.

    Negative

    No cons. You are getting all its service for free what more do you expect.

    Read More...
  • Reviewer Name: Saksham T.
    Position: Program manager intern
    Has used product for: Free Trial
    Uses the product: Monthly
    Org Size (# of Employees): 26 - 99
    Feature Set
    Layout
    Ease Of Use
    Cost
    Customer Service
    Would you Recommend to Others?
    1 2 3 4 5 6 7 8 9 10

    Percona XtraBackup Review

    Date: Nov 08 2020
    Summary

    Percona XtraBackup is a great product for XtraBackup and back up your Application data and help us in easily manage it.

    Positive

    Percona XtraBackup is a really great product with some great Backup features and help us in getting the quick backup with the speed as its feature.

    Negative

    Percona XtraBackup mostly has some great features and there are not many cons but sometimes hard to use for beginners.

    Read More...
  • Reviewer Name: Helio S.
    Position: Performance analyst
    Has used product for: 2+ Years
    Uses the product: Daily
    Org Size (# of Employees): 100 - 499
    Feature Set
    Layout
    Ease Of Use
    Cost
    Customer Service
    Would you Recommend to Others?
    1 2 3 4 5 6 7 8 9 10

    Great tool to backup

    Date: Oct 25 2020
    Summary

    It really helped me when I needed it. The most important thing I know is the possibility to have an enterprise tool, for free.

    Positive

    It was much simpler than using the MySQL dump tool to do the daily backup.

    At the time, I used to have a 2TB MYSQL database, that I used for Zabbix monitoring. And Percona makes it easy to automate the backup.

    Negative

    Not much that I could point out.

    Read More...
  • Reviewer Name: Rahul M.
    Position: Intern
    Has used product for: 6-12 Months
    Uses the product: Daily
    Org Size (# of Employees): 500 - 999
    Feature Set
    Layout
    Ease Of Use
    Cost
    Customer Service
    Would you Recommend to Others?
    1 2 3 4 5 6 7 8 9 10

    Simple works very fast

    Date: Nov 25 2020
    Summary

    Good consistent hot backup solution with incremental backup and streaming options ease of management for Galera cluster with the possibility to synchronize a node without interrupting applications while reducing the time needed. It's all about backups!

    Positive

    Excellent ....back upping is transparent to applications.
    Very fast and easy backup than other logical solutions.
    Easy, fast, non-blocking!

    Negative

    Nothing, XtraBackup works really well and fast like expect.

    Read More...
  • Reviewer Name: Harjit L.
    Position: MySQL DBA
    Has used product for: 2+ Years
    Uses the product: Daily
    Org Size (# of Employees): 100 - 499
    Feature Set
    Layout
    Ease Of Use
    Cost
    Customer Service
    Would you Recommend to Others?
    1 2 3 4 5 6 7 8 9 10

    XtraBackup is the industry standard

    Date: Oct 09 2020
    Summary

    I have used this in every job I have had. It is free and once set up easy to use and easy to restore from.

    Positive

    This does the job, it is one hundred percent reliable for online backup and restore of MySQL databases.

    Negative

    There are now no easy quick start tutorials to follow.

    Read More...
  • Reviewer Name: Uday R.
    Position: Data Engineering Consultant
    Has used product for: 2+ Years
    Uses the product: Daily
    Org Size (# of Employees): 20,000 or More
    Feature Set
    Layout
    Ease Of Use
    Cost
    Customer Service
    Would you Recommend to Others?
    1 2 3 4 5 6 7 8 9 10

    Nice Backup Tool for MySQL

    Date: Nov 10 2020
    Summary

    Positive

    Percona XtraBackup is a free, online, open source, complete database backups solution for all versions of Percona Server for MySQL and MySQL

    Negative

    There is an opportunity to improve the backup conditions when large DDL queries were running.

    Read More...
  • Reviewer Name: A Verified Reviewer
    Position: Systems administrator/engineer
    Has used product for: 1-2 Years
    Uses the product: Weekly
    Org Size (# of Employees): 26 - 99
    Feature Set
    Layout
    Ease Of Use
    Cost
    Customer Service
    Would you Recommend to Others?
    1 2 3 4 5 6 7 8 9 10

    Great for Backup/Sync/Recovery

    Updated: Oct 07 2020
    Summary

    Still the fastest complete database backup & restore solution.
    I'd say it is the de-facto standard solution.

    Positive

    Using this to backup our production-systems to S3 or re-sync slave nodes.
    Works like a charm.
    We use it to test the restore process automatic with gitlab ci/cd.

    Negative

    Not really a con, but tuning the backup/sync process for speed takes time and some nerves.
    Restoring single tables is not easy.

    Read More...
  • Reviewer Name: Miklos S.
    Position: Data Architect
    Has used product for: 2+ Years
    Uses the product: Daily
    Org Size (# of Employees): 26 - 99
    Feature Set
    Layout
    Ease Of Use
    Cost
    Customer Service
    Would you Recommend to Others?
    1 2 3 4 5 6 7 8 9 10

    The best FOSS tool to backup MySQL

    Date: Nov 02 2020
    Summary

    Almost all the MySQL backup solutions I assembled based on Percona Xtrabackup. I cannot remember a single time it failed me.

    Positive

    It's easy to integrate, a lot of performance/scalability features including throttling, encryption, streaming to cloud.

    Negative

    Parallel streaming to/from s3 would be a nice feature to make the backup/restore time better.

    Read More...
  • Previous
  • You're on page 1
  • Next