Tuesday, April 27, 2010

From Behind The Ash Curtain

Like many other MySQL conference visitors, also Codership team was stranded in bay area due to the volcano eruption in Iceland. For us however, the extra time in silicon valley was not an issue, as we were working on local assignments anyways, and staying local enabled us to work really focused during this period.

Also the "evacuation" from SFO worked out really well for us, thanks to KLM and Air France. We just visited SFO on Thursday (22) and got flights for the next morning. I actually got two bookings, which was a little embarrassing. There were many empty seats and especially the CDG-HEL leg was practically empty. Ash refugees had already left by train, I guess.
The return from SFO happened somewhat too early for us, as we had holiday plans for the forthcoming weekend, and we had to cancel the fun part. So this trip ended up as all work and no joy for us...

The conference itself, was fun and very interesting. We were busy first to prepare our presentation, then giving the presentation and finally sorting out mis-conceptions caused by the presentation. But it was fun altogether, and Galera got a lot attention there. We had many interesting conversations of Galera and replication strategies in general.
To my disappointment, the expo hall was half empty, I'm not sure if this can be profitable and it makes me wonder of the future of this conference.

On Fri 16th, there were both Drizzle and MariaDB conferences, which we planned to visit but were too busy to catch. We wanted to sort out the differences between the Drizzle replication API and wsrep API in very detail, but this work must be postponed a little.
We, however, entered MariaDB conference just when they were closing, and hooked into short replication discussion with Kristian Nielsen, Sergei Golubchik and Paul McCullagh. MontyProgram is driving the Replication API design and implementation and we don't need to work inside MariaDB code base. Codership will just provide Galera plugin for the end solution.

Paul brought to my attention an interesting fact about PBXT: rollback is low effort operation with PBXT. This is very favorable for Galera replication (and optimistic concurrency control in general). Odds are that PBXT will scale better in Galera cluster, even with hot spot work loads.

Slides of our presentation are available here: http://en.oreilly.com/mysql2010/public/schedule/detail/13286

Saturday, March 20, 2010

Codership Visit in O'Reilly MySQL Conference

O'Reilly MySQL Conference & Expo 2010
I will be presenting Galera replication in O'Reilly MySQL Conference & Expo on April 14. Here is the link to the presentation abstract:
Galera - Synchronous Multi-master Replication For InnoDB.
The presentation will be run jointly with Alexey Yurchenko and will focus mostly in the practicalities of managing Galera cluster, like:

  • Howto download and install MySQL/Galera cluster

  • Configuration options, clustering use cases and topologies

  • Managing Galera cluster, joining node(s) in cluster, backups etc...

  • Application connectivity options

  • Monitoring Galera cluster, troubleshooting best practices

This presentation will give in a nutshell all you need to know to start using Galera cluster as your application's data redundancy solution.
We plan to arrange a somewhat extended trip in Bay area, so we will have spare time for ad-hoc meetings. If you would like to have a f2f meeting with Codership team, just get it touch. We can arrange Galera demonstrations / presentations, or .e.g. analyze your use case in detail showing how Galera works for your application load.

See you in Santa Clara!

Thursday, February 11, 2010

For Those About to Galera - We Salute You!

Two new Galera presentations are available for downloads. First is from the ever famous
FOSDEM 2010 conference in Brussels, where I visited the MySQL Developers' room and
presented a 20 minute overview of Galera project. This presentation contains new 100% insert rate benchmark and synchronous WAN replication test results. Get your copy from here.

Yesterday, we presented Galera replication in MySQL University session. The focus of this webinar is to describe our replication API (wsrep API) and our patch in MySQL source code to support the API. This is MySQL oriented and quite technical presentation. The session was recorded and you can play it in MySQL University site: Galera presentation. The plain presentation slides (without disturbing narration), are also available in Codership site

Thanks for all the feedback! If your comment/question looks to have public interest, don't hesitate to post in our mailing list
We are working now for 0.7.3 release, and will publish in very near future (we look to squeeze MySQL 5.1.43 merge and "LOAD DATA LOCAL..." support still in the package). To ease the installation, we have also debian and RPM packages coming soon. They are needed for our very first cloud image, we are working on.

Thursday, January 14, 2010

MySQL/Galera 0.7.1 Released

MySQL/Galera release 0.7.1 ships out.

This is a maintenance release, which has fixes for 9 issues, listed in launchpad release page:


It makes sense to upgrade, if you suffer from any of the above.

Most notable changes are perhaps fixes for running concurrently DDL and DML queries. The MySQL version has also been bumped two notches up to 5.1.41

Prebuilt binary downloads are available, as usual, in the launchpad site:
Pay attention to pick the latest 0.7.1 version, as launchpad seems to give precedence for the old 0.7 release (no matter how hard I try to configure LP...).