BestHub
Sign in
Tagged articles
13 articles
Page 1 of 1
Java Architecture Stack
Java Architecture Stack
Oct 10, 2024 · Databases

Master MySQL Backup & Recovery: Strategies for Every Business Scenario

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.

BackupDatabase AdministrationIncremental Backup
0 likes · 7 min read
Master MySQL Backup & Recovery: Strategies for Every Business Scenario
21CTO
21CTO
Sep 27, 2024 · Databases

What’s New in PostgreSQL 17? Incremental Backup, SQL/JSON Boosts, and SLRU Cache

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.

Database FeaturesIncremental BackupPostgreSQL
0 likes · 6 min read
What’s New in PostgreSQL 17? Incremental Backup, SQL/JSON Boosts, and SLRU Cache
Liangxu Linux
Liangxu Linux
Mar 24, 2024 · Operations

Master Incremental Backups with rsync: Local, Remote, and Automated Solutions

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.

Incremental BackupLinuxbackup automation
0 likes · 7 min read
Master Incremental Backups with rsync: Local, Remote, and Automated Solutions
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 BackupPercona XtraBackup
0 likes · 13 min read
MySQL Logical vs Physical Backup and Percona XtraBackup Installation, Configuration, and Backup/Restore Procedures
Architects Research Society
Architects Research Society
Aug 22, 2022 · Operations

Backup Strategies: Full, Incremental, and Differential Backups

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.

BackupData ProtectionFull Backup
0 likes · 7 min read
Backup Strategies: Full, Incremental, and Differential Backups
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
Open Source Linux
Open Source Linux
Dec 5, 2021 · Operations

Choosing the Right Backup: Normal, Copy, Differential, Incremental

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.

BackupData ProtectionIncremental Backup
0 likes · 4 min read
Choosing the Right Backup: Normal, Copy, Differential, Incremental
dbaplus Community
dbaplus Community
Oct 18, 2016 · Databases

How to Build and Manage a Large‑Scale MongoDB Replica Set with Incremental Backups

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.

Database AdministrationIncremental BackupMongoDB
0 likes · 14 min read
How to Build and Manage a Large‑Scale MongoDB Replica Set with Incremental Backups
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
MaGe Linux Operations
MaGe Linux Operations
Nov 29, 2015 · Databases

Mastering Percona XtraBackup: Principles, Commands, and Best Practices

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.

Database AdministrationIncremental BackupInnoDB
0 likes · 12 min read
Mastering Percona XtraBackup: Principles, Commands, and Best Practices