BestHub
Sign in
Tagged articles

Logical Backup

10 articles · Page 1 of 1
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.

BinlogLogical BackupMySQL
0 likes · 12 min read
How to Recover Lost MySQL Data: Physical, Logical, and PITR Backup Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 6, 2026 · Databases

Rebuilding a MySQL Replica Fast with MyDumper and MyLoader

This guide explains how to use MyDumper for logical backups and MyLoader for fast, parallel replica reconstruction, covering backup parameters, metadata configuration, replication setup, handling faulty replicas, and final restoration steps to ensure data consistency and minimal downtime.

Logical BackupMyLoaderMySQL
0 likes · 11 min read
Rebuilding a MySQL Replica Fast with MyDumper and MyLoader
Laravel Tech Community
Laravel Tech Community
Jun 7, 2023 · Databases

MySQL Logical vs Physical Backup and Percona XtraBackup Installation, Configuration, and Backup/Restore Procedures

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.

Database AdministrationIncremental BackupLogical Backup
0 likes · 13 min read
MySQL Logical vs Physical Backup and Percona XtraBackup Installation, Configuration, and Backup/Restore Procedures
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 16, 2023 · Databases

Comprehensive Guide to Percona Backup for MongoDB: Architecture, Installation, Full and Incremental Backups, and Restoration

This article provides an in‑depth overview of Percona Backup for MongoDB (PBM), covering its architecture, installation steps, configuration, logical full backups, point‑in‑time incremental backups, restoration procedures, performance testing, selective backup options, known limitations, and useful command‑line examples.

Logical BackupMongoDBPBM
0 likes · 16 min read
Comprehensive Guide to Percona Backup for MongoDB: Architecture, Installation, Full and Incremental Backups, and Restoration
dbaplus Community
dbaplus Community
May 28, 2022 · Databases

Mastering MySQL Backups: Strategies, Tools, and RTO/RPO Optimization

This article explains why backup is the last line of data security, outlines multi‑location and multi‑media deployment requirements, compares physical and logical backup methods, reviews MySQL backup tools, evaluates their speed, and provides practical guidance for testing backup validity and minimizing RTO and RPO.

Backup ToolsLogical BackupMySQL
0 likes · 14 min read
Mastering MySQL Backups: Strategies, Tools, and RTO/RPO Optimization
Efficient Ops
Efficient Ops
Oct 20, 2021 · Databases

Mastering MySQL Backups: Strategies, Tools, and RTO/RPO Optimization

This article explains why database backup is essential, outlines multi‑region and multi‑media deployment requirements, compares physical and logical backup methods, reviews MySQL backup tools, shows performance differences, and provides practical guidance on verifying backup integrity and minimizing RTO and RPO.

Logical BackupPhysical BackupRPO
0 likes · 12 min read
Mastering MySQL Backups: Strategies, Tools, and RTO/RPO Optimization
JD Retail Technology
JD Retail Technology
Sep 5, 2019 · Databases

CB‑SQL Backup and Restore: Logical and Physical Methods

This article explains CB‑SQL's two backup approaches—logical (using DUMP and IMPORT) and physical (using BACKUP and RESTORE)—detailing their mechanisms, supported formats, storage options, performance characteristics, and how they ensure reliable data recovery for large‑scale distributed databases.

CB-SQLLogical BackupPhysical Backup
0 likes · 7 min read
CB‑SQL Backup and Restore: Logical and Physical Methods
ITPUB
ITPUB
Jan 8, 2016 · Databases

How Facebook Scales MySQL Backups: Strategies, Storage, and Incremental Techniques

This article explains Facebook's large‑scale MySQL backup architecture, covering the Python‑based automation framework, master‑slave deployment, logical mysqldump backups, warm and cold storage locations, source selection heuristics, full and incremental backup pipelines, verification processes, and future RBR‑based improvements.

FacebookHDFSIncremental Backup
0 likes · 15 min read
How Facebook Scales MySQL Backups: Strategies, Storage, and Incremental Techniques
dbaplus Community
dbaplus Community
Dec 30, 2015 · Databases

How Facebook Scales MySQL Backups: Strategies, Storage, and Validation

This article details Facebook's MySQL backup architecture, covering preparation, logical backup format, storage locations, source selection, full and incremental backup pipelines, verification mechanisms, and future directions such as RBR‑based logical incremental backups.

FacebookHDFSIncremental Backup
0 likes · 14 min read
How Facebook Scales MySQL Backups: Strategies, Storage, and Validation