EmergencyEMERGENCY? Get 24/7 Help Now!

Concatenating MyISAM files

 | November 19, 2012 |  Posted In: MySQL

Recently, I found myself involved in the migration of a large read-only InnoDB database to MyISAM (eventually packed). The only issue was that for one of the table, we were talking of 5 TB of data, 23B rows. Not small… I calculated that with something like insert into MyISAM_table… select * from Innodb_table… would take […]

Read More

Upcoming webinar on PRM

 | September 20, 2012 |  Posted In: MySQL

Just a reminder that Wednesday the 26th at 10am Pacific time, I’ll give a webinar on PRM, the Percona replication manager. During the webinar, I’ll walk you through the setup of a PRM cluster and show you how to perform some basic management tasks. If you are interested, click here to register. See you Wednesday! […]

Read More

PLMCE High Availability Deep Dive slides and Document

 | April 19, 2012 |  Posted In: MySQL

The slides and accompanying document of the High availability deep dive tutorial have all been uploaded and can be downloaded from the link below: http://box.com/perconalive2012 For the slides, you’ll find a PDF and a pptx version, the gdocs animations works somewhat OK with pptx. Also, the VMs will stay available from a at least few […]

Read More

High Availability Deep Dive tutorial at PLMCE

 | April 6, 2012 |  Posted In: MySQL

(a slightly modify rebroadcast of Florian’s post) If you are interested by High availability solution with MySQL, Florian Haas from and myself myself will be co-presenting next Tuesday a tutorial on the topic. It is never too late to register! For the ones who are already registered, here’s advance information which you will find useful. […]

Read More

NDB tutorial at Percona Live London + Free TIcket Give Away

 | September 23, 2011 |  Posted In: Events and Announcements, MySQL

In a month, the 24th of October, Johan Andersson (severalnines.com) and I will be giving a full day tutorial on NDB cluster which will include both presentations and hands-on. Be ready for a fast ramp-up on NDB! Among items covered: – Achitecture – Installation – Loading data – Administration (common procedures) – Node recovery – […]

Read More

How to replace a NDB node on EC2

 | June 9, 2011 |  Posted In: MySQL

NDB cluster is a very interesting solution in term of high availability since there are no single point of failure. In an environment like EC2, where a node can disappear almost without notice, one would think that it is a good fit. It is indeed a good fit but reality is a bit trickier. The […]

Read More

A recovery trivia or how to recover from a lost ibdata1 file

 | June 3, 2011 |  Posted In: MySQL

A few day ago, a customer came to Percona needing to recover data. Basically, while doing a transfer from one SAN to another, something went wrong and they lost the ibdata1 file, where all the table meta-data is stored. Fortunately, they were running with innodb_file_per_table so the data itself was available. What they could provide […]

Read More