EmergencyEMERGENCY? Get 24/7 Help Now!

Webinar Thursday, December 7, 2017: Percona XtraDB Cluster (PXC) 101

and  | December 6, 2017 |  Posted In: High-availability, Insight for DBAs, MySQL, Technical Webinars

Percona XtraDB Cluster

Join Percona’s Software Engineer (PXC Lead), Krunal Bauskar as he presents Percona XtraDB Cluster 101 on Thursday, December 7, 2017, at 7:00 am PST / 10:00 am EST (UTC-8). Tags: Percona XtraDB Cluster, MySQL, High Availability, Clustering Experience Level: Beginner Percona XtraDB Cluster (PXC) is a multi-master solution that offers virtual synchronous replication among clustering […]

Read More

Faster Node Rejoins with Improved IST performance

and  | July 21, 2017 |  Posted In: MySQL, Percona XtraDB Cluster

IST Performance

In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance. Introduction Starting in version 5.7.17-29.20 of Percona XtraDB Cluster significantly improved performance. Depending on the workload, the increase in throughput is in the range of 3-10x. (More details here). These optimization fixes also helped improve IST (Incremental State Transfer) performance. This […]

Read More

Differences in PREPARE Statement Error Handling with Binary and Text Protocol (Percona XtraDB Cluster / Galera)

 | July 5, 2017 |  Posted In: Insight for DBAs, MySQL, Percona XtraDB Cluster

PREPARE Statement

In this blog, we’ll look at the differences in how a PREPARE statement handles errors in binary and text protocols. Introduction Since Percona XtraDB Cluster is a multi-master solution, when an application executes conflicting workloads one of the workloads gets rolled back with a DEADLOCK error. While the same holds true even if you fire […]

Read More

Improved wsrep-stages and related instrumentation in Percona XtraDB Cluster

 | April 24, 2017 |  Posted In: MySQL, Percona XtraDB Cluster, XtraDB Cluster

wsrep-stages

In this blog post, we’ll look at how we’ve improved wsrep-stages and related instrumentation in Percona XtraDB Cluster. Introduction When you execute a workload and need to find out what the given thread is working on, “SHOW PROCESSLIST” comes to the top of your mind. It is an effective way to track the thread status. We […]

Read More

Percona XtraDB Cluster Transaction Replay Anomaly

 | April 23, 2017 |  Posted In: MySQL, Percona XtraDB Cluster, XtraDB Cluster

wsrep-stages

In this blog post, we’ll look at a transaction replay anomaly in Percona XtraDB Cluster. Introduction Percona XtraDB Cluster/Galera replays a transaction if the data is non-conflicting but, the transaction happens to have conflicting locks. Anomaly Let’s understand this with an example: Let’s assume a two-node cluster (node-1 and node-2) Base table “t” is created […]

Read More

BEWARE: Increasing fc_limit can affect SELECT latency

 | April 22, 2017 |  Posted In: MySQL, Percona XtraDB Cluster, XtraDB Cluster

SELECT Latency

In this blog post, we’ll look at how increasing the fc_limit can affect SELECT latency. Introduction Recent Percona XtraDB Cluster optimizations have exposed fc_limit contention. It was always there, but was never exposed as the Commit Monitor contention was more significant. As it happens with any optimization, once we solve the bigger contention issues, smaller […]

Read More

More Trackable Flow Control for Percona XtraDB Cluster

 | April 20, 2017 |  Posted In: MySQL, Percona XtraDB Cluster

wsrep-stages

In this blog post, we’ll discuss trackable flow control in Percona XtraDB Cluster. Introduction Percona XtraDB Cluster has a self-regulating mechanism called Flow Control. This mechanism helps to avoid a situation wherein the weakest/slowest member of the cluster falls significantly behind other members of the cluster. When a member of a cluster is slow at applying write-sets […]

Read More

How We Made Percona XtraDB Cluster Scale

 | April 19, 2017 |  Posted In: MySQL, Percona XtraDB Cluster, XtraDB Cluster

wsrep-stages

In this blog post, we’ll look at the actions and efforts Percona experts took to scale Percona XtraDB Cluster. Introduction When we first started analyzing Percona XtraDB Cluster performance, it was pretty bad. We would see contention even with 16 threads. Performance was even worse with sync binlog=1, although the same pattern was observed even with […]

Read More