Take the 2-minute tour ×
Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. It's 100% free, no registration required.

If you know MariaDB, what's your opinion about migrate applications to use MariaDB instead of MySQL?

What we gain and what we lost with this change?

Is it really unnecessary to change the application in any situation?

Any tip to assure the application run smoothly on MariaDB?

share|improve this question
3  
Do you have a problem with MySQL that you're looking to overcome? –  Fosco Sep 21 '10 at 19:32
5  
@Fosco: In a word: Oracle. –  Mason Wheeler Sep 22 '10 at 20:37
    
@Mason Wheeler: I don't know. Maybe Oracle turned over a new leaf or something. Ever since they acquired Sun it looks like this is the first time that everything they touch doesn't turn to sh!t. Is there something I don't know? –  Steve Evers Sep 24 '10 at 0:33

4 Answers 4

up vote 6 down vote accepted

MySQL still has the advantage of being bigger than the forks and clones. Bigger in the sense of number of users and expertise that is available. It has taken a long time for MySQL to become a 'safe' choice to use for companies. That reputation wont be lost overnight, nor will it be gained by MariaDB soon either. In a commercial environment it matters and it will be hard to introduce MariaDB in a lot of places.

You mention migrating in your question. Migrating is hard, particularly for lower level 'stuff' and especially data storage. I wouldn't recommend it unless there was a specific benefit from doing it.

share|improve this answer

I really don't see the point. MySQL is a mess anyway, and a fork of it is going to inherit all its quirks and gitches. If you want to move off of MySQL, why not just switch to Firebird, a free and open source DB that doesn't feel like a toy whenever you try to use it?

share|improve this answer
9  
Postgresql is also a viable alternative. –  Robert Harvey Sep 24 '10 at 1:44
    
+1 indeed @Robert Harvey, you may know, but for benefit of those that don't, major web CMS drupal supports this as well as MySQL –  therobyouknow Dec 18 '10 at 10:18

far as i known MariaDb isn't productive quality already. But i think that she is (yes, is a woman) the future. Software is more the people involve in it that the branding name

share|improve this answer
    
RE: "she is (yes, is a woman)" Not quite. MariaDB is created by the same guy who created the original MySQL, Monty Widenius. He named it after his daughter. –  user36644 Sep 14 '11 at 0:38

The whole thing is moot.
Percona Server does what MySQL does (100% compatible), but does it right, fast and while using less resources.
In many ways it's like Maria, only taking it one more step.

After doing extensive testing in our test environment to ensure it's as compatible and easily interchangeable as it says on the tin, I was able to swap out our production MySQL for Percona in about 2 minutes. I timed it in such a way that I was able to do it during production hours without noticeable downtime.

So yeah, if you're going to swap out MySQL, swap it out for Percona.

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.