RLASKEY::words

Tag Archives: MySQL

Big News: TokuTek, SkySQL

Lots of movement in the MySQL and MariaDB universes this week, neither of which I could have predicted.

First, TokuTek announced yesterday that TokuDB is going open source, as GPLv2. There will be an Enterprise Edition as well, but their fractal tree indexes will be out in the open. I’ve not personally used TokuDB, but it’s very solid technology and this move will open up a lot of opportunities in the open source world.

Today, SkySQL has announced a merger with Monty Program Ab, the people behind MariaDB. Clearly this is a win for both sides, and to me it both improves the open source movement behind MariaDB as well as creates an even more formidable alternative to Oracle. I’ve personally switched all my projects from MySQL to MariaDB, and I’ve been very happy with the decision.

common_schema: MySQL Security

from Shlomi Noach. Very cool set of functions to audit your MySQL users and grants. It’s worth installing on your DB and running once or twice. It’s very easy to do, as you only need to download and import the SQL file, which creates its DB with various functions and views.

MySQL Command Line

from the MySQL Performance Blog — Be productive with the MySQL command line. Good article, with a few easy things worth knowing.

RT @xaprb: Thoughtful MySQL-vs-PostgreSQL comparison on Planet PostgreSQL. ledgersmbdev.blogspot.com

Moving to MariaDB

I took another look at MariaDB after listening to OurSQL #89, Seal of Approval — a greatly named podcast, since the MariaDB logo is a seal, from the MySQL dolphin. The big, big news for MariaDB this year is that they have their own YUM and APT repositories, which makes it so much easier to transition from the stock MySQL packages to MariaDB.

I’ve been using MariaDB for a few months now, and my feeling is that at this point there’s no real reason not to use it. It’s fast, current, and it integrates beautifully with everything that MySQL does. The other perk is that even on older distributions you can be running 5.5, which is an upgrade from the 5.1 found in most distribution repositories.

Common Schema: Incredible!

I’d heard reference to common_schema for a bit, but neglected to really look into it for a few months. BIG mistake. It is an elegant solution that can save a lot of time with almost no effort to install. It is a simple, single SQL file download, which you source, which creates table called common_schema with a whole lot of magic in it.

There is a lot of great documentation, which details the various things that common_schema can do. There’s also a great video from Percona Live 2012 which clocks in at 47 minutes but is worth all of them. You can write some interesting queries with QueryScript, but also use the various functions to keep your data organized, and to do work programmatically, rather than tediously. Good stuff! I am very excited to now have this in my tool belt.