BestHub
Sign in
Tagged articles

Recovery

58 articles · Page 1 of 1
Ops Community
Ops Community
Jun 22, 2026 · Databases

Backup and Recovery: mysqldump / xtrabackup with Point‑In‑Time Recovery

This guide walks through practical MySQL backup and point‑in‑time recovery strategies using logical dumps with mysqldump and physical copies with Percona XtraBackup, covering configuration, command‑line examples, binlog handling, GTID/LSN concepts, incremental backups, restoration scripts, verification steps and common pitfalls for DBAs and DevOps engineers.

DatabasesOperationsRecovery
0 likes · 44 min read
Backup and Recovery: mysqldump / xtrabackup with Point‑In‑Time Recovery
Ops Community
Ops Community
Jun 8, 2026 · Databases

Comparing MySQL Backup Solutions: From Tool Mechanics to Production-Ready Engineering Guide

This article analyzes common MySQL backup pitfalls, explains the three backup dimensions and five types, compares major tools such as mysqldump, mysqlpump, mydumper, XtraBackup and cloud snapshots, and provides practical scripts, sizing recommendations, scheduling, monitoring, recovery procedures, and failure case studies for reliable production backup engineering.

BinlogRecoveryXtraBackup
0 likes · 52 min read
Comparing MySQL Backup Solutions: From Tool Mechanics to Production-Ready Engineering Guide
Ops Community
Ops Community
May 7, 2026 · Databases

How to Prevent Redis Data Loss: In‑Depth RDB and AOF Backup Strategies

This article walks operations engineers through the root causes of Redis data loss, explains the inner workings of RDB snapshots and AOF append‑only files, compares their trade‑offs, and provides concrete configuration, backup scripts, recovery procedures, and scenario‑based recommendations to keep data safe while maintaining performance.

AOFConfigurationPersistence
0 likes · 34 min read
How to Prevent Redis Data Loss: In‑Depth RDB and AOF Backup Strategies
MaGe Linux Operations
MaGe Linux Operations
Apr 18, 2026 · Databases

Master MySQL 8.0 Backup & Recovery: Full Guide with Scripts, Strategies and Best Practices

This comprehensive guide explains why MySQL backup is essential, defines RPO/RTO, compares logical and physical tools, provides ready‑to‑run scripts for full, incremental, binlog, encryption and compression backups, details step‑by‑step recovery procedures, troubleshooting tips and monitoring recommendations for reliable database protection.

AutomationDatabase AdministrationRecovery
0 likes · 35 min read
Master MySQL 8.0 Backup & Recovery: Full Guide with Scripts, Strategies and Best Practices
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 BackupPITR
0 likes · 12 min read
How to Recover Lost MySQL Data: Physical, Logical, and PITR Backup Guide
Ray's Galactic Tech
Ray's Galactic Tech
Dec 11, 2025 · Databases

Mastering MySQL Binlog: Complete Guide to Replication, Recovery, and Auditing

An in‑depth guide to MySQL binary logs explains their role in replication, point‑in‑time recovery, auditing, and real‑time data pipelines, covering binlog formats, GTID, encryption, multi‑threaded replication, cleanup strategies, and practical mysqlbinlog commands for monitoring and troubleshooting.

BinlogDatabase AdministrationRecovery
0 likes · 10 min read
Mastering MySQL Binlog: Complete Guide to Replication, Recovery, and Auditing
Raymond Ops
Raymond Ops
Dec 4, 2025 · Databases

Master MySQL Backups: A Complete Guide to Data Protection and Recovery

This guide explains why MySQL data protection is critical, outlines backup strategies, compares built‑in tools like mysqldump and mysqlpump with third‑party solutions such as Percona XtraBackup, and provides practical scripts, scheduling tips, verification methods, and recovery procedures to ensure reliable, secure database backups.

AutomationMonitoringRecovery
0 likes · 21 min read
Master MySQL Backups: A Complete Guide to Data Protection and Recovery
dbaplus Community
dbaplus Community
Nov 30, 2025 · Databases

How Uber Scales Database Backup and Recovery to Petabytes

This article explains how Uber built a robust, continuously backed‑up and recoverable database platform that handles tens of petabytes of data, detailing the challenges, architecture, scheduling, backup and restore frameworks, and the technology‑specific snapshot logic that enable fast RPO/RTO at massive scale.

DatabasesRecoveryUber
0 likes · 14 min read
How Uber Scales Database Backup and Recovery to Petabytes
Linux Tech Enthusiast
Linux Tech Enthusiast
Aug 28, 2025 · Databases

Can Weak Backup & Recovery Skills Cost You Your Probation?

The article explains why mastering database backup and recovery—including failure types, logical vs. physical backups, flashback, full and partial restores, a weekly backup strategy, RMAN configuration, shell scripts, and monitoring queries—is essential for avoiding costly mistakes and passing a new‑job probation.

OracleRMANRecovery
0 likes · 7 min read
Can Weak Backup & Recovery Skills Cost You Your Probation?
Liangxu Linux
Liangxu Linux
Aug 10, 2025 · Databases

Master MySQL Backup & Recovery: Complete Guide for Reliable Data Protection

This comprehensive guide explains MySQL data backup and recovery strategies, covering backup types, planning principles, built‑in tools like mysqldump and mysqlpump, third‑party solutions such as Percona XtraBackup, scripting for automated schedules, storage options, encryption, monitoring, troubleshooting, and best‑practice recommendations to ensure data safety and business continuity.

AutomationMonitoringRecovery
0 likes · 22 min read
Master MySQL Backup & Recovery: Complete Guide for Reliable Data Protection
MaGe Linux Operations
MaGe Linux Operations
Jul 10, 2025 · Databases

Master MySQL Backup & Recovery: Complete Guide for Reliable Data Protection

This comprehensive guide explains MySQL backup strategies, compares full, incremental, and differential backups, details built‑in tools like mysqldump, mysqlpump, and third‑party solutions such as Percona XtraBackup, and provides scripts, scheduling tips, verification methods, and best‑practice recommendations for secure data protection and recovery.

Database AdministrationRecoverymysql
0 likes · 23 min read
Master MySQL Backup & Recovery: Complete Guide for Reliable Data Protection
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.

Database AdministrationDisaster RecoveryIncremental Backup
0 likes · 7 min read
Master MySQL Backup & Recovery: Strategies for Every Business Scenario
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 27, 2024 · Databases

Evaluation of OceanBase Arbitration Service in a 2F1A Deployment: Fault Injection Experiments and Recovery Procedures

This article presents a detailed experimental study of OceanBase's Arbitration Service in a 2F1A (two full‑function replicas plus one arbitration node) configuration, examining how the system behaves when one or both full‑function replicas fail, how log‑stream degradation and permanent offline mechanisms work, and how normal service is restored after node recovery.

Arbitration ServiceFault InjectionHigh Availability
0 likes · 17 min read
Evaluation of OceanBase Arbitration Service in a 2F1A Deployment: Fault Injection Experiments and Recovery Procedures
dbaplus Community
dbaplus Community
Feb 25, 2024 · Databases

How a Simple UPDATE Wiped My Production Database—and the Lessons I Learned

After a weekend support ticket led to a reckless UPDATE that erased all orders in a production PostgreSQL database, the author details the rapid recovery steps, analyzes the human errors behind the disaster, draws lessons from Chernobyl, and outlines concrete post‑mortem improvements to prevent future data loss.

DatabasesRecoverySQL
0 likes · 7 min read
How a Simple UPDATE Wiped My Production Database—and the Lessons I Learned
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 7, 2024 · Databases

Accelerating MySQL Data Recovery with Xtrabackup: Scenarios and Techniques

This article explains how DBA engineers can speed up MySQL data recovery using Xtrabackup by covering three scenarios—full backup with binlog, single-database restore, and single-table restore—detailing steps such as SQL thread replay, parallel replication, and transportable tablespace techniques with practical command examples.

RecoveryTablespaceXtraBackup
0 likes · 21 min read
Accelerating MySQL Data Recovery with Xtrabackup: Scenarios and Techniques
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 13, 2023 · Databases

MySQL Backup and Recovery Best Practices

This article explains why MySQL backups are essential, defines RTO and RPO, compares physical and logical backup methods, describes snapshot, binary‑log, incremental and differential strategies, and provides best‑practice recommendations and example commands for reliable backup and recovery.

Percona XtraBackupRPORTO
0 likes · 13 min read
MySQL Backup and Recovery Best Practices
Open Source Linux
Open Source Linux
Feb 24, 2023 · Databases

Master Oracle Backup & Recovery: Strategies, Scripts, and Best Practices

This article explains Oracle database backup and recovery fundamentals, classifies failure types, compares logical and physical backup methods, introduces flashback technology, outlines complete and incomplete recovery, and provides practical RMAN scripts and scheduling tips for reliable data protection.

OracleRMANRecovery
0 likes · 7 min read
Master Oracle Backup & Recovery: Strategies, Scripts, and Best Practices
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 17, 2023 · Databases

Understanding Redis Persistence: RDB and AOF Overview

This article provides a comprehensive overview of Redis persistence mechanisms, detailing the concepts, features, advantages, disadvantages, trigger strategies, operational processes, configuration options, and troubleshooting steps for both RDB (snapshot) and AOF (append‑only file) approaches.

AOFPersistenceRDB
0 likes · 10 min read
Understanding Redis Persistence: RDB and AOF Overview
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 5, 2022 · Databases

Greenplum Standby Failure Diagnosis and Recovery Procedure

This article describes how to identify and fix Greenplum standby segment failures by inspecting segment status, comparing missing files, generating a recovery configuration, executing gprecoverseg commands, and verifying that all segments return to normal operation without service interruption.

GreenplumRecoverySQL
0 likes · 17 min read
Greenplum Standby Failure Diagnosis and Recovery Procedure
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 17, 2022 · Databases

DeadMaster Recovery Process in Orchestrator

This article explains the complete DeadMaster recovery workflow of Orchestrator, detailing how the system selects the appropriate check‑and‑recover function, handles emergency grace periods, reads topology information, registers recovery attempts, validates promotion constraints, executes the actual failover, and runs post‑recovery hooks, with extensive Go code examples.

GoOrchestratorRecovery
0 likes · 18 min read
DeadMaster Recovery Process in Orchestrator
Java High-Performance Architecture
Java High-Performance Architecture
Mar 20, 2022 · Databases

Master MySQL Data Recovery: From Full Backups to Point‑in‑Time Restoration

This guide explains how to prevent data loss in MySQL by enabling row‑based binlog, performing full restores with mysqldump or xtrabackup, executing point‑in‑time recovery, restoring individual tables, skipping erroneous SQL statements using binlog or GTID, and leveraging flashback tools such as binlog2sql and MyFlash.

BinlogFlashbackRecovery
0 likes · 15 min read
Master MySQL Data Recovery: From Full Backups to Point‑in‑Time Restoration
IT Architects Alliance
IT Architects Alliance
Mar 9, 2022 · Databases

Understanding Database Transactions, ACID Properties, and Two‑Phase/Three‑Phase Commit Protocols

This article explains the ACID properties of database transactions, distinguishes between single‑node and distributed transactions, describes the two‑phase and three‑phase commit protocols, discusses transaction states, fault tolerance, and recovery mechanisms, and shows how replication and consensus can provide high availability for transaction processing.

2PC3PCACID
0 likes · 10 min read
Understanding Database Transactions, ACID Properties, and Two‑Phase/Three‑Phase Commit Protocols
Laiye Technology Team
Laiye Technology Team
Oct 30, 2021 · Databases

Introduction to MySQL Group Replication (MGR) and Its Application in Private Deployments

This article explains the fundamentals, architecture, deployment patterns, recovery procedures, performance tuning, and common troubleshooting of MySQL Group Replication (MGR) as a high‑availability solution for private deployments, illustrated with real‑world examples and practical SQL commands.

Group ReplicationHigh AvailabilityPerformance Tuning
0 likes · 16 min read
Introduction to MySQL Group Replication (MGR) and Its Application in Private Deployments
OPPO Kernel Craftsman
OPPO Kernel Craftsman
Jul 23, 2021 · Mobile Development

Fastboot Protocol and Fastbootd Process on Android Devices

Fastbootd, introduced in Android Q, runs inside recovery to implement the full fastboot flashing protocol—supporting dynamic super‑partition management, USB FunctionFS communication, and OEM commands—by using source files in system/core/fastboot and recovery, triggered via adb or bootloader reboot‑fastboot.

AndroidFastbootFastbootd
0 likes · 7 min read
Fastboot Protocol and Fastbootd Process on Android Devices
Laravel Tech Community
Laravel Tech Community
Jun 29, 2021 · Databases

MySQL Data Recovery: Backup, Binlog, Point‑in‑Time Recovery and Tools

This article explains how to prevent data loss in MySQL by enabling backups and row‑based binlog, then details full‑volume recovery with mysqldump or xtrabackup, point‑in‑time restoration using binlog, table‑level recovery, skipping erroneous SQL statements, and introduces open‑source tools such as binlog2sql and MyFlash.

BinlogMyFlashRecovery
0 likes · 15 min read
MySQL Data Recovery: Backup, Binlog, Point‑in‑Time Recovery and Tools
DataFunTalk
DataFunTalk
Mar 21, 2021 · Big Data

Single‑Point Recovery and Regional Checkpoint in Flink: Design, Implementation, and Optimizations

This article presents ByteDance's recent Flink enhancements, detailing a single‑point recovery mechanism for the network layer and a regional checkpoint strategy that together improve failover latency, reduce output loss, and enable scalable, high‑throughput stream processing for large‑scale real‑time recommendation workloads.

Big DataCheckpointFlink
0 likes · 12 min read
Single‑Point Recovery and Regional Checkpoint in Flink: Design, Implementation, and Optimizations
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Dec 21, 2020 · Databases

MySQL Backup and Recovery: Strategies, Tools, and Best Practices

This article explains the importance of MySQL backup and recovery, outlines common failure scenarios, recommends backup architectures and verification processes, reviews popular logical and physical backup tools such as mysqldump, mydumper, and xtrabackup, and shares practical case studies and best‑practice guidelines.

Database AdministrationRecoveryXtraBackup
0 likes · 10 min read
MySQL Backup and Recovery: Strategies, Tools, and Best Practices
Laravel Tech Community
Laravel Tech Community
Sep 5, 2020 · Databases

MySQL Database Backup and Recovery

The article explains why MySQL databases need regular backup, describes common data‑loss scenarios, classifies backup types (hot, cold, warm) and methods (logical, physical), lists popular tools, and provides detailed command‑line examples for backing up, restoring, migrating, and exporting data.

Data MigrationHot BackupRecovery
0 likes · 27 min read
MySQL Database Backup and Recovery
Big Data Technology & Architecture
Big Data Technology & Architecture
Aug 27, 2020 · Big Data

HBase Architecture, Components, and Operations Overview

This article provides a comprehensive overview of Apache HBase’s architecture, detailing its core components such as RegionServer, HMaster, ZooKeeper, WAL, MemStore, and HFiles, and explains key processes including read/write paths, compaction, region splitting, load balancing, and recovery mechanisms.

Big DataCompactionDatabase Architecture
0 likes · 17 min read
HBase Architecture, Components, and Operations Overview
dbaplus Community
dbaplus Community
Sep 26, 2019 · Databases

Mastering Oracle 12c Multitenant Backup & Recovery: A Step‑by‑Step Guide

An in‑depth exploration of Oracle 12c’s multitenant architecture explains key concepts, analyzes a real‑world backup failure, and provides a comprehensive, step‑by‑step RMAN procedure—including control file handling, datafile restoration, and selective tablespace skipping—to reliably recover pluggable databases.

MultiTenantOraclePdb
0 likes · 13 min read
Mastering Oracle 12c Multitenant Backup & Recovery: A Step‑by‑Step Guide
360 Tech Engineering
360 Tech Engineering
Jul 8, 2019 · Operations

Common ETCD Issues and Recovery Procedures

This guide explains ETCD’s high‑availability architecture and provides detailed step‑by‑step recovery procedures for single‑node failures, majority‑node outages, and database‑space‑exceeded errors, including status checks, member removal and addition, snapshot restoration, compaction, defragmentation, and alarm clearing.

EtcdOperationsRecovery
0 likes · 7 min read
Common ETCD Issues and Recovery Procedures
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 25, 2019 · Databases

Understanding XtraBackup Full Backup Process for MySQL

This article explains MySQL backup classifications, then details XtraBackup's hot physical backup workflow—including redo‑log handling, global read‑lock usage, step‑by‑step file copying, and restore procedures—while addressing common FAQs and practical tips for ensuring data consistency.

Full BackupInnoDBRecovery
0 likes · 6 min read
Understanding XtraBackup Full Backup Process for MySQL
ITPUB
ITPUB
Feb 27, 2018 · Databases

Designing Robust Oracle Backup and Recovery Strategies for Large Databases

This guide answers common Oracle backup questions, covering planning for 50‑TB databases, speed calculations, backup window design, RMAN versus Data Pump, multi‑user and RAC scenarios, catalog usage, performance troubleshooting, and practical SQL queries for monitoring backup status.

Data PumpOracleRMAN
0 likes · 18 min read
Designing Robust Oracle Backup and Recovery Strategies for Large Databases
ITPUB
ITPUB
Feb 24, 2018 · Databases

Essential Oracle Database Interview Questions and Answers: Tuning, Backup, Recovery, and Administration

This comprehensive guide covers Oracle SQL tuning techniques, execution‑plan inspection, optimizer choices, high‑resource SQL detection, session tracing, index fundamentals, backup classifications, recovery procedures, system monitoring, and performance diagnostics, providing practical knowledge for DBA interviews and daily work.

Database AdministrationOracleRecovery
0 likes · 17 min read
Essential Oracle Database Interview Questions and Answers: Tuning, Backup, Recovery, and Administration
dbaplus Community
dbaplus Community
May 24, 2017 · Databases

Inside Amazon Aurora: Cloud‑Native Architecture, Write/Read Path, and Recovery

This article provides an in‑depth technical analysis of Amazon Aurora’s cloud‑native relational database design, covering its architectural models, log‑as‑database philosophy, optimized write and read paths, fault‑tolerant replication, group commit, and fast recovery mechanisms compared with traditional DBMS.

AuroraDatabase ArchitectureRecovery
0 likes · 27 min read
Inside Amazon Aurora: Cloud‑Native Architecture, Write/Read Path, and Recovery
ITPUB
ITPUB
Sep 28, 2016 · Databases

How to Diagnose and Repair Bad Blocks in Oracle Databases

This guide explains what Oracle bad blocks are, how they affect the database, common causes, methods to detect them, and step‑by‑step recovery techniques—including full datafile restore, RMAN block recovery, ROWID range scans, EVENT 10231, and DBMS_REPAIR—plus pre‑emptive detection tools.

Bad BlocksDBMS_REPAIROracle
0 likes · 10 min read
How to Diagnose and Repair Bad Blocks in Oracle Databases
ITPUB
ITPUB
Aug 11, 2016 · Databases

How Oracle’s Incremental Checkpoints Reduce I/O Overhead and Speed Recovery

This article explains Oracle’s checkpoint mechanism, contrasting full and incremental checkpoints, describing the checkpoint queue structure, the roles of DBWn and CKPT processes, recovery using redo logs, and how to tune checkpoint frequency with the fast_start_mttr_target parameter while monitoring relevant performance views.

CheckpointOracleRecovery
0 likes · 14 min read
How Oracle’s Incremental Checkpoints Reduce I/O Overhead and Speed Recovery
dbaplus Community
dbaplus Community
Dec 16, 2015 · Databases

Understanding Oracle ASM Metadata: Files, AU, Disk Headers, and Recovery

This article explains Oracle ASM metadata concepts, including ASM file types, allocation units, physical and virtual metadata structures, disk header composition, and practical methods for querying, validating, backing up, and restoring ASM metadata using tools like KFOD, KFED, and X$KFFXP.

ASMAllocation UnitDisk Header
0 likes · 14 min read
Understanding Oracle ASM Metadata: Files, AU, Disk Headers, and Recovery
21CTO
21CTO
Sep 20, 2015 · Databases

Master MySQL Backup & Recovery: Mysqldump, LVM Snapshots, and Xtrabackup Explained

This tutorial walks through three MySQL backup and recovery strategies—using mysqldump with binary logs, LVM snapshots with binary logs, and Percona Xtrabackup—detailing environment setup, command syntax, incremental procedures, and restoration steps to ensure data safety and minimal downtime.

LVMRecoveryXtraBackup
0 likes · 21 min read
Master MySQL Backup & Recovery: Mysqldump, LVM Snapshots, and Xtrabackup Explained