Yearly Archives - 2012

Packing for the Holidays

Every time I visit my family for the holidays, as the date approaches, I find myself filled with dread. It’s nothing sinister, my family’s great, and the season is nice. The reason is simple:
I hate packing.
In fact, I hate both kinds of packing: trip packing, and bit packing. Let me tell you a story […]

Read more

Percona XtraDB Cluster (PXC): what about GRA_*.log files ?

How easy is it to identify and debug Percona XtraDB Cluster replication problem ?
If you are using PXC, you may have already seen in your datadirectory several log files starting with GRA_
Those files correspond to a replication failure. That means the slave thread was not able to apply one transaction. For each of those […]

Read more

Percona and the MariaDB Foundation

There have been several reports (1,2,3) describing Percona’s stance regarding the MariaDB Foundation that are not totally accurate so I though it would be worth it to describe where we stand on this and related matters.
First, let me say the creation of theMariaDB Foundation is a good thing for the MariaDB Community and […]

Read more

Migrating several single standalone MySQL server to one Percona XtraDB Cluster… MariaDB to the rescue !

Some weeks ago I had to migrate some independent MySQL servers (some standard MySQL masters, and some just standalone) to a Percona XtraDB Cluster of 3 nodes.
So the easiest way would be to configure each node to become also an asynchronous slave of one of the production servers.
Like illustrated here:

But in this case there […]

Read more

The Optimization That (Often) Isn’t: Index Merge Intersection

Prior to version 5.0, MySQL could only use one index per table in a given query without any exceptions; folks that didn’t understand this limitation would often have tables with lots of single-column indexes on columns which commonly appeared in their WHERE clauses, and they’d wonder why the EXPLAIN plan for a given SELECT […]

Read more

Thank You Percona Live London 2012 Attendees!

Percona Live London wrapped up last week to very positive reviews from attendees and sponsors like those from Johan De Meersman.
Percona was pleased to provide an engaging event for MySQL community members that featured engaging tutorials, highly rated breakout sessions, a very well-attended Tuesday community networking reception sponsored by Clustrix, and keynotes from a […]

Read more

Yule Blog

Tired of the same old holiday tunes year after year? Join us as we Rock around the Fractal Tree here at Tokutek.
We’ve fiddled with the chorus; won’t you join us?
Rockin’ around the Fractal Tree
(sung to the tune of Rockin’ around the Christmas Tree)
Rockin’ around the Fractal Tree
As the bits begin to hop
Leaves are full […]

Read more

Webinar: 10 Percona Toolkit tools every MySQL DBA should know about

On December 19th at 1 PM Eastern / 10 AM Pacific, I will be giving a
webinar entitled “10 Percona Toolkit Tools Every MySQL DBA Should Know
About”.
As a Consultant, I make heavy use of Percona Toolkit tools while
solving customers’ problems, and I have used this experience to select
what I consider to be the top […]

Read more

Announcing Percona Server 5.5.28-29.2

Percona is glad to announce the release of Percona Server 5.5.28-29.2 on December 7th, 2012 (Downloads are available here and from the Percona Software Repositories).
Based on MySQL 5.5.28, including all the bug fixes in it, Percona Server 5.5.28-29.2 is now the current stable release in the 5.5 series. All of Percona‘s software is open-source and free, all the details of the release can […]

Read more