Short version: It looks like DataStax has released an official C++ driver for their new CQL native protocol. This makes it possible to update MariaDB’s Cassandra Storage Engine to work with all column families in Cassandra 1.2 and up.

Long version: In case the above didn’t make any sense to you, here’s some background:

• Cassandra Storage Engine was developed against Cassandra 1.1
• Cassandra 1.1 had a client-server protocol based on Thrift API. It had a number of limitations, the most important was lack of support for streaming. These translated into limitations in Cassandra storage engine, for example, I could not support secondary indexes.
• Cassandra 1.2 was released in February, and it had a …

I was really pleased to see the announcement by Oracle MySQL yum repositories that they have now produced a yum repository from where the MySQL RPMs they provide can be downloaded. This makes keeping up to date much easier. Many companies setup internal yum repositories with the software they need as then updating servers is much easier and can be done with a simple command. For many people at home that means you set this up once and don’t need to check for updates and do manual downloads, but can do a quick yum update xxxx and you get the latest version. Great!  This new yum repository only covers RHEL6 did not include RHEL5 which is not yet end of life and still used by me and probably quite a lot of other people. I filed bug#70773 to ask for RHEL5 support to be …

Learn how Gittigidiyor (a subsidiary of eBay) replicates data in real time from MySQL to Oracle with Continuent Tungsten. Gittigidiyor consolidates reporting data in a single MySQL server. Transactions arriving on this server must be replicated in real time to an Oracle instance.

In this webinar, Levent Kurt, Site Operations Manager at Gittigidiyor, describes how Gittigidiyor solved their

I frequently use pt-query-digest to parse the MySQL slow query log. This morning I wanted to parse the MySQL binary log to find out how frequently various tables in my database are updated. A quick check of the pt-query-digest documentation confirmed that pt-query-digest does support parsing the binary log:

--type

type: Array; default: slowlog

The type of input to parse. The permitted types are

binlog

   Parse a binary log file.

...

However, the docs don't have any further details or examples. Given the lack of documentation my first instinct was to run pt-query-digest on my binary log using defaults for all of the other settings, like this: …

Working with MySQL 5.6 under CentOS 6.4 I came across the following problem with MySQL reporting it did not shutdown successfully.

$ sudo su -
$ service mysql stop
Shutting down MySQL................................................................................................................................................................................................................................................................................................
......................................................................................................................................................................................................................................................................................................... …

As part of the ongoing effort to refactor MySQL and make it better, we are defining the behaviour of certain features and in some cases reimplimenting them in a more maintainable fashion.

I have previously blogged on:

• A proposal to simplify SQL_MODE options.
• The Federated Storage Engine.
• The Query Cache.
• The deprecation of EXPLAIN PARTITIONS and EXPLAIN EXTENDED.
• …

As every year in February, in Brussels, the FOSDEM will take place!
And as every year, the MySQL Community will also be present! For the 3rd year in a row, I have the honour of organising the MySQL & Friends Devroom.

Let’s start with the most important information: FOSDEM 2014 will be held February 1 and 2.
This year instead of Sunday, the MySQL & Friends Devroom will be on Saturday from 9 a.m. and will finish with
the Community Dinner (more information related to the dinner will come later).

The “Call for Papers” has been announced on the MySQL mailing list, you can still read it here.
CfP is open until December 6th!

This year the …

Percona Live London MySQL Conference, November 11-12 2013

Codership's Galera Cluster team will be present this year as Platinum sponsor of the event, and we're excited for the opportunity to showcase the latest developments of Galera Cluster to Europe's MySQL community in London. We will have two talks at the event, as described below and will also be present in the exhibition hall with a Galera Cluster booth. Make sure to say hello and meet our experts at the booth to discuss all things related to Galera Cluster & beyond.

Talk 1: Galera Cluster 3.0 – new features

12 November 11:00am - 11:50am @ Sentosa 5-8, by Seppo Jaakola, CEO, Codership

This session presents Galera Cluster synchronous multi-master feature and functionality and the new features of Galera Cluster 3.0, including MySQL 5.6 compatibility and how Galera makes the best …

Table of Content

• Introduction
• Prerequisites
• Full Backup
  • Create Full Backup
  • Prepare Full Backup
  • Restore Full Backup
  • …

Table of Content

• Introduction
• Prerequisites
• Full Backup
  • Create Full Backup
  • Prepare Full Backup
  • Restore Full Backup
  • …