XtraDB Cluster

Percona XtraDB Cluster Transaction Replay Anomaly

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 as follows:

Shell

create database test;
use test;
create […]

Read more

BEWARE: Increasing fc_limit can affect SELECT latency

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 contention […]

Read more

Simplified Percona XtraDB Cluster SSL Configuration

wsrep-stages

In this blog post, we’ll look at a feature that recently added to Percona XtraDB Cluster 5.7.16, that makes it easier to configure Percona XtraDB Cluster SSL for all related communications. It uses mode “encrypt=4”, and configures SSL for both IST/Galera communications and SST communications using the same SSL files. “encrypt=4” is a new […]

Read more

Enabling Percona XtraDB Cluster SST Traffic Encryption

wsrep-stages

In this blog post, we’ll look at enabling Percona XtraDB Cluster SST Traffic Encryption, and some of the changes to the SSL-based encryption of SST traffic in Percona XtraDB Cluster 5.7.16.
Some background
Percona XtraDB Cluster versions prior to 5.7 support encryption methods 0, 1, 2 and 3:

encrypt = 0 : (default) No encryption
encrypt = 1 : […]

Read more

Tracking IST Progress in Percona XtraDB Cluster

wsrep-stages

In this blog post, we’ll look at how Percona XtraDB Cluster uses IST.
Introduction
Percona XtraDB Cluster uses the concept of an Incremental State Transfer (IST). When a node of the cluster leaves the cluster for a short period of time, it can rejoin the cluster by getting the delta set of missing changes from any active node […]

Read more

How We Made Percona XtraDB Cluster Scale

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

Read more

Percona XtraDB Cluster 5.7.17-27.20 is now available

Percona XtraDB Cluster 5.7

Percona announces the release of Percona XtraDB Cluster 5.7.17-27.20 on March 16, 2017. Binaries are available from the downloads section or our software repositories.
NOTE: You can also run Docker containers from the images in the Docker Hub repository.
Percona XtraDB Cluster 5.7.17-27.20 is now the current release, based on the following:

Percona Server 5.7.17-11
Galera Replication library 3.20
wsrep […]

Read more

Percona XtraDB Cluster 5.6.35-26.20 is now available

Percona XtraDB Cluster 5.7

Percona announces the release of Percona XtraDB Cluster 5.6.35-26.20 on March 10, 2017. Binaries are available from the downloads section or our software repositories.
Percona XtraDB Cluster 5.6.35-26.20 is now the current release, based on the following:

Percona Server 5.6.35-80.0
Galera Replication library 3.20
wsrep API version 26

All Percona software is open-source and free. Details of this release can […]

Read more

Installing Percona Monitoring and Management (PMM) for the First Time

Percona Monitoring and Management 2

This blog post is another in the series on the Percona Server for MongoDB 3.4 bundle release. This post is meant to walk a prospective user through the benefits of Percona Monitoring and Management (PMM), how it’s architected and the simple install process. By the end of this post, you should have a good […]

Read more

Percona Software News and Roadmap Update with CEO Peter Zaitsev: Q1 2017

Percona Software News and Roadmap Update

This blog post is a summary of the webinar Percona Software News and Roadmap Update – Q1 2017 given by Peter Zaitsev on January 12, 2017.
Over the last few months, I’ve had the opportunity to meet and talk with many of Percona’s customers. I love these meetings, and I always get a bunch of questions […]

Read more