Posted on 11/11/2013, 11:33 am, by Colin Charles, under
MariaDB,
MySQL.
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.
Posted on 15/10/2013, 9:54 am, by Colin Charles, under
MariaDB,
MySQL.
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.
Posted on 5/10/2013, 10:10 pm, by Colin Charles, under
MariaDB,
MySQL.
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.
Posted on 5/10/2013, 9:48 pm, by Colin Charles, under
MariaDB.
Updated: Thu Oct 26 16:48:31 +08 2017 – the link has changed as the domain has expired.
Now that Monty Program is no more, we don’t have the Hacking Business Model to govern how we work. I wanted to reference it recently and asked Daniel Bartholomew and Bryan Alsdorf, and they’ve managed to put it up online at a new domain to ensure it will always live on: The Hacking Business Model. It will live on at http://hbm.mariadb.org/.
Posted on 4/10/2013, 11:38 am, by Colin Charles, under
MariaDB,
MySQL.
To bring to attention those who will be in Tokyo, Japan or Buenos Aires, Argentina:
- 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.
- 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.
Posted on 4/10/2013, 11:37 am, by Colin Charles, under
MariaDB,
MySQL.
I just wanted to collect the links of the Google and MariaDB relationship. These were all items in September 2013.
The Register: Google swaps out MySQL, moves to MariaDB – this was largely based on a presentation at SLAC by Jeremy Cole (slides). Same news was picked up by ReadWrite (with a different angle naturally), Google Waves Goodbye To MySQL In Favor Of MariaDB.
If you’re more audio inclined, there was great discussion on the This Week in Google podcast: checkout episode 216.
