Forgot your password?
typodupeerror
Databases

MariaDB vs. MySQL: A Performance Comparison 112

Posted by Unknown Lamer
from the well-duh dept.
Nerval's Lobster writes "MariaDB is a fork of the MySQL source code, split off in the wake of concerns over what Oracle would do with MySQL licensing. In addition to its role as a 'drop-in replacement' for MySQL, MariaDB also includes some new features that (some claim) make it better than MySQL. Jeff Cogswell compares MySQL and MariaDB and suggests (in his opinion) that there's 'more than enough reason to ditch MySQL and switch over to MariaDB and stay there.' Why? While he breaks down MariaDB's new features and thinks many of them aren't that fantastic, and while MariaDB's performance isn't that much better than that of MySQL ('MariaDB's performance appears a bit better on multi-core machines, but I strongly suspect that one could tweak MySQL to match'), the questions over Oracle and MySQL licensing give him pause. 'MariaDB shows every indication that it will be around for quite awhile, while you can't really say the same of Oracle's MySQL,' he writes. 'Free-and-open MySQL competes with Oracle's proprietary and extremely competitive tools. That alone is grounds for concern — will Oracle do something to impede MySQL's development?'"
This discussion has been archived. No new comments can be posted.

MariaDB vs. MySQL: A Performance Comparison

Comments Filter:
  • by Alain Williams (2972) <addw@phcomp.co.uk> on Wednesday May 22, 2013 @12:42PM (#43795703) Homepage

    Today the list of incompatabilities is small and unimportant. I wonder if one will make a really useful difference that would encourage developers choose one or the other; then users would really need to choose. At the moment which you use doesn't really matter.

  • by gstoddart (321705) on Wednesday May 22, 2013 @12:51PM (#43795789) Homepage

    I think concerns about Oracle's long-term plans for MySQL are valid to ask.

    If it isn't making Larry money, what did he buy it for and what is he planning to do with it?

    Oracle isn't exactly a customer friendly company (just ask anyone who had an older Solaris machine when Oracle bought Sun and got told they needed to buy a support contract to even access docs), so I've always wondered why they would buy a free database and continue to develop it and give it away.

    If I was choosing based purely on open-ness, something which doesn't have the chance of Oracle coming along and closing it otherwise strong-arming people would be a plus.

    I guess it legitimately is FUD, but sometimes, there's valid reasons to mistrust such entities. And having dealt with Oracle over the years, they themselves are a very strong reason to be suspicious.

  • Switch (Score:4, Insightful)

    by Anonymous Coward on Wednesday May 22, 2013 @01:00PM (#43795847)

    Switch to Postgres. It'll be there for a long time.

  • by Anonymous Coward on Wednesday May 22, 2013 @01:04PM (#43795885)

    We're only seeing this because the guy who sold MySQL to Oracle wants a second bite and is trying to discredit what he just sold them as hard as he possibly can so that people move back to his stuff.

  • by jgrahn (181062) on Wednesday May 22, 2013 @01:09PM (#43795931)

    Today the list of incompatabilities is small and unimportant. I wonder if one will make a really useful difference that would encourage developers choose one or the other; then users would really need to choose. At the moment which you use doesn't really matter.

    If that's true, now is the best time to switch. Not when/if the vendor starts squeezing your balls.

  • by AdmV0rl0n (98366) on Wednesday May 22, 2013 @01:10PM (#43795933) Homepage Journal

    I think concerns about Oracle's long-term plans for MySQL are valid to ask.

    If it isn't making Larry money, what did he buy it for and what is he planning to do with it?

    Oracle isn't exactly a customer friendly company (just ask anyone who had an older Solaris machine when Oracle bought Sun and got told they needed to buy a support contract to even access docs), so I've always wondered why they would buy a free database and continue to develop it and give it away.

    If I was choosing based purely on open-ness, something which doesn't have the chance of Oracle coming along and closing it otherwise strong-arming people would be a plus.

    I guess it legitimately is FUD, but sometimes, there's valid reasons to mistrust such entities. And having dealt with Oracle over the years, they themselves are a very strong reason to be suspicious.

    Oracle maintain multiple open source initiatives. *I'm * not making any claim about wether these are maintained 'correctly or not, because the truth is that I am not in a position to state factually what the true state is.

    But - people still use Virtual box. People still use Java. People are still using MySQL.
    I'll pitch - even though I struggle to think its true - that if Oracle maintained them well, and if a true state exaists where the smaller MySQL may lead to an upgrade when things get large to Oracle DB - I can see why a vendor might say to itself that damaging our own product isn't productive. If they trust us implicitly doing a good job on MySQL they will believe the same basic premise on the day they need heavier iron and DB.

    It is understandable commecially to look at things and remove or kill things that are done and have a fork in them. Its another to just vandalise in an unthinking stupid way a well grounded, popular and well regarded product.

    The core question got asked at the end of the first post:
    That alone is grounds for concern — will Oracle do something to impede MySQL's development? Citation and real evidence required.
    The real world, true answer to that question is the real guide, other stuff and argument is fluffy..

  • by Anonymous Coward on Wednesday May 22, 2013 @01:10PM (#43795953)

    Yeah but you have oracle purposely trying to cripple MySQL so they can sell more oracle DB licenses.

    The Monty AB guys need MariaDB to be a good product you want to buy support for.

  • Useless FUD (Score:1, Insightful)

    by Anonymous Coward on Wednesday May 22, 2013 @01:11PM (#43795961)

    Migrating to MariaDB "just because" is dumb.

    If Oracle makes it clear that they're not going to support MySQL in a way that's compatible with your business, then consider your alternatives.

    Changing your DB infrastructure will take time & release cycles to properly plan, test, and deploy. If it's a drop-in replacement as they claim, then you will not have much trouble making a quick migration down the line. If it's NOT a drop-in replacement as they claim, you should consider other DB technologies and select the one that matches your needs best, and then migrate to that. Doing EITHER of these things just because "Oracle may someday decide to do something awful to MySQL" is a waste of time. Consider alternatives now, if you're really concerned, but making a decision to migrate based on some FUD about Oracle from the MariaDB people is the mark of an idiot.

  • Re:Great summary! (Score:4, Insightful)

    by Anrego (830717) * on Wednesday May 22, 2013 @01:14PM (#43795983)

    Interlinking like this still seems in poor taste.

  • by Anonymous Coward on Wednesday May 22, 2013 @01:18PM (#43796015)

    the heck with that, oracle fucked up mysql the moment they bought sun...

    (while some might argue that mysql was first fucked up by sun when they bought mysql..)

  • by red_dragon (1761) on Wednesday May 22, 2013 @01:21PM (#43796037) Homepage

    My son used to play a silly little match game that he picked up from pre-school when he was three years old. In it, he would take two toys -- cars, action figures, Lego blocks, staple removers, whatever -- hold them in his hands, and ask "Which one are you, X or Y?" After the other person (usually me) answered, he'd act out some sort of epic battle between the two toys in his hands, and then declare one or the other the victor. I always pointed out to him the pointlessness of the game. He didn't care.

    Jeff Cogswell's reviews remind me of that game. They're pointless. He doesn't care. And my son grew out of it.

  • by rudy_wayne (414635) on Wednesday May 22, 2013 @01:29PM (#43796109)

    We're only seeing this because the guy who sold MySQL to Oracle wants a second bite and is trying to discredit what he just sold them as hard as he possibly can so that people move back to his stuff.

    I think you may be right.

    The creator of MySQL sold out to Sun and now he's trying to claim that his new DB is better, probably hoping he can sell out again and collect another big paycheck.

  • by rudy_wayne (414635) on Wednesday May 22, 2013 @01:35PM (#43796171)

    Oracle wants to use MySQL as a stepping stone for people to migrate them over to full Oracle DB. That's one of the reasons they bought the thing.

    That's not really true. Prior to buying Sun, Oracle probably didn't give two shits about MySQL. Oracle wanted Sun, and Sun just happened to own MySQL, so it was part of the deal. Once Oracle had MySQL then they had to figure out what to do with it. The same thing with Java.

  • by greg1104 (461138) <gsmith@gregsmith.com> on Wednesday May 22, 2013 @01:58PM (#43796397) Homepage

    Concerns about MariaDB's long-term plans are appropriate too. Monty has setup his new company with contributor copyright assignment such that he can sell it off again, the same way he did with MySQL. If you actually taste the FUD here, you should be migrating away from both of these uncertain projects, not deciding which of them to use.

  • by ShanghaiBill (739463) * on Wednesday May 22, 2013 @04:04PM (#43797559)

    How is Oracle crippling MySQL?

    By just sitting on it, and not improving it.

    Years ago, MySQL lacked many features that kept it from being a "real" database. Over the years, it has added transactions, stored procedures, triggers, etc. If that trend continued, why would anyone use Oracle? If Oracle just shut down MySQL, the momentum would shift to PostgreSQL or MariaDB. So by keeping MySQL alive, but stopping the improvement, Oracle is holding back free alternatives from competing with them.

  • by HornWumpus (783565) on Wednesday May 22, 2013 @05:14PM (#43798151)
    MySQL can't improve without breaking all the code that depends on it's fucked behavior.

Chairman of the Bored.

Working...