Author - Jay Janssen

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

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

Webinar: Writing Application Code for MySQL High Availability Followup Questions

Thanks to all who attended my webinar last week on Writing Application Code for MySQL High Availability.  This blog is for me to address the extra questions I didn’t have time to answer on the stream.
What do you think about using Galera Cluster but writing to a single Node with LVS ?
Whatever HA strategy you […]

Read more

High-load clusters and desynchronized nodes on 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 using wsrep_OSU_method=RSU

When […]

Read more

Optimizing PXC Xtrabackup State Snapshot Transfer

State Snapshot Transfer (SST) at a glance
PXC uses a protocol called State Snapshot Transfer to provision a node joining an existing cluster with all the data it needs to synchronize.  This is analogous to cloning a slave in asynchronous replication:  you take a full backup of one node and copy it to the new […]

Read more

PXC – Incremental State transfers in detail

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 the rest […]

Read more