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 7/10/2013, 11:42 pm,
by Colin Charles,
under
Tech.
Today I faced something weird:
byte@lovegood~$ brew update
error: RPC failed; result=22, HTTP code = 400
fatal: The remote end hung up unexpectedly
Error: Failure while executing: git pull -q origin refs/heads/master:refs/remotes/origin/master
I ran the brew doctor to find out my git version was outdated. Turns out you need “Git 1.7.10 or newer is required to perform checkouts over HTTPS from GitHub.” I had 1.7.2.2! Upgraded it to 1.8.3.2 now and all is well.
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.
