Author - Krunal Bauskar

Q&A: “Percona XtraDB Cluster 5.7 and ProxySQL for Your High Availability Needs” Webinar

High Availability

On March 22, 2018, we held a webinar on how Percona XtraDB cluster 5.7 (PXC) and ProxySQL can help achieve your database clustering high availability needs. Firstly, thanks to all the attendees for taking time to attend the webinar and we are sure you had a webinar experience. We tried answering some of your […]

Read more

FLUSH and LOCK Handling in Percona XtraDB Cluster

FLUSH and LOCK Handling

In this blog post, we’ll look at how Percona XtraDB Cluster (PXC) executes FLUSH and LOCK handling.
Introduction
Percona XtraDB Cluster is a multi-master solution that allows parallel execution of the transactions on multiple nodes at the same point in time. Given this semantics, it is important to understand how Percona XtraDB Cluster executes statements regarding FLUSH and […]

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

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

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

Webinar Thursday, December 7, 2017: Percona XtraDB Cluster (PXC) 101

High Availability

Join Percona’s Software Engineer (PXC Lead), Krunal Bauskar as he presents Percona XtraDB Cluster 101 on Thursday, December 7, 2017, at 7:00 am PST / 10:00 am EST (UTC-8).
Tags: Percona XtraDB Cluster, MySQL, High Availability, Clustering
Experience Level: Beginner
Percona XtraDB Cluster (PXC) is a multi-master solution that offers virtual synchronous replication among clustering node. It […]

Read more

Understanding how an IST donor is selected

IST donor cluster

In a clustering environment, we often see a node that needs to be taken down for maintenance. For a node to rejoin, it should re-sync with the cluster state. In PXC (Percona XtraDB Cluster), there are 2 ways for the rejoining node to re-sync: State Snapshot Transfer (SST) and Incremental State Transfer (IST). SST […]

Read more

Faster Node Rejoins with Improved IST performance

IST Performance

In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
Introduction
Starting in version 5.7.17-29.20 of Percona XtraDB Cluster significantly improved performance. Depending on the workload, the increase in throughput is in the range of 3-10x. (More details here). These optimization fixes also helped improve IST (Incremental State Transfer) performance. This blog […]

Read more

Differences in PREPARE Statement Error Handling with Binary and Text Protocol (Percona XtraDB Cluster / Galera)

PREPARE Statement

In this blog, we’ll look at the differences in how a PREPARE statement handles errors in binary and text protocols.
Introduction
Since Percona XtraDB Cluster is a multi-master solution, when an application executes conflicting workloads one of the workloads gets rolled back with a DEADLOCK error. While the same holds true even if you fire the […]

Read more