EmergencyEMERGENCY? Get 24/7 Help Now!

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: SST tmpdir option

 | April 24, 2017 |  Posted In: Insight for DBAs, Percona XtraDB Cluster, XtraDB Cluster

wsrep-stages

In this blog post, I’ll discuss some changes to the behavior of the Percona XtraDB Cluster SST tmpdir option in the latest versions of Percona XtraDB Cluster 5.6.35-26.20-3 and 5.7.17-29.30. Previously, we did not use the path specified by the tmpdir. From Percona XtraDB Cluster 5.6.35-26.20-3 and 5.7.17-29.20, we use the tmpdir option to specify the […]

Read More

Percona XtraDB Cluster: “dh key too small” error during an SST using SSL

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

wsrep-stages

If you’ve tried to use SSL in Percona XtraDB Cluster and saw an error in the logs like SSL3_CHECK_CERT_AND_ALGORITHM:dh key too small, we’ve implemented some changes in Percona XtraDB Cluster 5.6.34 and 5.7.16 that get rid of these errors. Some background dh key too small refers to the Diffie-Hellman parameters used by the SSL code that are […]

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

Simplified Percona XtraDB Cluster SSL Configuration

 | April 21, 2017 |  Posted In: MySQL, Percona XtraDB Cluster, Security, XtraDB Cluster

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

Read More

Enabling Percona XtraDB Cluster SST Traffic Encryption

 | April 21, 2017 |  Posted In: Percona XtraDB Cluster, Security, XtraDB Cluster

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

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

Percona XtraDB Cluster 5.7.17-27.20 is now available

 | March 17, 2017 |  Posted In: Events and Announcements, High-availability, MySQL, Percona Software, Percona XtraDB Cluster, ProxySQL, ProxySQL, XtraDB Cluster

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

Read More