BestHub
Sign in
Tagged articles

xtrabackup

49 articles · Page 1 of 1
Raymond Ops
Raymond Ops
Aug 1, 2026 · Databases

Essential MySQL Backup and Recovery Process Every Ops Engineer Must Master

This comprehensive guide walks MySQL administrators through the fundamentals of backup and recovery, covering RPO/RTO concepts, tool comparisons (mysqldump, mydumper, xtrabackup), step‑by‑step scripts for full, incremental, and binlog backups, encryption, compression, troubleshooting, and best‑practice monitoring to ensure data safety and rapid restoration.

BackupDatabase OperationsMySQL
0 likes · 35 min read
Essential MySQL Backup and Recovery Process Every Ops Engineer Must Master
Ops Community
Ops Community
Jun 22, 2026 · Databases

Backup and Recovery: mysqldump / xtrabackup with Point‑In‑Time Recovery

This guide walks through practical MySQL backup and point‑in‑time recovery strategies using logical dumps with mysqldump and physical copies with Percona XtraBackup, covering configuration, command‑line examples, binlog handling, GTID/LSN concepts, incremental backups, restoration scripts, verification steps and common pitfalls for DBAs and DevOps engineers.

BackupDatabasesMySQL
0 likes · 44 min read
Backup and Recovery: mysqldump / xtrabackup with Point‑In‑Time Recovery
Ops Community
Ops Community
Jun 8, 2026 · Databases

Comparing MySQL Backup Solutions: From Tool Mechanics to Production-Ready Engineering Guide

This article analyzes common MySQL backup pitfalls, explains the three backup dimensions and five types, compares major tools such as mysqldump, mysqlpump, mydumper, XtraBackup and cloud snapshots, and provides practical scripts, sizing recommendations, scheduling, monitoring, recovery procedures, and failure case studies for reliable production backup engineering.

BackupMyDumperMySQL
0 likes · 52 min read
Comparing MySQL Backup Solutions: From Tool Mechanics to Production-Ready Engineering Guide
MaGe Linux Operations
MaGe Linux Operations
Apr 18, 2026 · Databases

Master MySQL 8.0 Backup & Recovery: Full Guide with Scripts, Strategies and Best Practices

This comprehensive guide explains why MySQL backup is essential, defines RPO/RTO, compares logical and physical tools, provides ready‑to‑run scripts for full, incremental, binlog, encryption and compression backups, details step‑by‑step recovery procedures, troubleshooting tips and monitoring recommendations for reliable database protection.

AutomationBackupDatabase Administration
0 likes · 35 min read
Master MySQL 8.0 Backup & Recovery: Full Guide with Scripts, Strategies and Best Practices
Senior Xiao Ying
Senior Xiao Ying
Feb 27, 2026 · Databases

How to Recover Lost MySQL Data: Physical, Logical, and PITR Backup Guide

This article provides a comprehensive MySQL data‑loss recovery guide, covering logical and physical backup methods, their advantages and drawbacks, detailed command‑line examples, XtraBackup installation, full and incremental backups, compression and streaming, and point‑in‑time recovery using binary logs, along with core backup best‑practice principles.

BackupLogical BackupMySQL
0 likes · 12 min read
How to Recover Lost MySQL Data: Physical, Logical, and PITR Backup Guide
Ops Community
Ops Community
Nov 23, 2025 · Databases

How to Recover Accidentally Dropped MySQL Data in 48 Hours – A Complete Step‑by‑Step Guide

This guide walks you through a full disaster‑recovery workflow for MySQL, covering emergency read‑only switching, pinpointing the deletion time via binlog, preparing a recovery instance, restoring the latest full backup with Xtrabackup or mysqldump, applying incremental binlog changes, verifying data integrity, and safely switching traffic back to the restored database.

BackupData RecoveryDisaster Recovery
0 likes · 42 min read
How to Recover Accidentally Dropped MySQL Data in 48 Hours – A Complete Step‑by‑Step Guide
MaGe Linux Operations
MaGe Linux Operations
Feb 9, 2025 · Databases

How to Recover Accidentally Deleted MySQL Tables: Real Enterprise Cases

This article presents two real‑world MySQL recovery scenarios—full backup restoration after an accidental table deletion and incremental recovery using XtraBackup—detailing backup strategies, binlog extraction, step‑by‑step commands, and validation procedures to safely restore production databases.

BackupDatabase RecoveryMySQL
0 likes · 10 min read
How to Recover Accidentally Deleted MySQL Tables: Real Enterprise Cases
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 13, 2024 · Databases

Understanding MySQL 8.0 Clone Plugin: Architecture, Implementation, and Comparison with Xtrabackup

This article explains the MySQL 8.0 Clone plugin introduced in version 8.0.17, compares it with Xtrabackup, details its five‑step cloning process, describes the code structure across SQL, plugin, and InnoDB layers, and outlines the page‑archiving subsystem used to track dirty pages during cloning.

Clone PluginDatabase ReplicationInnoDB
0 likes · 18 min read
Understanding MySQL 8.0 Clone Plugin: Architecture, Implementation, and Comparison with Xtrabackup
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 7, 2024 · Databases

Accelerating MySQL Data Recovery with Xtrabackup: Scenarios and Techniques

This article explains how DBA engineers can speed up MySQL data recovery using Xtrabackup by covering three scenarios—full backup with binlog, single-database restore, and single-table restore—detailing steps such as SQL thread replay, parallel replication, and transportable tablespace techniques with practical command examples.

BackupMySQLRecovery
0 likes · 21 min read
Accelerating MySQL Data Recovery with Xtrabackup: Scenarios and Techniques
dbaplus Community
dbaplus Community
Dec 3, 2023 · Databases

How Qunar Revamped Its Database Backup System for 27× Speed Gains

The article details Qunar’s senior DBA Qian Fangyuan’s redesign of the company’s database backup and recovery platform, explaining the shortcomings of the legacy system, the new architecture, high‑performance backup techniques using Xtrabackup, dynamic throttling, storage abstraction, and the resulting dramatic improvements in backup and restore speeds and reliability.

Dynamic ThrottlingStorage Interfacedatabase backup
0 likes · 35 min read
How Qunar Revamped Its Database Backup System for 27× Speed Gains
Qunar Tech Salon
Qunar Tech Salon
Nov 20, 2023 · Databases

Design and Implementation of a High‑Performance Database Backup and Recovery System

This article presents a comprehensive analysis of the shortcomings of an existing database backup solution and details the architecture, high‑performance backup and restore mechanisms, dynamic throttling, storage abstraction, and experimental results of a newly designed, scalable backup‑recovery platform for MySQL databases.

Dynamic ThrottlingMySQLdatabase backup
0 likes · 33 min read
Design and Implementation of a High‑Performance Database Backup and Recovery System
政采云技术
政采云技术
Dec 27, 2022 · Databases

Comprehensive Guide to MySQL Backup Types, Tools, and Procedures

This article provides an in‑depth overview of MySQL backup classifications—including hot, warm, and cold backups—explains physical versus logical backup methods, compares built‑in and third‑party tools such as mysqldump, mysqlhotcopy, LVM snapshots, XtraBackup, and presents step‑by‑step command examples for each approach.

BackupData RecoveryDatabases
0 likes · 14 min read
Comprehensive Guide to MySQL Backup Types, Tools, and Procedures
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 16, 2022 · Databases

Resolving Xtrabackup Backup Failures Caused by Too Many Open Files in MySQL

This article explains why Percona Xtrabackup backups of MySQL 5.7 can fail with "Too many open files" errors, demonstrates how to reproduce the issue under both non‑root and root users, analyzes the open‑files‑limit settings, and provides practical solutions to adjust system and user limits for successful backups.

BackupDatabase AdministrationLinux
0 likes · 12 min read
Resolving Xtrabackup Backup Failures Caused by Too Many Open Files in MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
May 26, 2022 · Databases

Resolving Xtrabackup Backup Failures Caused by Non‑Redo Logging DDL Operations in MySQL 5.7

This article analyses why physical backups using Xtrabackup fail when MySQL 5.7 performs online DDL operations that skip redo logging, demonstrates the issue with real‑world logs, and presents four practical solutions—including lock‑DDL parameters, per‑table MDL locks, and disabling online DDL—to ensure consistent backups.

DDLMySQLOnline DDL
0 likes · 23 min read
Resolving Xtrabackup Backup Failures Caused by Non‑Redo Logging DDL Operations in MySQL 5.7
Java High-Performance Architecture
Java High-Performance Architecture
Mar 20, 2022 · Databases

Master MySQL Data Recovery: From Full Backups to Point‑in‑Time Restoration

This guide explains how to prevent data loss in MySQL by enabling row‑based binlog, performing full restores with mysqldump or xtrabackup, executing point‑in‑time recovery, restoring individual tables, skipping erroneous SQL statements using binlog or GTID, and leveraging flashback tools such as binlog2sql and MyFlash.

BackupFlashbackMySQL
0 likes · 15 min read
Master MySQL Data Recovery: From Full Backups to Point‑in‑Time Restoration
Practical DevOps Architecture
Practical DevOps Architecture
Mar 14, 2022 · Databases

Step-by-Step MySQL Full and Incremental Backup & Restore Using XtraBackup

This tutorial walks through creating a MySQL database, setting up a backup user, performing full and incremental backups with XtraBackup, compressing and transferring backup files, and restoring the database by preparing logs, copying back data, fixing permissions, restarting MySQL, and verifying the restored data.

Command LineDatabase RestoreFull Backup
0 likes · 9 min read
Step-by-Step MySQL Full and Incremental Backup & Restore Using XtraBackup
IT Xianyu
IT Xianyu
Feb 14, 2022 · Databases

MySQL Data Recovery: Backup Strategies, Point‑in‑Time Restoration, Table Recovery, and Flashback Techniques

This article explains how to prevent data loss in MySQL by enabling binlog in ROW format, performing full and incremental restores using mysqldump or XtraBackup, executing point‑in‑time recovery, restoring individual tables, skipping erroneous SQL statements, and using flashback tools such as binlog2sql and MyFlash.

BackupData RecoveryFlashback
0 likes · 15 min read
MySQL Data Recovery: Backup Strategies, Point‑in‑Time Restoration, Table Recovery, and Flashback Techniques
Laravel Tech Community
Laravel Tech Community
Jun 29, 2021 · Databases

MySQL Data Recovery: Backup, Binlog, Point‑in‑Time Recovery and Tools

This article explains how to prevent data loss in MySQL by enabling backups and row‑based binlog, then details full‑volume recovery with mysqldump or xtrabackup, point‑in‑time restoration using binlog, table‑level recovery, skipping erroneous SQL statements, and introduces open‑source tools such as binlog2sql and MyFlash.

BackupMyFlashMySQL
0 likes · 15 min read
MySQL Data Recovery: Backup, Binlog, Point‑in‑Time Recovery and Tools
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Dec 21, 2020 · Databases

MySQL Backup and Recovery: Strategies, Tools, and Best Practices

This article explains the importance of MySQL backup and recovery, outlines common failure scenarios, recommends backup architectures and verification processes, reviews popular logical and physical backup tools such as mysqldump, mydumper, and xtrabackup, and shares practical case studies and best‑practice guidelines.

BackupDatabase AdministrationMySQL
0 likes · 10 min read
MySQL Backup and Recovery: Strategies, Tools, and Best Practices
vivo Internet Technology
vivo Internet Technology
Oct 14, 2020 · Databases

MySQL Clone Plugin – Installation, Usage, Progress Monitoring, Implementation Details, Limitations, and Comparison with XtraBackup

The MySQL Clone Plugin, added in 8.0.17, enables fast local or remote cloning of InnoDB data by installing the plugin, issuing CLONE commands, monitoring progress via performance_schema tables, and using the resulting GTID or binlog coordinates to build replicas, while observing limitations such as DDL restrictions and single‑instance operation, and offering advantages over XtraBackup through an extra page‑copy stage and simplified GTID handling.

Clone PluginInnoDBMySQL
0 likes · 22 min read
MySQL Clone Plugin – Installation, Usage, Progress Monitoring, Implementation Details, Limitations, and Comparison with XtraBackup
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 9, 2020 · Databases

Why Xtrabackup’s GTID Mismatch Happens: Deep Dive into MySQL 5.7 & 8.0 Backups

This article analyses why the GTID information recorded by Xtrabackup’s xtrabackup_binlog_info file can differ from the GTID shown by SHOW MASTER STATUS after a restore, comparing the behavior of Xtrabackup 2.4 on MySQL 5.7 and Xtrabackup 8.0 on MySQL 8.0, and explains the underlying backup processes and MySQL internals that cause the discrepancy.

BackupDatabase ReplicationGTID
0 likes · 14 min read
Why Xtrabackup’s GTID Mismatch Happens: Deep Dive into MySQL 5.7 & 8.0 Backups
dbaplus Community
dbaplus Community
Sep 25, 2019 · Databases

Master MySQL Backup & Disaster Recovery: Strategies, Tools, and Automation

Effective MySQL backup and disaster recovery are essential for protecting critical business data; this guide explains backup types, tools like Percona XtraBackup, scheduling, local and remote strategies, incremental processes, preparation and restoration steps, and introduces a platform for automated backup management.

AutomationBackupDatabase Management
0 likes · 26 min read
Master MySQL Backup & Disaster Recovery: Strategies, Tools, and Automation
37 Interactive Technology Team
37 Interactive Technology Team
Jun 20, 2019 · Databases

From Data Deletion to No Runaway – Building a Reliable Database Backup Platform

After costly data‑deletion mishaps, 37 Interactive Entertainment engineered a robust, multi‑region backup platform that evolved from simple cron scripts to streaming xtrabackup with Celery‑driven task queues, encrypted HDFS/S3 storage, automated rotation and restore verification, ensuring reliable protection against high‑impact data loss.

Backup ArchitectureData Recoverycelery
0 likes · 7 min read
From Data Deletion to No Runaway – Building a Reliable Database Backup Platform
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 25, 2019 · Databases

Understanding XtraBackup Full Backup Process for MySQL

This article explains MySQL backup classifications, then details XtraBackup's hot physical backup workflow—including redo‑log handling, global read‑lock usage, step‑by‑step file copying, and restore procedures—while addressing common FAQs and practical tips for ensuring data consistency.

BackupDatabaseFull Backup
0 likes · 6 min read
Understanding XtraBackup Full Backup Process for MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 5, 2019 · Databases

Guide to MySQL Transportable Tablespaces and Multi‑Source Replication Using XtraBackup

This article explains how to use MySQL's transportable tablespaces together with Percona XtraBackup to efficiently initialize data for multi‑source replication, covering prerequisites, the basic export/import workflow, detailed command‑line steps, and the configuration of replication channels.

Multi-Source ReplicationMySQLTransportable Tablespaces
0 likes · 11 min read
Guide to MySQL Transportable Tablespaces and Multi‑Source Replication Using XtraBackup
Tencent Database Technology
Tencent Database Technology
May 9, 2018 · Databases

Optimizing Xtrabackup Recovery Process for InnoDB Databases

Xtrabackup is an open-source hot backup tool for InnoDB and XtraDB databases, offering non-blocking backups with features like fast backup speeds, reliable physical backups, and efficient disk space usage. The recovery process involves complex log parsing and page flushing mechanisms, which can be optimized to improve performance, especially for large datasets.

Backup ToolsDatabase ManagementDatabase Recovery
0 likes · 16 min read
Optimizing Xtrabackup Recovery Process for InnoDB Databases
ITPUB
ITPUB
Jun 15, 2017 · Databases

Mastering MySQL Backups: From Cold Copies to Xtrabackup Strategies

This guide explains MySQL backup fundamentals, comparing cold backups, LVM snapshot backups, logical tools like mysqldump and mydumper, and physical solutions such as Percona Xtrabackup, detailing each method’s workflow, advantages, limitations, and how to achieve consistent recovery points and times.

BackupLVMMyDumper
0 likes · 10 min read
Mastering MySQL Backups: From Cold Copies to Xtrabackup Strategies
ITPUB
ITPUB
May 9, 2016 · Databases

Mastering MySQL Backups: From Cold Copies to Xtrabackup and Beyond

This article explains MySQL backup fundamentals, compares cold, snapshot, logical (mysqldump, mydumper) and physical (Xtrabackup) methods, outlines their workflows, pros and cons, and discusses lock‑related performance impacts and Percona's backup‑lock improvements.

BackupDatabasesLVM
0 likes · 11 min read
Mastering MySQL Backups: From Cold Copies to Xtrabackup and Beyond
MaGe Linux Operations
MaGe Linux Operations
May 5, 2016 · Databases

Mastering MySQL Backups: Strategies, Types, and Tools for Reliable Data Protection

This guide explains why data backup is essential, outlines backup types (full, incremental, differential), compares MySQL backup methods (hot, warm, cold), evaluates physical vs logical approaches, reviews common tools like mysqldump, cp, tar, LVM snapshots, and xtrabackup, and offers strategies for choosing the right solution.

BackupDatabasedata protection
0 likes · 8 min read
Mastering MySQL Backups: Strategies, Types, and Tools for Reliable Data Protection
Architect
Architect
Mar 19, 2016 · Databases

Understanding Percona XtraBackup (PXB) Architecture and Backup Process

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.

BackupInnoDBMySQL
0 likes · 10 min read
Understanding Percona XtraBackup (PXB) Architecture and Backup Process
21CTO
21CTO
Sep 20, 2015 · Databases

Master MySQL Backup & Recovery: Mysqldump, LVM Snapshots, and Xtrabackup Explained

This tutorial walks through three MySQL backup and recovery strategies—using mysqldump with binary logs, LVM snapshots with binary logs, and Percona Xtrabackup—detailing environment setup, command syntax, incremental procedures, and restoration steps to ensure data safety and minimal downtime.

BackupBinary LogLVM
0 likes · 21 min read
Master MySQL Backup & Recovery: Mysqldump, LVM Snapshots, and Xtrabackup Explained