EmergencyEMERGENCY? Get 24/7 Help Now!

High-availability options for MySQL, October 2013 update

 | October 23, 2013 |  Posted In: High-availability, MySQL, Percona Server, Percona XtraDB Cluster

The technologies allowing to build highly-available (HA) MySQL solutions are in constant evolution and they cover very different needs and use cases. In order to help people choose the best HA solution for their needs, we decided, Jay Janssen and I, to publish, on a regular basis (hopefully, this is the first), an update on […]

Read More

ZFS on Linux and MySQL

 | May 24, 2013 |  Posted In: Hardware and Storage, Insight for DBAs, MySQL

I am currently working with a large customer and I am involved with servers located in two data centers, one with Solaris servers and the other one with Linux servers. The Solaris side is cleverly setup using zones and ZFS and this provides a very low virtualization overhead. I learned quite a lot about these […]

Read More

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