Tag - mysql-and-variants

Webinar May 26: What’s New in Percona XtraDB Cluster (PXC) 8.0?

During this webinar, Tyler Duzan, Product Manager for MySQL and Cloud at Percona, will discuss Percona’s decision to delay Percona XtraDB Cluster 8.0 to ship it with Galera 4 instead of Galera 3, and why that matters. In addition, he’ll talk about the work done to integrate MySQL 8.0 features with Galera as well […]

Read more

New Feature in Percona XtraDB Cluster 8.0 – Streaming Replication

Percona XtraDB Cluster Streaming Replication

Percona XtraDB Cluster 8.0 comes with an upgraded Galera 4.0 library, which provides a new feature – streaming replication. Let’s review what it is and when it might be helpful.
Previous versions of Percona XtraDB Cluster with Galera 3.x had a limitation in how big transactions are handled.
Let’s review the performance under sysbench-tpcc workload when […]

Read more

Tuning MySQL/InnoDB Flushing for a Write-Intensive Workload

MySQL InnoDB Flushing

In this post, the third in a series explaining the internals of InnoDB flushing, we’ll focus on tuning. (Others in the series can be seen at InnoDB Flushing in Action for Percona Server for MySQL and Give Love to Your SSDs – Reduce innodb_io_capacity_max!)
Understanding the tuning process is very important since we don’t want to […]

Read more

Galera 4 Streaming Replication in Percona XtraDB Cluster 8.0

Galera 4 Streaming Replication in Percona XtraDB Cluster

I was testing the latest Percona XtraDB Cluster 8.0 (PXC) release which has the Galera 4 plugin, and I would like to share my experiences and thoughts on the Streaming Replication feature so far.
What Is Streaming Replication, in One Sentence?
In Galera 4, the large transaction could split into smaller fragments, and even before it […]

Read more

Multithreaded ALTER TABLE with pt-online-schema-change and myloader

multithreaded alter table

pt-online-schema-change emulates the way that MySQL alters tables internally, but it works on a copy of the table you wish to alter. It executes INSERT statements to import the data, that runs in a single connection to fill the new table. In this repository, there is a script called myloader_pt-osc.sh that uses myloader to […]

Read more