# galera

Published articles for galera.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## How Linux Large Folios Can Amplify Disk Writes in PXC/Galera Workloads

DevFeed: [How Linux Large Folios Can Amplify Disk Writes in PXC/Galera Workloads](<https://devfeed.tech/articles/when-a-small-change-writes-too-much-how-a-linux-kernel-improvement-can-strike-you-in-pxc-galera-workloads-88718.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/when-a-small-change-writes-too-much-how-a-linux-kernel-improvement-can-strike-you-in-pxc-galera-workloads/>)

Author: Przemysław Malkowski

Published: 2026-10-16T12:58:08Z

Content type: article

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [XtraDB Cluster (PXC)](<https://devfeed.tech/topics/xtradb-cluster-pxc.md>), [Linux Kernel](<https://devfeed.tech/topics/linux-kernel.md>), [XFS](<https://devfeed.tech/topics/xfs.md>)

Tags: [galera](<https://devfeed.tech/tags/galera.md>), [hardware-and-storage](<https://devfeed.tech/tags/hardware-and-storage.md>), [insight-for-dbas](<https://devfeed.tech/tags/insight-for-dbas.md>), [large-folios](<https://devfeed.tech/tags/large-folios.md>), [mariadb](<https://devfeed.tech/tags/mariadb.md>), [mmap](<https://devfeed.tech/tags/mmap.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [page-cache](<https://devfeed.tech/tags/page-cache.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [xtradb-cluster-pxc](<https://devfeed.tech/tags/xtradb-cluster-pxc.md>)

### AI overview

An investigation into periodic disk-write bursts in a PXC/Galera cluster links the behavior to Linux large folios after an operating system upgrade. Galera's memory-mapped cache can trigger writeback of entire folios for small updates, amplifying disk writes. The article explains why InnoDB writes behaved differently and discusses diagnostic signals and possible workarounds.

### Source excerpt

We've recently been dealing with an interesting customer case where a PXC version upgrade from 5.7 to 8.0 seemed to trigger a completely unexpected problem. Even though the workload and MySQL settings did not change, all PXC members began exhibiting sparse but regular bursts of massive disk writes. Yet the MySQL side workload statistics that ... Continued The post When a Small Change Writes Too Much - How A Linux Kernel Improvement Can Strike You in PXC/Galera Workloads appeared first on Percona.

## Your Galera cluster's hardest problem was never the replication library

DevFeed: [Your Galera cluster's hardest problem was never the replication library](<https://devfeed.tech/articles/your-galera-cluster-s-hardest-problem-was-never-the-replication-library-77304.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/your-galera-clusters-hardest-problem-was-never-the-replication-library/>)

Author: Valeria Bogatyreva

Published: 2026-10-08T16:07:52Z

Content type: opinion

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [XtraDB Cluster (PXC)](<https://devfeed.tech/topics/xtradb-cluster-pxc.md>), [site-reliability-engineering](<https://devfeed.tech/topics/site-reliability-engineering.md>), [Service fabric](<https://devfeed.tech/topics/service-fabric.md>)

Tags: [concurrent](<https://devfeed.tech/tags/concurrent.md>), [error](<https://devfeed.tech/tags/error.md>), [galera](<https://devfeed.tech/tags/galera.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [percona](<https://devfeed.tech/tags/percona.md>), [percona-announcements](<https://devfeed.tech/tags/percona-announcements.md>), [production](<https://devfeed.tech/tags/production.md>), [replication](<https://devfeed.tech/tags/replication.md>), [xtradb-cluster-pxc](<https://devfeed.tech/tags/xtradb-cluster-pxc.md>)

### AI overview

The article argues that production incidents in MySQL Galera Cluster are often difficult because diagnosing the cause takes longer than fixing it. It describes Percona MySQL Support for existing clusters and Percona XtraDB Cluster as options following the end of support for current MySQL Galera Cluster versions, emphasizing support, migration, and continued MySQL compatibility.

### Source excerpt

Ask anyone who runs a multi-node MySQL Galera Cluster in production about their worst night. Almost nobody says write-set replication was wrong. They say something closer to this: "All queries piling up... no error messages in logs." Twenty minutes of downtime, ended only when a human picked a node to kill. (codership-team) Or the flow-control ... Continued The post Your Galera cluster's hardest problem was never the replication library appeared first on Percona.

## When pt-online-schema-change "where" Meets Galera: Understanding Chunk Auto-Resize and Flow Control

DevFeed: [When pt-online-schema-change "where" Meets Galera: Understanding Chunk Auto-Resize and Flow Control](<https://devfeed.tech/articles/when-pt-online-schema-change-where-meets-galera-understanding-chunk-auto-resize-and-flow-control-61217.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/when-pt-online-schema-change-where-meets-galera-understanding-chunk-auto-resize-and-flow-control/>)

Author: Corrado Pandiani

Published: 2026-09-28T13:56:53Z

Content type: article

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [XtraDB Cluster (PXC)](<https://devfeed.tech/topics/xtradb-cluster-pxc.md>), [downtime](<https://devfeed.tech/topics/downtime.md>)

Tags: [downtime](<https://devfeed.tech/tags/downtime.md>), [flow](<https://devfeed.tech/tags/flow.md>), [galera](<https://devfeed.tech/tags/galera.md>), [insight-for-dbas](<https://devfeed.tech/tags/insight-for-dbas.md>), [insight-for-developers](<https://devfeed.tech/tags/insight-for-developers.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [percona-software](<https://devfeed.tech/tags/percona-software.md>), [percona-xtradb-cluster](<https://devfeed.tech/tags/percona-xtradb-cluster.md>), [pt-onine-schema-change](<https://devfeed.tech/tags/pt-onine-schema-change.md>), [pxc](<https://devfeed.tech/tags/pxc.md>), [resize](<https://devfeed.tech/tags/resize.md>), [toolkit](<https://devfeed.tech/tags/toolkit.md>), [xtradb-cluster-pxc](<https://devfeed.tech/tags/xtradb-cluster-pxc.md>)

### AI overview

The article examines how pt-online-schema-change's adaptive chunk sizing can cause severe Galera Flow Control when a selective WHERE clause discards most rows during a copy. It describes a Percona XtraDB Cluster case and says the article proposes practical mitigations, though the supplied excerpt ends before those details.

### Source excerpt

Percona Toolkit's pt-online-schema-change (pt-osc) has long been the preferred solution for performing online schema changes with minimal downtime. Its chunk-based copy algorithm is designed to adapt dynamically to the workload, making it suitable for very large tables in production environments. However, under specific conditions, one of its optimization mechanisms can become counterproductive. During a customer ... Continued The post When pt-online-schema-change "where" Meets Galera: Understanding Chunk Auto-Resize and Flow Control appeared first on Percona.

## Too many GCache Page Files in MySQL Data Directory

DevFeed: [Too many GCache Page Files in MySQL Data Directory](<https://devfeed.tech/articles/too-many-gcache-page-files-in-mysql-data-directory-35043.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/too-many-gcache-page-files-in-mysql-data-directory/>)

Author: Kedar Vaijanapurkar

Published: 2026-09-17T05:29:14Z

Content type: tutorial

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [XtraDB Cluster (PXC)](<https://devfeed.tech/topics/xtradb-cluster-pxc.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [Transactions](<https://devfeed.tech/topics/transactions.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>)

Tags: [cluster](<https://devfeed.tech/tags/cluster.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [disk-space](<https://devfeed.tech/tags/disk-space.md>), [galera](<https://devfeed.tech/tags/galera.md>), [galera-replication](<https://devfeed.tech/tags/galera-replication.md>), [gcache](<https://devfeed.tech/tags/gcache.md>), [gcache-freeze-purge-at-seqno](<https://devfeed.tech/tags/gcache-freeze-purge-at-seqno.md>), [gcache-keep-pages-count](<https://devfeed.tech/tags/gcache-keep-pages-count.md>), [gcache-page](<https://devfeed.tech/tags/gcache-page.md>), [gcache-page-files](<https://devfeed.tech/tags/gcache-page-files.md>), [gcache-purge](<https://devfeed.tech/tags/gcache-purge.md>), [gcache-troubleshooting](<https://devfeed.tech/tags/gcache-troubleshooting.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [mysql-disk-space](<https://devfeed.tech/tags/mysql-disk-space.md>), [mysql-troubleshooting](<https://devfeed.tech/tags/mysql-troubleshooting.md>), [percona-xtradb-cluster](<https://devfeed.tech/tags/percona-xtradb-cluster.md>), [pxc](<https://devfeed.tech/tags/pxc.md>), [replication](<https://devfeed.tech/tags/replication.md>), [xtradb-cluster-pxc](<https://devfeed.tech/tags/xtradb-cluster-pxc.md>)

### AI overview

An investigation into thousands of GCache page files accumulating in a Percona XtraDB Cluster data directory. The article explains how frozen GCache purging caused disk growth, links the behavior to a cluster partition, and describes reproducing it by setting gcache.freeze_purge_at_seqno and generating workload.

### Source excerpt

Learn why PXC accumulates thousands of gcache.page.* files, how frozen GCache purging causes disk growth, and how to safely recover and rejoin using IST. The post Too many GCache Page Files in MySQL Data Directory appeared first on Percona.

## Enabling TLS in PXC without Downtime

DevFeed: [Enabling TLS in PXC without Downtime](<https://devfeed.tech/articles/enabling-tls-in-pxc-without-downtime-14095.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/enabling-tls-in-pxc-without-downtime/>)

Author: Juan Arruti

Published: 2026-09-09T23:32:15Z

Content type: tutorial

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [TLS (Transport Layer Security)](<https://devfeed.tech/topics/tls.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [Security](<https://devfeed.tech/topics/security.md>), [Network](<https://devfeed.tech/topics/network.md>), [openssl](<https://devfeed.tech/topics/openssl.md>)

Tags: [galera](<https://devfeed.tech/tags/galera.md>), [high-availability](<https://devfeed.tech/tags/high-availability.md>), [insight-for-dbas](<https://devfeed.tech/tags/insight-for-dbas.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [percona](<https://devfeed.tech/tags/percona.md>), [pxc](<https://devfeed.tech/tags/pxc.md>), [replication](<https://devfeed.tech/tags/replication.md>), [security](<https://devfeed.tech/tags/security.md>), [ssl](<https://devfeed.tech/tags/ssl.md>), [tls](<https://devfeed.tech/tags/tls.md>), [tls-handshake](<https://devfeed.tech/tags/tls-handshake.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [xtradb-cluster-pxc](<https://devfeed.tech/tags/xtradb-cluster-pxc.md>)

### AI overview

This tutorial explains how to enable TLS for replication traffic in Percona XtraDB Cluster without a full cluster restart. Using Galera's socket.dynamic option, operators can perform two rolling restarts: first allowing encrypted and plaintext connections, then enforcing TLS-only communication.

### Source excerpt

Starting with Percona XtraDB Cluster (PXC) 8.0, replication traffic encryption is enabled by default. That said, it's common to find clusters running without TLS that suddenly need it: a new compliance requirement, an audit finding, a network segment that is no longer considered trusted. PXC has a variable for exactly that case, pxc-encrypt-cluster-traffic, which handles ... Continued The post Enabling TLS in PXC without Downtime appeared first on Percona.