Author - Jay Janssen

Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks

Percona XtraDB Cluster (PXC) and the technology it uses (Galera) is an exciting alternative to traditional MySQL replication.  For those who don’t know, it gives you:

Fully Synchronous replication with a write latency increase equivalent to a ping RTT to the furthest node
Automatic cluster synchronization, both incremental and full restores
The ability to read and write […]

Read more

Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN

I have a customer who is considering Percona XtraDB Cluster (PXC) in a two colo WAN environment.  They wanted me to do a test comparing PXC against semi-synchronous replication to see how they stack up against each other.
Test Environment
The test environment included AWS EC2 nodes in US-East and US-West (Oregon).  The ping RTT latency between […]

Read more

Webinar – Migrating to Percona XtraDB Cluster

Whenever I learn about a new technology, I typically want to know the major administrative touch points more than I want to know exhaustive detail about every configuration option.  Give me the gist, show me enough to get started, and give me a link to the manual.
XtraDB cluster (and Galera, the technology on which it […]

Read more

The relationship between Innodb Log checkpointing and dirty Buffer pool pages

This is a time-honored topic, and there’s no shortage of articles on the topic on this blog. I wanted to write a post trying to condense and clarify those posts, as it has taken me a while to really understand this relationship.
Some basic facts

Most of us know that writing into Innodb updates buffer pool […]

Read more