Tagged articles

SST

3 articles · Page 1 of 1

Jul 31, 2023 · Databases

Percona XtraBackup 8.0.33-28 Accelerates Backup Preparation by Up to 20×

This article explains how Percona XtraBackup 8.0.33-28 introduces a new design that reduces the time required for the backup‑prepare phase, lowers memory and I/O usage, and speeds up SST when adding new nodes to a Percona XtraDB Cluster, with detailed performance benchmarks and code examples.

InnoDBMySQLPercona XtraBackup

0 likes · 9 min read

Percona XtraBackup 8.0.33-28 Accelerates Backup Preparation by Up to 20×

Didi Tech

Jul 27, 2018 · Databases

Root Cause and Fix for Galera MySQL 5.7.17 SST Failure Caused by innodb_undo_table_spaces with RSYNC

The Galera MySQL 5.7.17 SST fails when a pre‑initialized node is added because the rsync‑based SST filter omits the independent undo‑log tablespace files (undo*), causing InnoDB to roll back uncommitted transactions; adding an undo* rule to the filter copies the missing files and resolves the error, a fix now upstream.

DatabaseGaleraMySQL

0 likes · 4 min read

Root Cause and Fix for Galera MySQL 5.7.17 SST Failure Caused by innodb_undo_table_spaces with RSYNC

dbaplus Community

Sep 1, 2016 · Databases

How to Safely Backup a MySQL Galera Cluster Using State Snapshot Transfer

This guide explains how to back up a MySQL Galera Cluster by leveraging the State Snapshot Transfer (SST) mechanism, detailing the default and custom scripts, required parameters, execution flow, and the key benefits of using SST for point‑in‑time, non‑intrusive backups.

DatabaseGaleraMySQL

0 likes · 9 min read

How to Safely Backup a MySQL Galera Cluster Using State Snapshot Transfer