BestHub
Sign in
Tagged articles
45 articles
Page 1 of 1
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
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.

BackupBinlogData 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.

BackupBinlogDatabase Recovery
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.

BackupRecoveryReplication
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.

Database BackupDynamic ThrottlingPerformance Optimization
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.

Database BackupDynamic Throttlinghigh performance
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 RecoveryLVM
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.

DDLOnline DDLSorted Index Build
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.

BackupBinlogFlashback
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.

Database RestoreFull BackupIncremental 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.

BackupBinlogData Recovery
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.

BackupBinlogMyFlash
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 AdministrationRecovery
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 PluginDatabase BackupInnoDB
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.

BackupBinlogDatabase Replication
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
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 26, 2019 · Databases

Practical Guide to MySQL Clone Plugin: Local and Remote Cloning, Setup, Monitoring, and Comparison with XtraBackup

This article provides a comprehensive tutorial on MySQL 8.0's Clone Plugin, covering its concepts, local and remote cloning procedures, required permissions, configuration steps, monitoring queries, and a detailed comparison with XtraBackup for fast data replication and recovery.

BackupClone PluginPerformance Monitoring
0 likes · 13 min read
Practical Guide to MySQL Clone Plugin: Local and Remote Cloning, Setup, Monitoring, and Comparison with XtraBackup
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 RecoveryDatabase Backup
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.

BackupFull BackupInnoDB
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 ReplicationTransportable Tablespacesmysql
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
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Apr 13, 2017 · Databases

How to Quickly Recover a Single MySQL Table with XtraBackup

This guide explains how to use Percona XtraBackup for fast single‑table recovery in both local full‑backup and remote streaming scenarios, detailing preparation steps, command examples, and essential configuration tweaks to minimize downtime and data loss.

BackupDatabase RecoverySingle Table Restore
0 likes · 7 min read
How to Quickly Recover a Single MySQL Table with XtraBackup
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.

BackupLVMdatabases
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.

BackupData Protectiondatabase
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.

BackupInnoDBPercona XtraBackup
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.

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