EmergencyEMERGENCY? Get 24/7 Help Now!

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

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

dh key too small

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

dh key too small

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

Percona Monitoring and Management 1.1.3 is Now Available

 | April 21, 2017 |  Posted In: Database Monitoring, Events and Announcements, MariaDB, MongoDB, MySQL, Orchestrator, Percona Monitoring and Management, Percona Server, Percona Server for MongoDB, Percona Software, Percona XtraDB Cluster, PMM, Prometheus, ProxySQL, ProxySQL

Percona Monitoring and Management

Percona announces the release of Percona Monitoring and Management 1.1.3 on April 21, 2017. For installation instructions, see the Deployment Guide. This release includes several new graphs in dashboards related to InnoDB and MongoDB operation, as well as smaller fixes and improvements.

Read More

Simplified Percona XtraDB Cluster SSL Configuration

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

dh key too small

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

dh key too small

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

More Trackable Flow Control for Percona XtraDB Cluster

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

dh key too small

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

dh key too small

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.6.35-26.20-3 is now available

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

Percona XtraDB Cluster 5.7

Percona announces the release of Percona XtraDB Cluster 5.6.35-26.20-3 on April 13, 2017. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.35-26.20-3 is now the current release, based on the following: Percona Server 5.6.35-81.0 Galera Replication library 3.20 wsrep API version 26 All Percona software is open-source and free. NOTE: Due […]

Read More