5 ms·

Other than being seemingly more closed sourced, is there a reason to choose MariaDB over MySQL?

cowmix 12y ago
That's enough right there. Being more open sourced means there's a lot less friction when trying to deploy and maintain your MySQL instance(s).
- 67726e 12y ago
  A project being open-source has no bearing on whether or not it is easy to use and deploy.
  - spindritf 12y ago
    Of course it does. Open source projects have a decent chance of being included in your distribution's default repositories. Popular packages will even usually be kept up to date. All that for free, with no effort on your part.
    - fedesilva 12y ago
      My experience tends to be that distro packaged software is not always what one ends up using in production. Except for some base packages when you start doing more sophisticated deployments. Distros may backport bug fixes and specifically security fixes but they tend to be several versions behind.
  - devcpp 12y ago
    It does has a bearing on the ability to migrate to an alternative if it turns out to become awful, because someone will probably write an export script in that case. It's one of the big advantages of FOSS: no vendor lock-in.
  - marcosdumay 12y ago
    Yes, it does. A software being open source means that you can deploy for any task in any environment, at any number, without the need to ask anybody's permission. It being proprietary means that you must ask permission first, and will probably need to keep each piece of software under control, under different terms.
kbar13 12y ago
MariaDB is more or less a drop-in replacement for MySQL. One reason (while being related to the potentially closed-source leanings of MySQL) is that you don't want to one day suddenly be cut off from performance and security updates because oracle.
viraptor 12y ago
If you're running replication, both multithreaded replication and galera may be interesting for you. Otherwise, there aren't that many differences. Having a real bug tracker is a nice thing when you need it. Here's a nice summary page regarding features: https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-features/ https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-features/
dubcanada 12y ago
MariaDB is moving pretty fast in regards to adding more modern features seen in other DB's. Such as JSON data type, NoSQL data engine interfaces, etc. As well as spending time working on the current data engines, such as Aria. While I believe MySQL is as well, it's hard to see progress/what exactly they are working on. Pretty much the main reason is Monty is working on MariaDB, not MySQL. And he's pretty amazing.
adwf 12y ago
Mostly because of Oracle. They already have a high performance database that they charge a whole lot of money for. All it'll take is a couple of poor earnings reports and they might swing the axe at MySQL as an easy scapegoat. Not something I'd like to risk my own company's database on.
- wuliwong 12y ago
  What about Postgres? I'm not a database expert, just wondering. Is MariaDB more of a one-to-one replacement for MySQL?
  - rat87 12y ago
    considering its a for of MySQL I'd say yes.
  - blueskin_ 12y ago
    MariaDB is a drop in replacement, as is Percona. PostgreSQL is a completely different database system, and is definitely preferable if starting from scratch, but migrating from MySQL to it can be a pain.
  - chc 12y ago
    Yes. Maria is a fork of MySQL, while PostgreSQL is an unrelated product aside from using a dialect of SQL.
blueskin_ 12y ago
* More active development * Slightly better performance IIRC * Not controlled by Oracle, who will likely kill off MySQL to promote their own database at some point in the not-too-distant future.
- falcolas 12y ago
  > * Not controlled by Oracle, who will likely kill off MySQL to promote their own database at some point in the not-too-distant future. To be fair, if they were going to do this, they wouldn't have invested the thousands of hours required to release 5.6, 5.7, Fabric, the mysql toolkit, etc. I've talked to the developers in person who work on MySQL, and they talk quite a bit about the future of MySQL. They have also acquired a number of MySQL based companies, and are committed to supporting them on MySQL.
  - blueskin_ 12y ago
    It's also possible (although I considered less likely until around now) Oracle will simply cut off support, new versions, and patches in the future unless you pay, and recent work on it has only been to reassure the existing customer base into not switching to MariaDB/Percona/Postgres.
    - falcolas 12y ago
      Given how simple it is to drop in MariaDB/Percona Server without changes, this wouldn't be a terribly sound strategy. A better strategy is the one they currently use - selling support tools (like Enterprise Support, Enterprise Monitor, and Enterprise Backup) to support the development. It never ceases to amaze me how much people will pay for these tools and services to support a OSS product.
- TylerE 12y ago
  I don't think so, but I do expect them to monetize the hell out of it (e.g paid support). It's the Oracle for orgs that can't afford Oracle.
- Roboprog 12y ago
falcolas 12y ago
As an alternative to this, I offer a reason to choose MySQL over MariaDB based on pure speculation: MariaDB has merged with SkySQL, who is a VC funded company. Being funded by VCs is not a bad thing in and of itself, but since most VC funded companies seek an exit strategy, it makes the stewardship of MariaDB at risk of being purchased by the next Sun or Oracle. In an ideal world (ideal for the future of MariaDB, that is), SkySQL would want to be acquired by Google or Facebook, but those two companies have thrown their lot in with MySQL by way of WebScaleSQL. Disclaimer, I work for Percona.
- tsuraan 12y ago
  MySQL is already owned by Oracle though, right? How much worse can it get?
  - falcolas 12y ago
    For people on MySQL, none. For people who chose MariaDB for philosophical reasons, much, much worse.
  - cwyers 12y ago
    I mean, say what you will about Oracle, they've put out some pretty good releases of MySQL, they've done some things I don't approve of but right now they seem pretty committed to improving the product. A lot of the stuff in this thread is speculation about what Oracle COULD do to MySQL, rather than anything they HAVE done.

That's enough right there. Being more open sourced means there's a lot less friction when trying to deploy and maintain your MySQL instance(s).

67726e 12y ago
A project being open-source has no bearing on whether or not it is easy to use and deploy.
- spindritf 12y ago
  Of course it does. Open source projects have a decent chance of being included in your distribution's default repositories. Popular packages will even usually be kept up to date. All that for free, with no effort on your part.
  - fedesilva 12y ago
    My experience tends to be that distro packaged software is not always what one ends up using in production. Except for some base packages when you start doing more sophisticated deployments. Distros may backport bug fixes and specifically security fixes but they tend to be several versions behind.
- devcpp 12y ago
  It does has a bearing on the ability to migrate to an alternative if it turns out to become awful, because someone will probably write an export script in that case. It's one of the big advantages of FOSS: no vendor lock-in.
- marcosdumay 12y ago
  Yes, it does. A software being open source means that you can deploy for any task in any environment, at any number, without the need to ask anybody's permission. It being proprietary means that you must ask permission first, and will probably need to keep each piece of software under control, under different terms.

kbar13 12y ago

MariaDB is more or less a drop-in replacement for MySQL. One reason (while being related to the potentially closed-source leanings of MySQL) is that you don't want to one day suddenly be cut off from performance and security updates because oracle.

viraptor 12y ago

If you're running replication, both multithreaded replication and galera may be interesting for you. Otherwise, there aren't that many differences. Having a real bug tracker is a nice thing when you need it. Here's a nice summary page regarding features: https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-features/ https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-features/

dubcanada 12y ago

MariaDB is moving pretty fast in regards to adding more modern features seen in other DB's. Such as JSON data type, NoSQL data engine interfaces, etc. As well as spending time working on the current data engines, such as Aria. While I believe MySQL is as well, it's hard to see progress/what exactly they are working on. Pretty much the main reason is Monty is working on MariaDB, not MySQL. And he's pretty amazing.

adwf 12y ago

Mostly because of Oracle. They already have a high performance database that they charge a whole lot of money for. All it'll take is a couple of poor earnings reports and they might swing the axe at MySQL as an easy scapegoat. Not something I'd like to risk my own company's database on.

wuliwong 12y ago
What about Postgres? I'm not a database expert, just wondering. Is MariaDB more of a one-to-one replacement for MySQL?
- rat87 12y ago
  considering its a for of MySQL I'd say yes.
- blueskin_ 12y ago
  MariaDB is a drop in replacement, as is Percona. PostgreSQL is a completely different database system, and is definitely preferable if starting from scratch, but migrating from MySQL to it can be a pain.
- chc 12y ago
  Yes. Maria is a fork of MySQL, while PostgreSQL is an unrelated product aside from using a dialect of SQL.

blueskin_ 12y ago

* More active development * Slightly better performance IIRC * Not controlled by Oracle, who will likely kill off MySQL to promote their own database at some point in the not-too-distant future.

falcolas 12y ago
> * Not controlled by Oracle, who will likely kill off MySQL to promote their own database at some point in the not-too-distant future. To be fair, if they were going to do this, they wouldn't have invested the thousands of hours required to release 5.6, 5.7, Fabric, the mysql toolkit, etc. I've talked to the developers in person who work on MySQL, and they talk quite a bit about the future of MySQL. They have also acquired a number of MySQL based companies, and are committed to supporting them on MySQL.
- blueskin_ 12y ago
  It's also possible (although I considered less likely until around now) Oracle will simply cut off support, new versions, and patches in the future unless you pay, and recent work on it has only been to reassure the existing customer base into not switching to MariaDB/Percona/Postgres.
  - falcolas 12y ago
    Given how simple it is to drop in MariaDB/Percona Server without changes, this wouldn't be a terribly sound strategy. A better strategy is the one they currently use - selling support tools (like Enterprise Support, Enterprise Monitor, and Enterprise Backup) to support the development. It never ceases to amaze me how much people will pay for these tools and services to support a OSS product.
TylerE 12y ago
I don't think so, but I do expect them to monetize the hell out of it (e.g paid support). It's the Oracle for orgs that can't afford Oracle.
Roboprog 12y ago

falcolas 12y ago

As an alternative to this, I offer a reason to choose MySQL over MariaDB based on pure speculation: MariaDB has merged with SkySQL, who is a VC funded company. Being funded by VCs is not a bad thing in and of itself, but since most VC funded companies seek an exit strategy, it makes the stewardship of MariaDB at risk of being purchased by the next Sun or Oracle. In an ideal world (ideal for the future of MariaDB, that is), SkySQL would want to be acquired by Google or Facebook, but those two companies have thrown their lot in with MySQL by way of WebScaleSQL. Disclaimer, I work for Percona.

tsuraan 12y ago
MySQL is already owned by Oracle though, right? How much worse can it get?
- falcolas 12y ago
  For people on MySQL, none. For people who chose MariaDB for philosophical reasons, much, much worse.
- cwyers 12y ago
  I mean, say what you will about Oracle, they've put out some pretty good releases of MySQL, they've done some things I don't approve of but right now they seem pretty committed to improving the product. A lot of the stuff in this thread is speculation about what Oracle COULD do to MySQL, rather than anything they HAVE done.