Tagged articles
Percona XtraBackup
16 articles · Page 1 of 1
This step‑by‑step tutorial shows how to install Percona XtraBackup 2.4, create full, incremental and compressed backups of MySQL 5.1‑5.7, prepare the backups, and restore data using Docker or native Linux packages.
CompressionDockerLinux
0 likes · 11 min read

This article evaluates MySQL backup strategies using Percona XtraBackup, comparing local, remote, and streaming modes in terms of backup duration, primary server load impact, and backup file size, and provides practical recommendations based on detailed test results.
CompressionMySQLPercona XtraBackup
0 likes · 17 min read

This article explains why MySQL backups are essential, defines RTO and RPO, compares physical and logical backup methods, describes snapshot, binary‑log, incremental and differential strategies, and provides best‑practice recommendations and example commands for reliable backup and recovery.
MySQLPercona XtraBackupRPO
0 likes · 13 min read

This guide outlines a comprehensive MySQL backup solution, covering backup strategy planning, choosing physical versus logical backups, using tools like mysqldump and Percona XtraBackup, automating backups with scripts and cron, storage and retention considerations, and regular recovery testing to ensure data integrity.
MySQLPercona XtraBackupautomation
0 likes · 5 min read

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

This article explains the differences between MySQL logical and physical backups, introduces Percona XtraBackup, provides step‑by‑step installation commands, details common parameters, and demonstrates full and incremental backup and recovery workflows with practical code examples.
Logical BackupMySQLPercona XtraBackup
0 likes · 13 min read

This article walks through a step‑by‑step investigation of why incremental backups failed on a DBaaS platform, revealing that the PERCONA_SCHEMA.xtrabackup_history table’s binlog_pos column was too short, and shows how altering its length resolves the problem.
Backup FailureMySQLPercona XtraBackup
0 likes · 10 min read

This guide explains how to prepare the environment, install required dependencies and a newer GCC toolset, and then compile, build, and install Percona XtraBackup 8.0 from source on an Aarch64 Kylin v10 system, including troubleshooting tips for common issues.
LinuxMySQLPercona XtraBackup
0 likes · 9 min read

The article investigates a production MySQL outage caused by FLUSH NO_WRITE_TO_BINLOG TABLES blocking during backups, presents three experimental scenarios to identify the root cause, and offers practical recommendations such as setting query timeouts, adding indexes, and using Percona XtraBackup options to avoid backup stalls.
MySQLPercona XtraBackupdatabase optimization
0 likes · 19 min read

This article explains the importance of MySQL backups, compares common logical and physical backup tools such as mysqldump, Mydumper and Percona XtraBackup, details XtraBackup's step‑by‑step workflow, lock handling options, and provides practical Q&A for reliable database backup strategies.
InnoDBMySQLPercona XtraBackup
0 likes · 18 min read

This guide walks through downloading and installing Percona XtraBackup on a CentOS server, then demonstrates how to create full backups, remove timestamps, inspect backup contents, and execute incremental backups with detailed command examples and explanations.
CentOSPercona XtraBackupdatabase
0 likes · 5 min read

This article provides a step‑by‑step tutorial for migrating MySQL databases—whether hosted on Amazon RDS or self‑managed servers—to Amazon Aurora, covering four scenarios from simple snapshot migration with downtime to complex minimal‑downtime approaches using read replicas, Percona XtraBackup, and AWS DMS.
AWSAWS DMSAmazon Aurora
0 likes · 13 min read

This article details Qunar's comprehensive MySQL backup and recovery platform, covering high‑availability concepts, backup types, tool selection, multi‑channel architecture, storage solutions, automation, and operational lessons for scaling DBA operations across large‑scale deployments.
DBAHigh AvailabilityMySQL
0 likes · 15 min read


ITPUBAug 15, 2016 · Databases
This article analyzes two deadlock cases that occur when running Percona‑XtraBackup on a MySQL 5.6 replica, explains the underlying lock interactions, shows how to reproduce the issue with SystemTap, and provides safe remediation steps for operators.
MySQLPercona XtraBackupReplication
0 likes · 11 min read

This article explains the components, communication mechanisms, full and incremental backup procedures, and restoration steps of Percona XtraBackup (PXB), detailing how the innobackupex script and xtrabackup binary cooperate to perform hot physical backups of MySQL/InnoDB databases.
InnoDBMySQLPercona XtraBackup
0 likes · 10 min read

This guide explains how Percona XtraBackup works for MySQL hot backups, covering required permissions, key terminology, backup and incremental backup mechanisms, essential command‑line options, and practical script examples to ensure reliable, low‑impact data protection.
InnoDBPercona XtraBackupdatabase administration
0 likes · 12 min read
