EmergencyEMERGENCY? Get 24/7 Help Now!

Exploring message brokers

 | May 5, 2014 |  Posted In: High-availability, MySQL

Message brokers are not regularly covered here but are, nonetheless, important web-related technologies. Some time ago, I was asked by one of our customer to review a selection of OSS message brokers and propose a couple of good candidates. The requirements were fairly simple: behave well when there’s a large backlog of messages, be able […]

Read More

The use of Iptables ClusterIP target as a load balancer for PXC, PRM, MHA and NDB

 | January 10, 2014 |  Posted In: High-availability, MySQL, XtraDB Cluster

Most technologies achieving high-availability for MySQL need a load-balancer to spread the client connections to a valid database host, even the Tungsten special connector can be seen as a sophisticated load-balancer. People often use hardware load balancer or software solution like haproxy. In both cases, in order to avoid having a single point of failure, […]

Read More

Q&A: Geographical disaster recovery with Percona Replication Manager

 | December 10, 2013 |  Posted In: High-availability, MySQL

My December 4 webinar, “Geographical disaster recovery with  Percona Replication Manager (PRM),”  gave rise to a few questions. The recording of the webinar and the slides are available here, and I’ve answered the questions I didn’t have time to address below. Q1: Hi, I was wondering if corosync will work in cloud environment. As far as […]

Read More

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, 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