EmergencyEMERGENCY? Get 24/7 Help Now!

Quick start MySQL testing using Docker (on a Mac!)

 | May 11, 2016 |  Posted In: Docker, MySQL

docker-logo

In this post, we’ll discuss how you can quick start MySQL testing using Docker, specifically in a Mac environment. Like a lot of people, I’m hearing a lot about Docker and it’s got me curious. The Docker ecosystem seems to be moving quickly, however, and simple “getting started” or “how-to” type articles that are easy […]

Read More

High-load clusters and desynchronized nodes on Percona XtraDB Cluster

 | August 31, 2015 |  Posted In: MySQL, Percona XtraDB Cluster

There can be a lot of confusion and lack of planning in Percona XtraDB Clusters in regards to nodes becoming desynchronized for various reasons.  This can happen a few ways: An IST or SST joining node catching up after a state transfer (Joined/Joining state) Using wsrep_desync for something like a backup Executing a rolling-schema-upgrade using […]

Read More

PXC – Incremental State transfers in detail

 | August 5, 2015 |  Posted In: MySQL, Percona XtraDB Cluster

IST Basics State transfers in Galera remain a mystery to most people.  Incremental State transfers (as opposed to full State Snapshot transfers) are used under the following conditions: The Joiner node reports Galera a valid Galera GTID to the cluster The Donor node selected contains all the transactions the Joiner needs to catch up to […]

Read More

TOI wsrep_RSU_method in PXC 5.6.24 and up

 | July 6, 2015 |  Posted In: MySQL, Percona XtraDB Cluster

I noticed that in the latest release of Percona XtraDB Cluster (PXC), the behavior of wsrep_OSU_method changed somewhat.  Prior to this release, the variable was GLOBAL only, meaning to use it you would:

This had the (possibly negative) side-effect that ALL DDL’s issued on this node would be affected by the setting while in […]

Read More

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

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.