EmergencyEMERGENCY? Get 24/7 Help Now!

Geographical disaster recovery with PRM: Register for Dec. 4 Webinar

 | November 26, 2013 |  Posted In: High-availability, Technical Webinars

Downtime caused by a disaster is probable in your application’s lifetime. While caused by a large-scale geographical disaster, cyber attack, spiked consumer demand, or a relatively less catastrophic event, downtime equates to lost business. Setting up geographical disaster recovery (geo-DR) has always been challenging but Percona replication manager (PRM) with booth provides a solution for […]

Read More

How to add VIPs to Percona XtraDB Cluster or MHA with Pacemaker

 | November 20, 2013 |  Posted In: High-availability, MySQL, Percona XtraDB Cluster

It is a rather frequent problem to have to manage Virtual IP addresses (VIPs) with a Percona XtraDB Cluster (PXC) or with MySQL master HA (MHA). In order to help solving these problems, I wrote a Pacemaker agent, mysql_monitor that is a simplified version of the mysql_prm agent. The mysql_monitor agent only monitors MySQL and […]

Read More

High-availability options for MySQL, October 2013 update

 | October 23, 2013 |  Posted In: High-availability, MySQL, Percona Server for MySQL, 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