EmergencyEMERGENCY? Get 24/7 Help Now!

What About ProxySQL and Mirroring?

 | May 25, 2017 |  Posted In: MySQL, Percona Monitoring and Management, Percona XtraDB Cluster, ProxySQL, ProxySQL, Replication

ProxySQL and Mirroring

In this blog post, we’ll look at how ProxySQL and mirroring go together. Overview Let me be clear: I love ProxySQL, and I think it is a great component for expanding architecture flexibility and high availability. But not all that shines is gold! In this post, I want to correctly set some expectations, and avoid selling […]

Read More

Percona Software and Roadmap Update with CEO Peter Zaitsev: Q2 2017

 | May 24, 2017 |  Posted In: Backups, Benchmarks, MariaDB, MongoDB, MySQL, Percona XtraBackup, Percona XtraDB Cluster, PMM, Technical Webinars

Percona Software and Services

This blog post is a summary of the Percona Software and Roadmap Update – Q2 2017 webinar given by Peter Zaitsev on May 4, 2017. This webinar reflects changes and updates since the last update (Q1 2017). A full recording of this webinar, along with the presentation slide deck, can be found here. Percona Software Below are the […]

Read More

Percona Live 2017: Day Three Keynotes

 | April 27, 2017 |  Posted In: Big Data, InnoDB, MariaDB, MongoDB, MyRocks, MySQL, Percona Live, Percona Server, Percona Server for MongoDB, Percona XtraDB Cluster, PMM

Percona Live Keynotes

Welcome to the third (and final) day of the Percona Live Open Source Database Conference 2017, and the third (and final) set of Percona Live keynotes! The enthusiasm hasn’t waned here at Percona Live, and we had a full house on Thursday morning! Day three of the conference kicked off with three keynotes talks, and […]

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

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

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