Percona XtraBackup for MySQL Reviews & Product Details

I really like Percona XtraBackup for MySQL because it's very reliable and ensures we don't experience downtimes. It allows our main database operations to run smoothly in the background and provides periodic backups without blocking the database. This makes it highly reliable for us. Also, the initial setup was straightforward and user-friendly, making it beginner-friendly too. I find it really good. Review collected by and hosted on G2.com.

I don't really have much because it's really not mostly used for backing up like, billing backups. And it has been working well so far. So I don't have, like, any major issues there on that front. Review collected by and hosted on G2.com.

MySQL hot backup feature.

Parallel and multithreading feature

Incremental backup

Able to take backups without locking the database which improves efficiency.

Able to use cloud object storage (AWS S3) as a backup location which saves on storage costs. Review collected by and hosted on G2.com.

Complex initial configuration while setting up the incremental backup and using Cloud Object storage as a backup location.

No proper GUI. Having a GUI will make this tool even more powerful.

Supports only limited database flavours. Review collected by and hosted on G2.com.

Works out of the box, reliable for production and all envs. Review collected by and hosted on G2.com.

Takes a while to understand how to use it and restore from it. Review collected by and hosted on G2.com.

Backupping is transparent to applications

Provides a fast way to backup compared to logical solutions, especially mysqldump Review collected by and hosted on G2.com.

As it's a physical backup, it lacks by design some features compared to logical backups

Plus, it should need to be tested to ensure we have a functional backup, which can be a source of pain depending on how/where backups are stored

A "broken" backup could happen if data files are already broken

This is design drawbacks, I do not know if it could be any better regarding these issues Review collected by and hosted on G2.com.

XtraBackup - Number one in MySQL world! The universe history is divided into 2 periods: before XtraBackup and after! Easy, fast, non-blocking! What else would you need to be safe? Yeah, almost nothing. (Almost, because you must remember - it's binary backup solution and you need additionally check from time to time if data isn't corrupted, but that's absolutely another part of story...) Review collected by and hosted on G2.com.

Nothing. XtraBackup just works like expected. Review collected by and hosted on G2.com.

One of the most promising hot backup solution for MySQL based servers

Rich features like compression, streaming, parallelism

Supports incremental backups

Open source

Vibrant community Review collected by and hosted on G2.com.

Cant think of any.

Suggestion: Adding backup manager feature would be great Review collected by and hosted on G2.com.

Online non-locking backup that is ready for restores immediately after taken. Open source with many enterprise like features. Encryption, incremental backup Review collected by and hosted on G2.com.

Sometimes there are errors that are not clear for the end user. In major database upgrades older version of xtrabackup might not work and the error is not obvious. Review collected by and hosted on G2.com.