EmergencyEMERGENCY? Get 24/7 Help Now!

Q&A: High availability when using MySQL in the cloud

 | June 19, 2015 |  Posted In: Cloud and MySQL, MySQL, Percona XtraDB Cluster, Technical Webinars

Last week I hosted a webinar on using MySQL in the cloud for High Availability (HA) alongside 451 Research analyst Jason Stamper. You can watch the recording and also download the slides (free) here. Just click the “Register” button at the end of that page. We had several excellent questions and we didn’t have time […]

Read More

Percona XtraDB Cluster: Quorum and Availability of the cluster

 | June 12, 2015 |  Posted In: MySQL

Percona XtraDB Cluster (PXC) has become a popular option to provide high availability for MySQL servers. However many people are still having a hard time understanding what will happen to the cluster when one or several nodes leave the cluster (gracefully or ungracefully). This is what we will clarify in this post. Nodes leaving gracefully […]

Read More

Optimizing Percona XtraDB Cluster for write hotspots

 | June 3, 2015 |  Posted In: InnoDB, Insight for DBAs, MySQL, Percona XtraDB Cluster

Some applications have a heavy write workload on a few records – for instance when incrementing a global counter: this is called a write hotspot. Because you cannot update the same row simultaneously from multiple threads, this can lead to performance degradation. When using Percona XtraDB Cluster (PXC), some users try to solve this specific […]

Read More

Improving Percona XtraDB Cluster SST startup with Google Compute Engine snapshots

 | March 3, 2015 |  Posted In: Cloud and MySQL, MySQL, Percona XtraDB Cluster

As the need for information grows so does the size of data we need to keep in our databases. SST is unavoidable for spinning up new nodes in a PXC cluster and when datasets reach the “terra-byte” range this becomes ever more cumbersome requiring many hours for a new node to synchronize. More often that not, […]

Read More

How to setup a PXC cluster with GTIDs (and have async slaves replicating from it!)

 | February 20, 2015 |  Posted In: GTID, MySQL, Percona XtraBackup, Percona XtraDB Cluster

This past week was marked by a series of personal findings related to the use of Global Transaction IDs (GTIDs) on Galera-based clusters such as Percona XtraDB Cluster (PXC). The main one being the fact that transactions touching MyISAM tables (and FLUSH PRIVILEGES!) issued on a giving node of the cluster are recorded on a GTID set […]

Read More

Galera replication – how to recover a PXC cluster

 | September 1, 2014 |  Posted In: Insight for DBAs, MySQL, Percona XtraDB Cluster

Galera replication for MySQL brings not only the new, great features to our ecosystem, but also introduces completely new maintenance techniques. Are you concerned about adding such new complexity to your MySQL environment? Perhaps that concern is unnecessarily. I am going to present here some simple tips that hopefully will let fresh Galera users prevent […]

Read More