Galera Cluster 2.1 Release Rolling Out

Galera Cluster release 2.1 has been published.

This is a maintenance release and includes the new Galera Replication library version 2.1 and corresponding MySQL server releases for both MySQL 5.5.23 and MySQL 5.1.62 versions. The replication API version is still at version #23.

The 2.1 release has a number of fixes in Galera replication and MySQL provider layers, including:

• fixes for foreign key support (with 5.5.23 release only)
• fixes for incremental state transfer
• support for wsrep_sst_method=skip to avoid performing any state snapshot transfer during node joining
• wsrep_urls configuration variable to specify a list of known cluster nodes where node should try to connect during startup
• supporting MySQL replication filters

...to name but a few, a comprehensive list of bug fixes can be browsed in launchpad bug trackers (Galera 2.1, MySQL 5.5.23-23.6, MySQL 5.1.62-23.4).

The 2.1 release is backwards compatible with earlier releases, and rolling online upgrade for the Cluster is possible.

Downloads can be reached at downloads page as usual.

Galera Cluster Support and Consulting Services from CAPSiDE

CAPSiDE and Codership have joined forces to offer Galera Cluster related support and consulting services for the fast growing Galera user community.

CAPSiDE now offers the Galera Cluster technology, including the consulting services and support,in partnership with the Codership's development team. This cooperation sums up years of experience and proven track record of deploying large online platforms with the highest requirements on stability, high availability, performance and cost efficiency. CAPSiDE's services are offered to all Spanish speaking countries (Spain and South America), including all levels of professional support in Spanish and English.

CAPSiDE has years of competence in MySQL consulting and support. They have a deep understanding of clustering and replication technologies and how to implement them into production. They are experts in MySQL performance, availability and scalability. CAPSiDE also has wide experience on cloud environments, being able to now offer active-active MySQL clusters with the Galera technology on Amazon Web Services (AWS EC2), RackSpace Cloud, Xen environments, VMWare and Microsoft Hyper-V platforms, apart from physical environments. CAPSiDE is the perfect partner for Codership.

About CAPSiDE

CAPSiDE is a Systems Engineering company specialized in technological consulting and professional services, counting with expert engineers about high availability systems, networks and software developing.
Founded in the year 2001, CAPSiDE has wide experience on design, deployment and hosting platforms for complex applications and critical purpose Systems.
CAPSiDE counts between its clients with some of the main operators and communication groups in Spain that trust CAPSiDE’s professional team for the design, deployment and/or operation works in their critical purpose systems and data center services.

Galera 2.0beta - node joining with incremental DB synchronization

Galera replication 2.0 beta has been released, get your download in https://launchpad.net/galera/2.x/22.2.0beta

This release comes only with Galera library build, there are 64bit DEB and RPM packages available for download. To test Galera 2.0 replication, install the beta library in Galera cluster 1.1 and you are ready to go (wsrep API version #22 is required).

Galera 2.0 has as a new feature incremental state transfer (IST). Earlier Galera cluster behavior was to always copy full database to new joining node. With IST, the previous state of joining node is taken in consideration, and only the delta of missing transactions will be transferred and applied in joining node. Applications having big database, will experience a great performance boost with node join operations.

The beta cycle is expected to continue for a few weeks and is then followed by 2,0 GA release, stay tuned.

Galera Cluster Release 1.1 - Out She Sails

Galera release 1.1 has been published and rolled out in the open!

This release has a bunch of bug fixes and one prominent new feature: rolling schema upgrade. With rolling schema upgrade, it is possible to apply schema changes (DDL statements e.g. CREATE, DROP, ALTER, etc...) for each cluster node separately. The node to be upgraded is a member of cluster but is not applying replication events as long as the DDL statement is processing. With this, the cluster can stay in production due out the schema upgrade process. I will write a more detailed description how it works in a separate blog.

The 1.1 release uses new version of replication API: wsrep API #22. This means that both MySQL and Galera components must be upgraded with same go.

Galera release 1.1 is available for downloads: here. There are separate versions both for MySQL 5.5.17 and MySQL 5.1.59.

Oli wrote an excellent blog about howto upgrade Galera from 1.0 to 1.1 level in: FromDual blog. While landing on FromDual site, check out Oli's other blogs as well, plenty of Galera related stuff there.

And, don't forget Severalnine's ClusterControl, it offers benefits like:

• Hassle free installer for Galera Cluster
• Excellent cluster aware GUI for Galera cluster monitoring and management

You can start your ClusterControl journey here: ClusterControl™ for MySQL Galera

Galera Presentation in PerconaLive

Here is the slide set for the Galera release 1.0 presentation given in the PerconaLive London conference: Galera Replication Release 1.0, Getting There. Many thanks for Percona for all the effort in organizing this fabulous event.

And special thanks for Clustrix for the Revolution Party, and congratulations as well for the awesome benchmark results. Clustrix sure runs at the "ludicrous speed".

MySQL/Galera Release 1.0 - Replication Redefined

MySQL/Galera Release 1.0 has slipped from our hands, we could not hold back it anymore. The pressure was just too immense from the community, our partners, and our new sales guy (specials thanks to Sakari for kicking some engineer ass).

So, the infection is underway, and there will be no return to the steam-age with async replication. Galera is replication redefined - and this is permanent. Biggest news in this release is that we now support both MySQL 5.1 and 5.5 series. Other nice features (since 0.8.1 level) include:

• replication over SSL
• garbd - the lightweight arbitator
• causal read support
• persistent write set buffering

Not all that can be expressed with one sentence. but believe, me you are dying to to get it, because you cannot live without it.

So, there it is: www.codership.com/downloads/download-mysqlgalera/ .

And there is even more to it. Our beloved western neighbors, brave dudes from Severalnines have worked, if possible, even harder than us and are releasing Severalnines ClusterControl for MySQL Galera. ClusterControl provides three utilities:

• configurator
• monitor
• management

...which pretty much cover all the tasks you need to do with your cluster.

Check out: www.severalnines.com/galera-configurator to get started. With the configurator, you just fill in your system information, and you will receive a tarball with deployment script, which will install and configure your MySQL/Galera cluster automatically.

So there goes, now back to PerconaLive - it is intense here!

Galera Presentation in PerconaLive, London Conference

Team Codership will give a Galera presentation in the next event of the distinguished PerconaLive conference series in London (Oct 25).

We will send a three person mini-delegation in the conference, and here we follow the guidelines we have been preaching to the Galera community for long: always have at least three members in the cluster for high availability. With the presence of conference buffets, evening reception, London attractions, pubs & night life, Chelsea stadium etc..., our team may have to do a few internal failovers. But, three member staffing guarantees that at least one of us is available at all times for any discussion you may want to get us involved with, preferably HA, replication or clustering related, as these topics make our world tick.

Our presentation will focus in Galera replication new features developed during summer time. Since the MySQL User Conference in April, we have pushed three new 0.8 series releases, and, now the Galera 1.0 release is just about sliding out of the shipyard. A wealth of new features altogether, well worth 30 min talk session.

Ohoj! hope to see you there!