Archive for the ‘Databases’ Category

Using MariaDB on CentOS 6

This is just for testing purposes, but you might want to play around with MariaDB 5.5.29 coming via the CentOS 6 repositories as mentioned in this post. Please test it out and report bugs if required. The process was simple on a fresh install:

yum update
cd /etc/yum.repos.d/
wget http://dev.centos.org/centos/6/mariadb/mariadb.repo
yum list mariadb\*
yum install mariadb-server mariadb
/etc/init.d/mysqld start

That’s it, it just works. It comes with MEMORY, CSV, MRG_MYISAM, BLACKHOLE, MyISAM, PERFORMANCE_SCHEMA, ARCHIVE, FEDERATED, InnoDB (XtraDB) and Aria.

Remember this replaces mysql-libs, and is set to replace MySQL in your install. Here’s hoping it hits mainline CentOS soon.

SkySQL Solutions Day, FOSDEM MySQL activity

February is turning out to be a busy month. I’ll be giving a talk about MariaDB at the SkySQL Solutions Day in Hamburg, alongside Sergei Golubchik. This happens February 1 2013.

I’ll also be in Brussels for FOSDEM and presenting at the MySQL & Friends devroom. Here I will talk about MHA and how you can get automated MySQL failover. I’ll also be hanging out at the CentOS booth with Karanbir Singh giving away MariaDB stickers all weekend. If you’re at FOSDEM, don’t forget to sign up for the MySQL Community Dinner on Saturday night! Naturally, Friday’s beer activity is something I’ll be at too.

Busy long weekend ahead!

MHA 0.54 & 0.55 – continually active development

I think it’s worth noting that since January 2012 there was no changes to MHA (0.53). Yoshinori Matsunobu made two releases in December (release notes), one in time for my Percona Live London 2012 talk. Thanks Yoshi! Totally download MHA 0.55 which is still be actively developed & used in production at multiple locations.

A few great weeks for MariaDB

I think MariaDB has had a great few weeks recently and the timeline of these events are important.

  1. 27 November 2012 – WiredTree Adds MariaDB for Faster MySQL Database Performance (well worth reading their motivations to switch)
  2. 29 November 2012 – Monty Program & SkySQL release the MariaDB Client Library for C & Java
  3. 4 December 2012 – MariaDB Foundation is announced, see ZDNet coverage.
  4. mid-December 2012 – Wikimedia Foundation starts migrating Wikipedia to MariaDB, not for any other reason besides the fact that the Foundation was announced (more ZDNet coverage).

Now, there have been rumors that the client libraries are just rip-offs or relicensed. They are not. They’ve been in works for customers for several years now (yes, Monty Program does need to pay the bills), and there are many a feature difference. This will be addressed next week to ensure that people know what they’re getting.

There have also been rumors that the foundation was announced with regards to the connectors. Wrong again. Connectors were announced first, foundation came later (see timeline above). You don’t do these things in a span of one week, the talk for the foundation has been going on for months. I should know, as alongside Monty & Rasmus, I’ve been somewhat involved.

I agree that we need better communications (remember to like us on facebook, follow us on twitter @mariadb), and we’re working on it. Its also that time of year when people love to take vacations (I am one of them). All that said, watch http://blog.mariadb.org/ closely as that’s the official channel for all things MariaDB.

2012 has been a great year for MariaDB in general, as the project grows, we get more coverage (see news reports), unparalleled downloads thanks to our 5.5-series being released, and our expanding product lines. I can forsee 2013 being even more exciting. Thank you all for an amazing 2012.

Happy new year and here’s to a great 2013!

Trip report: Tech Planet 2012

I’ve had many dealings with SK Planet, in South Korea, so when they asked me to speak at their inaugural Tech Planet, I jumped at the opportunity. I was already pre-given a topic titled “NewSQL”, so I talked about the evolution of SQL -> Big Data -> NoSQL -> NewSQL, all thanks to papers written by Google research, and then focused on how MySQL & MariaDB is gaining many new interfaces: mariasql, HandlerSocket, dynamic columns, memcached InnoDB plugin, node.js with NDBCLUSTER, CassandraSE, LevelDB, Galera Cluster and more. This is a topic I will talk more about later.

Tech planet 2012The event was great. It started with a speaker’s dinner in where the CTO of SK Planet & multiple VP’s dined with the speakers. We had a private room at the InterContinental COEX, and started with smoked salmon, Russian crab meat & cream cheese. This was followed on quickly by crab meat soup. The main course was beef tenderloin, mero fish & steamed black rice, asparagus and black garlic. We ended with a cranberry tian with raspberry sauce. This was filled with lots of Equus red wine. 

Tech planet 2012The next day, we had the day of the event itself and it was huge. There were probably over 800 attendees, and SkySQL had a booth maintained by the Korean partners: OSS Korea, PrixMedia, and Oh New Innovation. This was followed by lunch with the CEO of SK Planet with great conversation & food. Started with tuna & avocado, to clear the palate, some lemon sorbet, and a great main consisting of beef tenderloin & king prawn with red wine sauce. We had much to chat about, and as lunch came to a close, it was time for me to give my talk.

It was well attended, there were some good questions, and there are naturally some good action items. I’m glad that the whole ecosystem provided me multiple opportunities to talk about amazing work being done. The press covered the Tech Planet event. I managed to snag an interview as well. More photos of the event at my techplanet2012 tag on Flickr.

All in, an exciting space to be in now. Thank you so much for SK Planet for the invite, and I look forward to being around in 2013.

Percona Live Santa Clara 2013 tutorial schedule out

I didn’t participate in 2012, but in 2013, I’m back on the conference committee for Percona Live Santa Clara. We have an awesome Program Chair in Shlomi Noach, and after much deliberation & commentary, we have a tutorials schedule out now. Expect that the rest of the conference content to be awesome too. Remember, April 22-25 2013 are the magical dates, so register now!


i