Tagged articles
incremental backup
16 articles · Page 1 of 1
This article explains the 3-2-1 backup principle—keep three copies of data on two different media with one offsite—covers why backups are essential, what data to prioritize, compares backup methods like external drives and cloud storage, details full/incremental/differential strategies, recommends automation tools, and stresses the critical importance of regularly testing restores.
3-2-1 rulebackup strategiesbackup tools
0 likes · 8 min read

This article explains Oracle database backup and recovery fundamentals, covering failure types, logical vs physical backup, RMAN configuration, level 0/1 incremental backup scripts with cron scheduling, flashback technology, and complete vs incomplete recovery methods.
FlashbackOracleRMAN
0 likes · 7 min read

This guide walks through the fundamentals of rsync incremental backups, explaining the delta algorithm, file comparison rules, optimal parameter choices, real‑world performance comparisons, and step‑by‑step scripts for installation, daily cron jobs, link‑dest rotation, real‑time syncing with inotify, and robust monitoring and error handling.
Linuxbackupcron
0 likes · 49 min read

This guide walks through five practical MySQL backup and restoration workflows—including scheduled full backups, hourly incremental binlog backups for high‑frequency trading, development‑environment data masking, selective table dumps, and cold‑storage disaster recovery—providing exact commands, configuration tweaks, and step‑by‑step procedures.
MySQLRecoverybackup
0 likes · 7 min read


21CTOSep 27, 2024 · Databases
PostgreSQL 17 introduces a highly optimized incremental backup built into the core, expanded SQL/JSON functions aligned with the SQL:2023 standard, and a configurable SLRU cache, all aimed at improving performance, recovery speed, and developer productivity for modern database workloads.
PostgreSQLSLRU CacheSQL/JSON
0 likes · 6 min read

This step‑by‑step tutorial shows how to install Percona XtraBackup 2.4, create full, incremental and compressed backups of MySQL 5.1‑5.7, prepare the backups, and restore data using Docker or native Linux packages.
CompressionDockerLinux
0 likes · 11 min read

Learn how to use rsync for efficient incremental backups, covering basic local and remote synchronization, scheduling with cron, advanced options like file exclusion and bandwidth limiting, and practical examples such as website and database backups, all with clear command-line instructions.
Linuxbackup automationcron
0 likes · 7 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 explains the three main backup methods—full, incremental, and differential—detailing their processes, advantages, disadvantages, and suitable use cases for organizations of different sizes, helping readers choose the most appropriate backup strategy for their business needs.
Full BackupIT Operationsbackup
0 likes · 7 min read

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 BackupMySQL
0 likes · 9 min read

The article explains four primary backup methods—Normal (full), Copy, Differential, and Incremental—detailing their processes, advantages, and drawbacks, and helps readers decide which strategy best balances storage space, recovery speed, and data protection needs.
Operationsbackupdata protection
0 likes · 4 min read

This guide walks through downloading and installing Percona XtraBackup on a CentOS server, then demonstrates how to create full backups, remove timestamps, inspect backup contents, and execute incremental backups with detailed command examples and explanations.
CentOSPercona XtraBackupdatabase
0 likes · 5 min read

This guide details a production‑grade MongoDB replica‑set deployment, covering hardware specs, configuration files, replica‑set initialization, user creation, incremental backup with mongobackup scripts, primary node switching, cold backup procedures, troubleshooting authentication errors, and test data generation for performance validation.
MongoDBReplica Setdatabase administration
0 likes · 14 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

This guide explains how Percona XtraBackup works for MySQL hot backups, covering required permissions, key terminology, backup and incremental backup mechanisms, essential command‑line options, and practical script examples to ensure reliable, low‑impact data protection.
InnoDBPercona XtraBackupdatabase administration
0 likes · 12 min read
