MySQL

Optimizing PXC Xtrabackup State Snapshot Transfer

State Snapshot Transfer (SST) at a glance
PXC uses a protocol called State Snapshot Transfer to provision a node joining an existing cluster with all the data it needs to synchronize.  This is analogous to cloning a slave in asynchronous replication:  you take a full backup of one node and copy it to the new […]

Read more

How much could you benefit from MySQL 5.6 parallel replication?

I have heard this question quite often: “At busy times, our replicas start lagging quite frequently. We are using N schemas, so which performance boost could we expect from MySQL 5.6 parallel replication?” Here is a quick way to give you a rough estimate of the potential benefit.
General idea
In MySQL 5.6, parallelism is added […]

Read more

MySQL is crashing: a support engineer’s point of view

In MySQL QA Episode #12, “MySQL is Crashing, now what?,” Roel demonstrated how to collect crash-related information that will help Percona discover what the issue is that you are experiencing, and fix it.
As a Support Engineer I (Sveta) am very happy to see this post – but as a person who better understands writing than recording – […]

Read more

The language of compression

Leif Walsh will talk about the language of compression at Percona Live Amsterdam
Storage. Everyone needs it. Whether your data is in MySQL, a NoSQL, or somewhere in the cloud, with ever-growing data volumes – along with the need for SSDs to cut latency and replication to provide insurance – an organization’s storage footprint is […]

Read more

MySQL Quality Assurance: A Vision for the Future by Roel Van de Paar (Final Episode 13)

MySQL Quality Assurance

Welcome to the final – but most important – episode in the MySQL QA Series.
In it, I present my vision for all MySQL Quality Assurance – for all distributions – worldwide.
Episode 13: A Better Approach to all MySQL Regression, Stress & Feature Testing: Random Coverage Testing & SQL Interleaving
1. pquery Review
2. Random Coverage Testing
3. SQL […]

Read more