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.

I'm running MySQL for most of our DBs right now, and would like to get off the Oracle ship before it takes more of a turn. My understanding is that the transition from MySQL->MariaDB should be trivial, but going the other way is not so easy. Has anyone made this jump yet?

Edit: Bonus points if you have anecdotal information on doing this with Debian/Ubuntu.

share|improve this question
    
Before it takes more of a turn... to what? –  joeqwerty Aug 9 '11 at 19:27
2  
I'm a FOSS guy, so the short answer is more closed and less community-supportive. I will restrain the more detailed/soap-boxy explanations for rant blogs and the like. =) –  Bryan Agee Aug 9 '11 at 19:32
1  
What app is running over top the db? Is it supported? Seems to me Even if it works today, the longer term question is whether the app will continue to work should mariaDB & MySQL diverge. –  uSlackr Aug 9 '11 at 20:34
1  
why not just go to the oss-forked mysql? Or have you perhaps considered PostgreSQL? –  warren Aug 18 '11 at 16:40
1  
MariaDB isn't the only other option. There is also Percona Server. –  Baron Schwartz Aug 18 '11 at 18:59
show 2 more comments

4 Answers 4

up vote 8 down vote accepted
+100

I have migrated various servers from MySQL to MariaDB a few weeks ago without any problem.

If you want the full list of what might not be compatible, you can have a look here: http://kb.askmonty.org/en/mariadb-versus-mysql-compatibility.

If you're upgrading to a higher version of MariaDB than MySQL was, you just have to jsut the mysql_upgrade binary as stated on http://kb.askmonty.org/en/upgrading-to-mariadb-from-mysql.

Moreover, with MariaDB 5.3 (released at the end of July), they now provide a proper repository, so there's no need to install by hand : http://downloads.askmonty.org/mariadb/repositories/

share|improve this answer
    
Does PHPmyadmin works fully with mariadb? –  john Oct 8 '11 at 4:26
    
Yes, it works perfectly, the protocol is just the same as MySQL. –  MunsterNet Oct 10 '11 at 11:40
add comment

I know of a friend who moved his vBulletin forum to MariaDB using the XtraDB engine without problems and noted some performance improvements compared to MySQL with InnoDB.

One of the things to take note of is that NDB does not work on MariaDB[Source].

share|improve this answer
1  
The performance gains could be just from switching to XtraDB, which can be used with MySQL as well. –  Joshua Hoblitt Aug 22 '11 at 8:34
add comment

After reading http://vbtechsupport.com/606/, I migrated most of my servers over to MariaDB 5.2 builds and alot of clients have done the same with positive gains. Definitely worth it!

share|improve this answer
add comment

Same here - migrated our only MySQL database to MariaDB two years ago. It was as easy as removing MySQL server package and installing MariaDB instead.

share|improve this answer
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.