EmergencyEMERGENCY? Get 24/7 Help Now!

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

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

Performance Evaluation of SST Data Transfer: With Encryption (Part 2)

 | March 30, 2017 |  Posted In: Insight for DBAs, MySQL, Percona XtraDB Cluster

SST Data Transfer

In this blog post, we’ll look at the performance of SST data transfer using encryption. In my previous post, we reviewed SST data transfer in an unsecured environment. Now let’s take a closer look at a setup with encrypted network connections between the donor and joiner nodes. The base setup is the same as the previous […]

Read More

Performance Evaluation of SST Data Transfer: Without Encryption (Part 1)

 | March 29, 2017 |  Posted In: Insight for DBAs, MySQL

SST Data Transfer

In this blog, we’ll look at evaluating the performance of an SST data transfer without encryption. A State Snapshot Transfer (SST) operation is an important part of Percona XtraDB Cluster. It’s used to provision the joining node with all the necessary data. There are three methods of SST operation available: mysqldump, rsync, xtrabackup. The most […]

Read More

Percona XtraDB Cluster 5.6.32-25.17 is now available

 | October 4, 2016 |  Posted In: MySQL

wsrep-stages

Percona announces the new release of Percona XtraDB Cluster 5.6.32-25.17 on October 4, 2016. Binaries are available from the downloads area or our software repositories. Percona XtraDB Cluster 5.6.32-25.17 is now the current release, based on the following: Percona Server 5.6.32-78.1 Galera Replication library 3.17 Codership wsrep API version 25 Bugs Fixed: Fixed DONOR node […]

Read More

Improving Percona XtraDB Cluster SST startup with Google Compute Engine snapshots

 | March 3, 2015 |  Posted In: Cloud and MySQL, MySQL, Percona XtraDB Cluster

As the need for information grows so does the size of data we need to keep in our databases. SST is unavoidable for spinning up new nodes in a PXC cluster and when datasets reach the “terra-byte” range this becomes ever more cumbersome requiring many hours for a new node to synchronize. More often that not, […]

Read More