Hacker News Reader

Comment by 127001brewer | Hacker News Reader

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

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.

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.

What about Postgres? I'm not a database expert, just wondering. Is MariaDB more of a one-to-one replacement for MySQL?

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.

Yes. Maria is a fork of MySQL, while PostgreSQL is an unrelated product aside from using a dialect of SQL.

considering its a for of MySQL I'd say yes.

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.

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.

MySQL is already owned by Oracle though, right? How much worse can it get?

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.

For people on MySQL, none. For people who chose MariaDB for philosophical reasons, much, much worse.

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/

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).

A project being open-source has no bearing on whether or not it is easy to use and deploy.

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.

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.

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.

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.

* 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.

> * 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.

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.

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.

My personal pet conspiracy theory is that Oracle needs to continue to propagate MySQL as the "first one's free", not-quite-good-enough database, so they can provide an easy migration from MySQL to Oracle when your app outgrows MySQL.

I'm guessing there is a sizable slice of applications that would find PostgreSQL to be "good enough", and not need to buy Oracle subsequently.

Perhaps that's just paranoid, and Oracle is running MySQL out of the goodness of its corporate heart?

>so they can provide an easy migration from MySQL to Oracle when your app outgrows MySQL.

Based on personal experience, when databases hit that point, the logical next step is PostgreSQL if you're going to go through the pain of changing database engines. Or just do what $oldjob did and throw more and more resources at MySQL (256GB memory, anyone?).

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.

Reply on news.ycombinator.com