Tagged articles

Physical Backup

8 articles · Page 1 of 1
Tencent Cloud Developer
Tencent Cloud Developer
Jun 30, 2026 · Databases

How Kernel Optimizations Cut MongoDB Physical Backup Disk Bloat by 90%

MongoDB’s physical backup can cause hidden nodes to balloon in disk usage, but by analyzing WiredTiger’s space‑reclamation process and introducing a checkpoint‑release API, the team reduced backup‑induced disk expansion from up to 200% down to under 10%, saving hundreds of gigabytes and cutting backup time by over 40%.

Checkpoint ReleaseDisk BloatKernel Optimization
0 likes · 19 min read
How Kernel Optimizations Cut MongoDB Physical Backup Disk Bloat by 90%
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
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
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