Archive for the ‘MySQL’ Category

FOSDEM MySQL & Friends Devroom

Barbar at Delirium in Brussels. Thousands of beers in-store!As Frederic posted, its time to submit talks for the MySQL & Friends Devroom at FOSDEM 2014. The next year, it will be on Saturday February 1 2014. I look forward to being in Brussels again, and I hope to see you there too.

Submit to the MySQL track here, and don’t forget to be there on Friday evening for the start of the beers. I’m told by Frederic & Kenny that we’re likely to have a much more interesting community dinner since things are getting larger year by year. See you at FOSDEM and remember, submit talks!

MySQL 5.6 system variables in the MariaDB 10 server

Since MariaDB aims to be a compatible/drop-in replacement to MySQL, its crucial that in 10.0 we support all the 5.6 options/system variables, else we have to clearly document them in the Knowledgebase article MariaDB versus MySQL – Compatibility.

To this extent, Sergey Vojtovich (svoj) has created MDEV-5277 as a tracker. There is also plenty of discussion on this topic at the maria-developers mailing list. I encourage current users of MySQL 5.6 to take a look at the list and comment either in Jira or on the mailing list to ensure that when we are ready for MariaDB 10.0, we cover what you’re using.

MariaDB 10.0.5 storage engines – check the Linux packages

Today before Ivan’s tutorial, he told me that in the 10.0.5 virtual machine images he created, he couldn’t find the Cassandra storage engine. I told him it had to be installed separately, and this is true – you have to install some engines separately!

When you do a yum install MariaDB-server MariaDB-client like the installation instructions tell you to do, you don’t get all storage engines (so running SHOW ENGINES might have you wondering what happened to a bunch of engines). This can easily be seen by doing a yum search MariaDB. On a CentOS 6.4 server with the MariaDB 10.0 repository configured, you should see the following:

MariaDB-cassandra-engine.x86_64 : MariaDB: a very fast and robust SQL database server
MariaDB-client.x86_64 : MariaDB: a very fast and robust SQL database server
MariaDB-common.x86_64 : MariaDB: a very fast and robust SQL database server
MariaDB-compat.x86_64 : MariaDB: a very fast and robust SQL database server
MariaDB-connect-engine.x86_64 : MariaDB: a very fast and robust SQL database server
MariaDB-devel.x86_64 : MariaDB: a very fast and robust SQL database server
MariaDB-server.x86_64 : MariaDB: a very fast and robust SQL database server
MariaDB-shared.x86_64 : MariaDB: a very fast and robust SQL database server
MariaDB-test.x86_64 : MariaDB: a very fast and robust SQL database server

So to get Cassandra or CONNECT engine support, don’t forget to install MariaDB-cassandra-engine and MariaDB-connect-engine.

Once you do that, don’t forget to actually load the engines – for example you do something like INSTALL SONAME 'ha_spider.so';.

In fact, why not check out what plugins exist in /usr/lib64/mysql/plugin? You can also see this from the MariaDB monitor: SHOW PLUGINS SONAME;. This shows active and non-installed plugins as well. Read the documentation for SHOW PLUGINS SONAME.

MariaDB now in the AWS Marketplace

Saw this on @awsmarketplace the other day:

Now on the AWS Marketplace, you can get MariaDB 5.5.32 on Ubuntu 12.04, CentOS 6 and Debian Wheezy. These are eligible for the Amazon free tier as well.

Would love to see people use this and to provide feedback. Do we need to expand this to offer Cassandra integration so you can spin up a basic cluster and get it going? Would you love to see this integration with Galera Cluster?

Much thanks to SkySQL for making this possible.

MariaDB in Debian unstable

There is a Debian MariaDB plan from the MySQL package team. There is good news as on September 30 2013, the upload to Debian unstable is complete with MariaDB 5.5 (5.5.32). It’s now only a matter of time before this becomes available in Debian. 

Its great to see the work of Otto Kekäläinen finally make it into Debian. I would say this has been in the works for seven months. Much thanks to James Page (Canonical) and Clint Byrum (HP, Debian Developer) for reviewing and uploading.

This joins the stable of packages that are already maintained by the Debian MySQL package team. 

Upcoming MariaDB/MySQL events: Tokyo, Buenos Aires

To bring to attention those who will be in Tokyo, Japan or Buenos Aires, Argentina:

  1. MariaDB/MySQL Community Event – 9 October 2013 – Tokyo, Japan. Come see Michael Carney, Ivan Zoratti, Kentoku Shiba (creator of the SPIDER storage engine) and Colin Charles at this event. It is from 12.30pm – 8pm, and includes evening cocktails to some extent. It should be free to attend.
  2. MySQL NoSQL Cloud – 15-16 October 2013 – Buenos Aires, Argentina. This is the second such conference happening in Buenos Aires, and this time there are plenty of speakers who didn’t make it around the first time. Cost is nominal.

i