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.

Now that MySQL is owned by Oracle many are starting to consider using some of the popular forks such as MariaDB and Drizzle.

Has anyone used these in production for any extended periods of time? If so have the features been stable and has the experience been comparable to MySQL?

share|improve this question
3  
Please note that I don't think people's feelings on this topic will be of much use if there isn't experience behind it: blog.stackoverflow.com/2010/09/good-subjective-bad-subjective . –  Kyle Brandt Nov 4 '10 at 18:22
    
Sorry to see that not many answers were given (only Percona). So, what do you think? –  Aleksandr Levchuk Dec 10 '10 at 1:14
add comment

3 Answers 3

We haven't used the MySQL forks but for our case (a Bioinformatics databases) switching to PostgeSQL worked really well. The web-application (Cellwall Navigator, 10k lines of Perl code and 10 db tables) was running on MySQL for 5 years. It took us 2 days to adjust the SQL to migrate to Postgres.

No application coded needed adjustments except for connection to the database.

The adjustment were:

  • Replaced MySQL password() with Postgres md5() like this SELECT id FROM users WHERE email = ? AND password = password(?) becomes SELECT id FROM users WHERE email = ? AND password = md5(?)

  • Easy conversion for a MySQL STRAIGHT_JOIN to a regular JOIN

  • And one JOIN case like this

Original SQL, which was permitted by MySQL (worked fine for the app before migration):

SELECT sequence.id, ... FROM sequence JOIN xlink ON xlink.sequence = sequence.id WHERE xlink.accession = ? GROUP BY sequence.id

We adjusted it to be the proper SQL that works in PostgeSQL and correct for the application:

SELECT DISTINCT sequence.id, ... FROM sequence JOIN xlink ON xlink.sequence = sequence.id WHERE xlink.accession = ?
share|improve this answer
2  
+1 for PostgreSQL. IMO, it deserves far more attention than it gets. –  Steven Monday Nov 4 '10 at 20:22
add comment

I use http://www.percona.com/software/percona-server/ now and its great. I also know of some very popular Internet companies that use it

share|improve this answer
    
It is the same MySQL with XtraDB storage engine patch, isn't it? –  NARKOZ Nov 5 '10 at 5:25
1  
no they also heavily patched the InnoDB driver.. Also included a lot of the Google patches that the MySQL people never put in –  Mike Nov 5 '10 at 5:59
add comment

I've been running MariaDB at Ravelry.com for about a year. The master db is 5x larger than the 40 GB buffer pool and it handles a fair amount of traffic - about 3K queries per second at busy times. In my opinion, it is the best MySQL out there and there is no reason to use any other MySQL.

It performs better than regular MySQL (thanks to the included Percona XtraDB / InnoDB plugin), is actively maintained, and contains additional useful patches and storage engines apart from Percona's work.

I could go on and on about indispensable features that plain MySQL doesn't have - marked performance improvement with multiprocessor machines, innodb recovery time is vastly improved, bugs in mainline MySQL are dealt with quickly, table and index statistics are extremely useful... I'm excited to see HandlerSocket added (via Percona)

MySQL 5.5 was recently released and it does (finally) come close to the included XtraDB engine performance-wise but I still think that MariaDB is a better way to go.

Use MariaDB.

share|improve this answer
    
I posted similar praise for MariaDB over at SO: stackoverflow.com/questions/2450534/… –  Casey Dec 17 '10 at 14:51
add comment

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.