EmergencyEMERGENCY? Get 24/7 Help Now!

Testing backup locks during Xtrabackup SST on Percona XtraDB Cluster

 | December 22, 2014 |  Posted In: MySQL, Percona XtraBackup, Percona XtraDB Cluster

Background on Backup Locks I was very excited to see Backup locks support in release notes for the latest Percona XtraDB Cluster 5.6.21 release. For those who are not aware, backup locks offer an alternative to FLUSH TABLES WITH READ LOCK (FTWRL) in Xtrabackup. While Xtrabackup can hot-copy Innodb, everything else in MySQL must be locked (usually […]

Read More

Q&A: Percona XtraDB Cluster as a MySQL HA solution for OpenStack

 | November 14, 2014 |  Posted In: MySQL, OpenStack, Percona XtraDB Cluster, Trove, XtraDB Cluster

Thanks to all who attended my Nov. 12 webinar titled, “Percona XtraDB Cluster as a MySQL HA Solution for OpenStack.” I had several questions which I covered at the end and a few that I didn’t. You can view the entire webinar and download the slides here. Q: Is the read,write speed reduced in Galera […]

Read More

HAProxy: Give me some logs on CentOS 6.5!

 | October 3, 2014 |  Posted In: Insight for DBAs, MySQL

HAProxy is frequently used as a load-balancer in front of a Galera cluster. While diagnosing an issue with HAProxy configuration, I realized that logging doesn’t work out of the box on CentOS 6.5. Here is a simple recipe to fix the issue. If you look at the top of /etc/haproxy/haproxy.cfg, you will see something like: […]

Read More

Migrating to Percona XtraDB Cluster 2014 edition: Sept. 10 MySQL webinar

 | September 3, 2014 |  Posted In: Insight for DBAs, MySQL, MySQL Webinars, Percona MySQL Consulting, Percona XtraDB Cluster

Join me online next week (September 10 at 10 a.m. PDT) for my live webinar on Migrating to Percona XtraDB Cluster.  This was a popular webinar that I gave a few years ago, so I’m doing it again with updates for Percona XtraDB Cluster 5.6 (PXC) and all the latest in the Galera world. This webinar […]

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

Galera data on Percona Cloud Tools (and other MySQL monitoring tools)

 | August 29, 2014 |  Posted In: ClusterControl, MySQL, Percona Cloud Tools, Percona ClusterControl, Percona MySQL Support, Percona XtraDB Cluster, XtraDB Cluster

I was talking with a Percona Support customer earlier this week who was looking for Galera data on Percona Cloud Tools. (Percona Cloud Tools, now in free beta, is a hosted service providing access to query performance insights for all MySQL uses.) The customer mentioned they were already keeping track of some Galera stats on Cacti, and […]

Read More

Monitoring MySQL flow control in Percona XtraDB Cluster 5.6

 | July 25, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Software, Percona XtraDB Cluster

Monitoring flow control in a Galera cluster is very important. If you do not, you will not understand why writes may sometimes be stalled. Percona XtraDB Cluster 5.6 provides 2 status variables for such monitoring: wsrep_flow_control_paused and wsrep_flow_control_paused_ns. Which one should you use? What is flow control? Flow control does not exist with regular MySQL replication, […]

Read More

Before every release: A glimpse into Percona XtraDB Cluster CI testing

 | February 21, 2014 |  Posted In: MySQL, Percona Software, Percona XtraDB Cluster

I spoke last month at linux.conf.au 2014 in Perth, Australia, and one of my sessions focused on the “Continuous Integration (CI) testing of Percona XtraDB Cluster (PXC)” at the Developer,Testing, Release and CI miniconf. Here is the video of the presentation: Here is the presentation itself: Percona XtraDB Cluster before every release: Glimpse into CI […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.