MariaDB

Development discussions by and for developers

MariaDB

Postby MrMeek » Mon Mar 07, 2011 3:18 pm

Why was MariaDB chosen to replace MySQL? I'm guessing to avoid complication with potential changes to the MySQL license in the future... Aside from that, are there any performance or security considerations?
MrMeek
 
Posts: 8
Joined: Mon Mar 07, 2011 2:24 pm
Location: FL

Re: MariaDB

Postby sentm » Mon Mar 07, 2011 5:01 pm

Well, a lot of reasons. It is a straight drop-in replacement, and Oracle's MySQL has a fairly shaky future (at least in my mind). Also, I don't know if you have ever tried compiling MySQL, but the shear number of compiler warnings is unbelievable. One of Monty's goals is to eliminate all compiler warnings and notices...this in itself should provide a fair performance gain, as the compiler can better optimize code when it doesn't have to cast from one data type to another or perform any other number of trivial tasks that breaks optimization.

Features
http://kb.askmonty.org/v/mariadb-versus-mysql-features

Compatibility
http://kb.askmonty.org/v/mariadb-versus-mysql-compatibility


MariaDB also provides us with both the latest InnoDB and XtraDB. In the next update, we will likely switch to from InnoDB to XtraDB. This is a drop in replacement, and so far our tests show much better memory handling and performance.

Percona also has some pretty graphs showing the benefits...
http://www.mysqlperformanceblog.com/2010/04/21/mysql-5-5-4-in-tpcc-like-workload/
http://www.mysqlperformanceblog.com/2010/01/13/innodb-innodb-plugin-vs-xtradb-on-fast-storage/
sentm
 
Posts: 87
Joined: Wed May 26, 2010 10:53 pm
Location: Orlando, FL

Re: MariaDB

Postby MrMeek » Mon Mar 07, 2011 5:31 pm

Fantastic :D

Thanks for the details, Lott
MrMeek
 
Posts: 8
Joined: Mon Mar 07, 2011 2:24 pm
Location: FL


Return to Development

Who is online

Users browsing this forum: No registered users and 1 guest

cron