Archive for the ‘Databases’ Category

SPIDER in MariaDB

One thing you might have missed from the MariaDB 10.0.4 Alpha release announcement is that SPIDER is finally in-tree, inside MariaDB. I’ve been watching the SPIDER engine for quite some years and fondly remember the time when Kentoku Shiba dressed up as spiderman at a MySQL Conference.

There are many factors that plays to an engines success. Distribution is one of them. Having a company backing it with services is another, so it is with great pleasure that I also show you Spiral Arms Ltd by Kentoku and Goto.

Overall, a good time to celebrate and I’m very happy for Kentoku and Goto. Now to promote its use. There’s a lot of dated resources that we need to get back up to speed with, so I expect that in time the Knowledgebase entry will well populated.

Some MariaDB related news from the Red Hat front

This is a followup to my early post a month ago titled: MariaDB replaces MySQL in RHEL 7 (lots of stuff in the comments). It’s clear that MariaDB’s role is in Software Collections, which is new in RHEL.

Steven J. Vaughan-Nichols writes Red Hat will switch from Oracle MySQL to MariaDB, reports.

Sean Michael Kerner has a video (and writeup) with Denise Dumas, RHEL team leader, who talks about Software Collections, MariaDB, and how we’re all friendly (Red Hat + SkySQL + MariaDB). There will be 3 years of support for Software Collections. Indemnification applies as always, its just support cycle per collection is reduced. New MySQL ships in Software Collections too. Its available for 6.4/6.5 (probably as a GA as its beta now), and will be in RHEL7 too.

Also, if you’re using OpenShift, there is now a new cartridge: the OpenShift MariaDB Cartridge.

Thanks Oracle for fixing the GPL man page issue

Timing is everything. I wrote about how MySQL man pages were silently relicensed away from the GPL. It was picked up by a lot of sites: Hacker News, Slashdot, LWN, and probably more. That led to a bug report in Debian (#712730) to complain that MySQL is no longer compliant with the Debian Free Software Guidelines (DFSG). That prompted Norvald Ryeng who’s active in Debian (thanks Oracle!) to file MySQL bug #69512. Almost immediately Oracle said it was a bug, where Yngve Svedsen pointed to the buildsystem: “This is indeed a bug, where the build system erroneously and silently started pulling in man pages with the wrong set of copyright headers.” That then prompted Tomas Ulin to write about how The MySQL Man Pages ARE Available under the GPL. Case closed, many on Hacker News attributed it to Hanlon’s razor. Most news sites updated it with the bug, and The H also wrote an article: Oracle bug accidentally removes GPL licence from MySQL man pages.

We learned about this issue from MariaDB Jira and spent some time looking at it. We looked at the MySQL source tarballs, and looked at 5.5.30/5.5.31/5.5.32. This issue is present in a release since 18 April 2013 (5.5.31) and a subsequent release on 3 June 2013 (5.5.32). What is clear is that this also affects 5.1, 5.6, and 5.7. This has been an issue for about two months.

So this issue is written off as a bug. Great. Its fixed because it was noticed. It’s noticed not because it was just reported in the bugs system, but because there was a huge amount of traffic around it. While Tomas might say, “Reporting a bug is always a good way to communicate with us,” I doubt this would have been fixed in record time any other way. Also, I don’t need to rehash all the issues with the public bugs system.

I’m not about to start conspiracy theories here because that isn’t my goal. Our frame of mind since last week’s RHEL Software Collections news has been focused on documentation as well. Sheeri Cabral, an Oracle ACE Director, has had a rather interesting conversation on Twitter about our documentation. man pages aside, we’re improving documentation tremendously, and have over 2,700 articles in the Knowledgebase.

One thing is for sure with Oracle as steward for MySQL: the public perception of Oracle isn’t at its best and generally no one assumed this to be an accident.

Now let’s focus on something celebratory and positive: MySQL (NDB) Cluster 7.3 is now a GA. I’m excited by the node.js connector and the auto-installer. Can’t wait to give it a try. Congratulations all round to the Cluster Team at Oracle.

MariaDB replaces MySQL in RHEL7

mariadb: made by geeks used by professionalsSubject says its all, this is of course, very good news coming out of the Red Hat Summit. Looking forward to Red Hat Enterprise Linux 7. And of course, CentOS 7 and the other builds that follow. Thank you Red Hat!

MariaDB 10.0.3: installing the additional engines

So MariaDB 10.0.3 Alpha is out. Download it and remember to provide feedback.

When you run SHOW ENGINES by default, you don’t get CassandraSE or the CONNECT engine. Make sure you do a yum install MariaDB-cassandra-engine and a yum install MariaDB-connect-engine

You will run into conflicts if you had an older MariaDB-CassandraSE engine (so yum remove MariaDB-CassandraSE).

Once you’ve got the packages installed, you can either install the plugin or just restart mysqld.

Happy testing!

Homebrew (Mac OS X) and MariaDB 10.0 series

Today I performed a brew update. I noticed that MariaDB now exists as stable (5.5.30) and devel (10.0.2). Brew formulas also exist for MySQL (5.6.10) and Percona Server (5.5.30-30.2) now. 10.0.3 is around the corner but I wanted to run 10.0.2 now. This is how I did it:

brew unlink mariadb
brew install --devel mariadb

It’s that simple!


i