Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is anyone using XtraDB (a MySQL build) from Percona?

The features & benchmark data looks nice. I wondered if it's stable enough for production.

What is your experience?

share|improve this question

closed as primarily opinion-based by masegaloeh, Katherine Villyard, Jenny D, faker, mdpc Apr 24 '15 at 6:33

Many good questions generate some degree of opinion based on expert experience, but answers to this question will tend to be almost entirely based on opinions, rather than facts, references, or specific expertise.If this question can be reworded to fit the rules in the help center, please edit the question.

up vote 5 down vote accepted

"Stable for production" is always a subjective measurement. If you are asking if people are using it in production, then yes, they are.

A lot of the major changes are disabled by default, and you need to turn them on for them to work. For example - innodb_fast_recovery. This means if you find a bug, it's very easy to take a step back.

The other point to mention, is that unless you use the Barracuda row format or enable the additional rollback segments feature - Percona releases have binary compatibility with the underlying data files with a 5.0 release. Again, if you find a bug it is very easy to take a step back.

(I'm biased, I work for Percona).

share|improve this answer

I found the FAQ on the website informative for this question.

I think a good point to recognize is that XtraDB is binary compatibility with InnoDB. That is you can switch back to using InnoDB at anytime.

Q: What is the risk? Can it corrupt my database? A: Although we tested it as well as we can, there is always a risk. XtraDB modifies InnoDB kernel significantly, and it is possible there are some bugs. No one has reported any crashing or corruption issues so far.

share|improve this answer

I'm running it on a database that serves roughly 40 queries a second and have experienced no problems. I've never run this database on InnoDB so can't compare it however.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.