Tagged articles
Recovery
64 articles · Page 1 of 1
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

A production-grade MySQL backup guide analyzing a 3 AM replica crash, covering RPO/RTO design, logical vs physical backup trade-offs, XtraBackup streaming, PITR with binlog, automated restore drills, and a 3-2-1-1-0 resilience architecture.
MySQLPITRRPO
0 likes · 41 min read

This article details the engineering implementation and performance optimization of TCC distributed transactions in Go microservices, using an order placement scenario with inventory locking and wallet freezing, covering data models, idempotent state machines, recovery workers, hotspot optimization, and observability.
ConcurrencyGoIdempotency
0 likes · 33 min read

This comprehensive guide walks MySQL administrators through the fundamentals of backup and recovery, covering RPO/RTO concepts, tool comparisons (mysqldump, mydumper, xtrabackup), step‑by‑step scripts for full, incremental, and binlog backups, encryption, compression, troubleshooting, and best‑practice monitoring to ensure data safety and rapid restoration.
MySQLRecoveryXtraBackup
0 likes · 35 min read

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.
MySQLOperationsRecovery
0 likes · 44 min read

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.
MyDumperMySQLRecovery
0 likes · 52 min read

The article explains why many teams only have backup files without true recovery capability and walks through designing a production‑grade MySQL backup system using MyDumper, covering consistency snapshots, parallel export, metadata, Kubernetes integration, storage, monitoring, and step‑by‑step scripts for reliable, scalable data protection.
KubernetesMyDumperMySQL
0 likes · 48 min read

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.
AOFConfigurationRDB
0 likes · 34 min read

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.
MySQLRecoveryXtraBackup
0 likes · 35 min read

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 comprehensive guide explains PostgreSQL backup and recovery techniques—including logical and physical backups, point‑in‑time recovery, automation scripts, security measures, and production‑grade best practices—to ensure data availability, integrity, and compliance.
PITRPostgreSQLRecovery
0 likes · 9 min read

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.
MySQLRecoveryReplication
0 likes · 10 min read

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.
MySQLRecoveryautomation
0 likes · 21 min read

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

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

This article walks through two enterprise MySQL disaster‑recovery scenarios, detailing backup policies, binlog extraction, temporary database restoration, and step‑by‑step commands to safely recover accidentally dropped tables and ensure data integrity.
MySQLRecoveryXtraBackup
0 likes · 10 min read

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.
MySQLRecoverySecurity
0 likes · 22 min read

This article explains Apache Flink's checkpoint and savepoint mechanisms, detailing their core differences, ideal use cases for automatic failure recovery versus manual structural changes, and key operational considerations for stateful stream processing applications.
FlinkRecoverySavepoint
0 likes · 8 min read

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.
MySQLRecoverydatabase administration
0 likes · 23 min read

This article explains how a corrupted Maven .m2 cache can sabotage builds and CI pipelines, outlines ten destructive Maven options with code examples, and provides practical recovery steps to restore reliable, reproducible builds.
CICacheDevOps
0 likes · 7 min read

Learn how to schedule automated MySQL backups for a Docker container using Linux crontab, create optimized backup scripts, compress and retain backups, and recover lost data with binlog files, including detailed command examples and best practices for reliable database maintenance.
DockerMySQLRecovery
0 likes · 11 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

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 ServiceDistributed DatabaseHigh Availability
0 likes · 17 min read

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.
RecoverySQLdatabases
0 likes · 7 min read

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.
MySQLRecoveryReplication
0 likes · 21 min read

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.
MySQLPercona XtraBackupRPO
0 likes · 13 min read

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

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.
AOFRDBRecovery
0 likes · 10 min read

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

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.
FailoverGoMySQL
0 likes · 18 min read

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.
FlashbackMySQLRecovery
0 likes · 15 min read

This article explains the four SQL language categories (DDL, DML, DCL, TCL), various backup and recovery types, common MySQL backup methods, and flashback recovery techniques, providing detailed guidance and tool comparisons for database administrators.
DMLFlashbackMySQL
0 likes · 8 min read

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

This guide walks through setting up PostgreSQL's Point‑In‑Time Recovery (PITR) by enabling WAL archiving, performing a base backup, simulating data loss, and restoring the database to a specific timestamp, complete with command‑line examples and verification steps.
PITRPostgreSQLRecovery
0 likes · 9 min read

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 AvailabilityMySQL
0 likes · 16 min read

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

This guide explains how to safely recover MySQL data using full backups, incremental binlog recovery, point‑in‑time restores, single‑table extraction, and methods to skip erroneous SQL statements via GTID or delayed replication, complete with practical command examples.
GTIDMySQLRecovery
0 likes · 15 min read

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.
MyFlashMySQLRecovery
0 likes · 15 min read

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.
FailoverFlinkRecovery
0 likes · 12 min read

This article demonstrates how to perform a full backup of a MySQL 8.0 database using mysqldump, drop and recreate the database, then restore it and apply incremental recovery with mysqlbinlog by specifying start and stop positions to recover data inserted after the backup.
MySQLRecoverybackup
0 likes · 5 min read

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.
MySQLRecoveryXtraBackup
0 likes · 10 min read

This article explains the essential role of logging and recovery mechanisms—especially the ARIES algorithm—in ensuring ACID properties, covering physical vs logical logging, optimization techniques like group commit and early lock release, and the three-phase recovery process.
AriesLoggingRecovery
0 likes · 19 min read

After replacing a MySQL server's CPU and motherboard, the instance fails to start due to a missing MLOG_CHECKPOINT marker in the redo log, and the article explains the underlying cause, recovery options using innodb_force_recovery levels, and step‑by‑step data restoration.
InnoDBMySQLRecovery
0 likes · 4 min read

This article outlines the challenges of MySQL backup restoration, categorizes common data loss scenarios, and provides detailed step‑by‑step procedures for full backup recovery, incremental binlog recovery, and optimized workflows using parallel replication and binlog‑server tricks to reduce downtime.
MySQLOperationsRecovery
0 likes · 9 min read

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.
Hot BackupMySQLRecovery
0 likes · 27 min read

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.
Database ArchitectureHBaseNoSQL
0 likes · 17 min read

This article explains how to recover MySQL data by preparing backups with binlog enabled, performing full and point‑in‑time restores using mysqldump, xtrabackup, or binlog, restoring individual tables, skipping unwanted SQL statements, and using flashback tools such as binlog2sql and MyFlash.
Data RestorationFlashbackMySQL
0 likes · 15 min read

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.
OraclePDBRMAN
0 likes · 13 min read

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.
OperationsRecoverybackup
0 likes · 7 min read

This article explains the principles of full and incremental MySQL backups using XtraBackup, covering how redo logs, LSN timestamps, global read locks, and recovery steps ensure data consistency for both transactional and non‑transactional information.
DatabaseBackupIncrementalBackupLSN
0 likes · 9 min read

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 BackupInnoDBMySQL
0 likes · 6 min read

After an unexpected crash, InnoDB restores data using a multi‑stage process that first replays redo logs based on checkpoints, then leverages binlog and undo logs to resolve uncommitted transactions, with detailed steps, optimizations, and checkpoint handling explained.
Database InternalsInnoDBMySQL
0 likes · 12 min read


ITPUBFeb 27, 2018 · 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


ITPUBFeb 24, 2018 · Databases
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.
OracleRecoverySQL Tuning
0 likes · 17 min read

This article explains the fundamentals of MySQL binary logs, how to enable and query them, the different binlog formats, practical steps for setting up master‑slave replication, and methods for using binlog to recover data after accidental changes.
MySQLRecoverydatabase
0 likes · 15 min read

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.
AuroraCloud DatabaseDatabase Architecture
0 likes · 27 min read

Amazon Aurora separates compute and storage using a service‑centric design, employs a quorum‑based replication across three availability zones, slices data into 10 GB protection groups, and leverages S3‑backed redo logs to deliver MySQL‑compatible performance with rapid recovery and strong consistency.
AWSAuroraDatabase Architecture
0 likes · 10 min read

This article details Qunar's comprehensive MySQL backup and recovery platform, covering high‑availability concepts, backup types, tool selection, multi‑channel architecture, storage solutions, automation, and operational lessons for scaling DBA operations across large‑scale deployments.
DBAHigh AvailabilityMySQL
0 likes · 15 min read


ITPUBSep 28, 2016 · 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


ITPUBAug 11, 2016 · Databases
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.
OracleRecoverycheckpoint
0 likes · 14 min read

This article explains Ceph's PGLog structure, how it is serialized into transactions and stored in journals and LevelDB, and how the log participates in the recovery of degraded or failed placement groups during the peering process.
CephLevelDBPGLog
0 likes · 15 min read

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


21CTOSep 20, 2015 · Databases
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.
Binary LogLVMMySQL
0 likes · 21 min read

This comprehensive tutorial explains MySQL/MariaDB backup types, essential tools such as mysqldump, LVM snapshots, and Percona XtraBackup, and provides detailed command‑line procedures for full, incremental, and hot backups as well as reliable data restoration.
LVM snapshotMariaDBMySQL
0 likes · 12 min read
