News for hackers. Stuff that matters.
Re:Making MySQL Better at GitHub by Thaxll on Tuesday September 02, 2014 @04:46PM (#8260045)
Why won't you use the Oracle version? atm MariaDB isn't a replacement for the stock version of MySQL.
Re:Making MySQL Better at GitHub by toomuchtodo on Tuesday September 02, 2014 @04:56PM (#8260100)
MariaDB is a drop-in replacement for stock MySQL. It's performance is actually better than MySQL.

https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibi...

Re:Making MySQL Better at GitHub by icot on Wednesday September 03, 2014 @06:04AM (#8262235)
I would suggest that anybody interested in performance test these claims in their own setup. I ran tests doing binary swapping binaries when the releases of both were around 5.5.34 and in my case MySQL CE had between 10%-15% better performance.

When I ran the tests for MariaDB 10.x and MySQL CE 5.6.x the advantage even went further for MySQL with around 20% better performance.

I find always funny how with every release you can get opposing claims from each camp regarding performance.

Re:Making MySQL Better at GitHub by stock_toaster on Wednesday September 03, 2014 @01:49AM (#8261675)
Not quite drop in. We have had a couple particularly wonky update statements with nested subqueries that ran on mysql, but only produced an error on mariadb.
Re:Making MySQL Better at GitHub by Thaxll on Tuesday September 02, 2014 @05:08PM (#8260166)
MySQL has years of proved stability, the performance is BS, one graph means nothing, it's like all the people saying they're running thousands of QPS on a server, you just don't know the benchmark and the type of queries running. I can run 3k SELECT in cache...

I'm sure one day MariaDB will replace stock MySQL but clearly it's not ready yet.

btw Oracle is doing a good job with MySQL atm.

Re:Making MySQL Better at GitHub by heavenlyhash on Tuesday September 02, 2014 @05:57PM (#8260413)
My bets are all squarely on MariaDB. MySQL under Oracle is stymied by conflicts of interest.

One concrete example is hashjoins, a fairly simple and efficient strategy for many general purpose workloads: MariaDB supports hashing as a join strategy since 5.3/5.5 [1] back in 2011. MySQL, to the best of my knowledge, still lacks any implementation of this. OracleDB, of course, supports hash joins. Oracle has every incentive not to implement hash joins in MySQL because hash joins are one of the performance features that they use to drive sales of OracleDB.

[1] https://mariadb.com/kb/en/mariadb/what-is-mariadb-53/#join-o...

Re:Making MySQL Better at GitHub by sjwright on Tuesday September 02, 2014 @06:02PM (#8260437)
> Oracle is doing a good job with MySQL atm.

Obvious troll is obvious.

> the performance is BS

We're extremely happy with our "BS" performance.

Re:Making MySQL Better at GitHub by spudlyo on Tuesday September 02, 2014 @07:38PM (#8260789)
Obvious troll is obvious.

MySQL professional here. I'm quite pleased with Oracle's 5.5 and 5.6 releases, and feel that they're doing a pretty good job. While they've not been perfect stewards, I feel they have done better than Sun -- perhaps you don't remember the fiasco that was the 5.1 release?

I don't feel that this is a trollish opinion. Mark Callaghan, a MySQL luminary who has done a lot of excellent work for the community also has positive things[0] to say about Oracle's stewardship of MySQL.

[0] https://news.ycombinator.com/item?id=7483079

Re:Making MySQL Better at GitHub by viraptor on Tuesday September 02, 2014 @08:16PM (#8260897)
Yes, they're ok-ish. But the original claim was "MariaDB isn't a replacement for the stock version of MySQL".

Actually yes, it is. It doesn't work the other way around (for example timestamp column has a different description, so dump cannot be loaded into MySQL). But you can use MariaDB in place of MySQL and there should be no performance degradation, since they come from the same codebase.

Reliability was mentioned too - in that case Oracle actually failed by holding back tests. In MariaDB you can reproduce testing if you want. In MySQL not anymore.

Re:Making MySQL Better at GitHub by jeremycole on Tuesday September 02, 2014 @09:04PM (#8261047)
No, not really. MariaDB is completely dependent on Oracle and Percona. While they are doing some good work, they are by no means a complete and independent fork, nor do they have the resources to be.

MariaDB is also impacted by the lack of tests, they are absolutely not making replacements for all those tests, and they continue to pull code from upstream. So, same problem there.

Re:Making MySQL Better at GitHub by sjwright on Wednesday September 03, 2014 @09:14PM (#8266306)
This might have been true in 2011-12, but today MariaDB is demonstrably NOT dependent on Oracle or Percona. If both disappeared tomorrow, it would still continue.

The fact that they continue to "pull" some code is because they're not idiots, and aren't going to duplicate effort. As far as I'm aware, they are now being very selective about what they pull.

Calling Oracle an "upstream" is a joke. They aren't publishing atomic changesets, which also means the Oracle fork of MySQL is no longer a morally Open Source software program.

MariaDB is NOT impacted by some vaporous lack of tests. They are building tests for every change they're making. As for the tests privately held by Oracle, well, those tests don't help anyone because they're not public and don't enjoy public scrutiny. Who knows if they're even running them?

Re:Making MySQL Better at GitHub by sjwright on Wednesday September 03, 2014 @10:34PM (#8266501)
> nor do they have the resources to be.

They have received large investments from companies like Intel, and have been granted extensive engineering (and probably financial) help from companies like Google and Facebook. Probably many others. And they have most of the MySQL brains-trust in their employ, Monty most famously. I don't know how anyone could argue they're under-resourced for the task of maintaining and improving a mature product.

Compare that with Oracle, who pulls dangerous stunts like this: http://ronaldbradford.com/blog/when-is-a-crashing-mysql-bug-...

Re:Making MySQL Better at GitHub by spudlyo on Saturday September 06, 2014 @12:59PM (#8278784)
I don't know how anyone could argue they're under-resourced for the task of maintaining and improving a mature product.

You mean Jeremy Cole, the guy you're arguing with, who led the effort at Google to standardize on MariaDB[0], who worked for many years with Monty at MySQL AB and who is a recognized leader in the MySQL community?[1] Fuck that guy, I have no idea how he could have such an opinion.

[0]: http://www.theregister.co.uk/2013/09/12/google_mariadb_mysql...

[1]: http://openlife.cc/blogs/2013/april/mysql-community-awards-2...

Re:Making MySQL Better at GitHub by sjwright on Wednesday September 03, 2014 @09:07PM (#8266277)
I agree, Oracle aren't terrible stewards of MySQL, but that's not my point. Yes 5.5 and 5.6 are good releases. MariaDB 10 is an even better release and shows that Monty has still got value beyond what any large corporation can provide.

I know for a fact that if we were forced away from MariaDB back to stock Oracle MySQL releases, we'd have to expand onto more slaves and fix queries that are no longer optimized.

Re:Making MySQL Better at GitHub by sjwright on Tuesday September 02, 2014 @05:57PM (#8260417)
Our experience switching from Oracle's MySQL to MariaDB was a solid improvement in performance -- particularly on certain queries where MariaDB's superior query optimizations kick in.

We've also migrated many tables to TokuDB storage engine, and seen phenomenal improvements in performance and scaling. It's so good we were able to de-partition and de-archive our largest tables with no performance penalty.

If you haven't tried MariaDB yet, try it.

If your database is reasonably large (10GB+) and you haven't tried TokuDB yet, TRY IT.