Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

3 Answers 3

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'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

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

http://www.percona.com/docs/wiki/percona-xtradb%3Ainfo%3Afaq

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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