Tagged articles
Logical Backup
10 articles · Page 1 of 1
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.
Logical BackupMySQLPITR
0 likes · 12 min read

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 BackupMyDumperMyLoader
0 likes · 11 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 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

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.
Logical BackupMySQLPhysical Backup
0 likes · 14 min read

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

The article explains MySQL logical and physical backup methods, compares online and offline backup approaches, details the advantages and disadvantages of each, and provides practical mysqldump commands and master‑slave backup techniques for reliable database protection.
Logical BackupMySQLPhysical Backup
0 likes · 8 min read

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


ITPUBJan 8, 2016 · Databases
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.
FacebookHDFSLogical Backup
0 likes · 15 min read

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.
FacebookHDFSLogical Backup
0 likes · 14 min read
