High-availability

Percona XtraDB Cluster on Amazon GP2 Volumes

In this blog post, we look at the performance of Percona XtraDB Cluster on Amazon GP2 volumes.
In our overview blog post on Best Practices for Percona XtraDB Cluster on AWS, GP2 volumes did not show good results. However, we allocated only the size needed to fit the database (200GB volumes). Percona XtraDB Cluster did not show […]

Read more

Webinar Thursday, March 22, 2018: Percona XtraDB Cluster 5.7 with ProxySQL for Your MySQL High Availability and Clustering Needs

MySQL high availability

Please join Percona’s Ramesh Sivaraman (QA Engineer) and Krunal Bauskar (Software Engineer, Percona XtraDB Cluster Lead) as they present Percona XtraDB Cluster 5.7 with ProxySQL for Your MySQL High Availability and Clustering Needs on Thursday, March 22, 2018 at 8:30 am PDT (UTC-7) / 11:30 am EDT (UTC-4).
Percona has developed Percona XtraDB Cluster […]

Read more

Percona XtraDB Cluster 5.7.21-29.26 Is Now Available

Percona XtraDB Cluster 5.7

Percona announces the release of Percona XtraDB Cluster 5.7.21-29.26 (PXC) on March 2, 2018. Binaries are available from the downloads section or our software repositories.
Percona XtraDB Cluster 5.7.21-29.26 is now the current release, based on the following:

Percona Server for MySQL 5.7.21
Galera/Codership WSREP API Release 5.7.21
Galera Replication library 3.23

Starting from now, Percona XtraDB Cluster issue tracking […]

Read more

Percona XtraDB Cluster 5.6.39-26.25 Is Now Available

Percona XtraDB Cluster 5.7

Percona announces the release of Percona XtraDB Cluster 5.6.39-26.25 (PXC) on February 26, 2018. Binaries are available from the downloads section or our software repositories.
Percona XtraDB Cluster 5.6.39-26.25 is now the current release, based on the following:

Percona Server for MySQL 5.6.39
Galera/Codership WSREP API Release 5.6.39
Galera Replication library 3.23

Starting from this release, Percona XtraDB Cluster […]

Read more

Want IST Not SST for Node Rejoins? We Have a Solution!

IST Not SST for Node Rejoins

What if we tell you that there is a sure way to get IST not SST for node rejoins? You can guarantee that a new node rejoins using IST. Sound interesting? Keep reading.
Normally when a node is taken out of the cluster for a short period of time (for maintenance or shutdown), gcache on other nodes of the cluster […]

Read more

Percona XtraDB Cluster 5.7.20-29.24 Is Now Available

Percona XtraDB Cluster 5.7

Percona announces the release of Percona XtraDB Cluster 5.7.20-29.24 (PXC) on January 26, 2018. Binaries are available from the downloads section or our software repositories.
NOTE: Due to new package dependency,
Ubuntu/Debian users should use apt-get dist-upgrade, apt upgrade, or apt-get install percona-xtradb-cluster-57 to upgrade.
Percona XtraDB Cluster 5.7.20-29.24 is now the current release, based on the […]

Read more

Percona XtraDB Cluster 5.6.38-26.23 Is Now Available

Percona XtraDB Cluster 5.7

Percona announces the release of Percona XtraDB Cluster 5.6.38-26.23 (PXC) on January 24, 2018. Binaries are available from the downloads section or our software repositories.
Percona XtraDB Cluster 5.6.38-26.23 is now the current release, based on the following:

Percona Server for MySQL 5.6.38
Galera/Codership WSREP API Release 5.6.38
Galera Replication library 3.21

All Percona software is open-source and free.

Fixed […]

Read more

Case in Point: A Year of Customer Experience with Percona

Customer Experience

In 2017 we have welcomed many new customers into the Percona fold. It’s always interesting to find out what challenges the Percona team helped them to address and how they chose their relationship with Percona. As unbiased champions of open source database software, our consultancy, support and managed services staff apply their expertise across […]

Read more

Webinar Q&A: Percona XtraDB Cluster 101

InnoDB Performance Optimization

In this blog, we will answer questions from our webinar on Percona XtraDB Cluster 101.
Recently (7 Dec 2017) I presented a webinar about Percona XtraDB Cluster 101. Firstly, thanks to all the attendees: we had a great webinar with quite some interesting questions and feedback.
Through this blog, I’ll answer most of the questions that […]

Read more

Demystifying Sequence Numbers (seqno) in Percona XtraDB Cluster

sequence numbers

In this blog post, we’ll look at how sequence numbers work in Percona XtraDB Cluster.
Introduction
Percona XtraDB Cluster uses multiple sequence numbers (seqno), each having a special role to play. Let’s try to understand the significance of each sequence number.
global_seqno

An active Percona XtraDB Cluster cluster has multiple write-sets (transactions) generated from one or more nodes. These […]

Read more