Comprehensive Guide to Percona Backup for MongoDB: Architecture, Installation, Full and Incremental Backups, and Restoration

This article provides an in‑depth overview of Percona Backup for MongoDB (PBM), covering its architecture, installation steps, configuration, logical full backups, point‑in‑time incremental backups, restoration procedures, performance testing, selective backup options, known limitations, and useful command‑line examples.

BackupMongoDBPBM

0 likes · 16 min read

Comprehensive Guide to Percona Backup for MongoDB: Architecture, Installation, Full and Incremental Backups, and Restoration

IT Xianyu

Feb 14, 2022 · Databases

MySQL Data Recovery: Backup Strategies, Point‑in‑Time Restoration, Table Recovery, and Flashback Techniques

This article explains how to prevent data loss in MySQL by enabling binlog in ROW format, performing full and incremental restores using mysqldump or XtraBackup, executing point‑in‑time recovery, restoring individual tables, skipping erroneous SQL statements, and using flashback tools such as binlog2sql and MyFlash.

BackupBinlogData Recovery

0 likes · 15 min read

MySQL Data Recovery: Backup Strategies, Point‑in‑Time Restoration, Table Recovery, and Flashback Techniques

ITPUB

Jul 15, 2021 · Databases

Recovering an Oracle Table After a Week-Long Data Mishap with RMAN and DBLINK

This guide walks through restoring a mistakenly updated Oracle 11.2.0.1 table to a specific point in time using RMAN tablespace recovery on a new host, handling Windows-specific issues, and finally retrieving the data via a database link, with full scripts and step‑by‑step instructions.

DBLINKDatabase RecoveryOracle

0 likes · 14 min read

Recovering an Oracle Table After a Week-Long Data Mishap with RMAN and DBLINK

Java High-Performance Architecture

Jun 17, 2021 · Databases

How to Recover MySQL Data: Full, Point-in-Time, and Table Restoration Techniques

This guide explains how to protect MySQL data with proper backups and row‑format binlogs, then walk through full restores using mysqldump or xtrabackup, point‑in‑time recovery from binlogs, single‑table restoration, skipping erroneous SQL statements, and flashback tools like binlog2sql and MyFlash.

Backup and RestoreData Recoverymysql

0 likes · 15 min read

How to Recover MySQL Data: Full, Point-in-Time, and Table Restoration Techniques

Open Source Linux

Sep 2, 2020 · Databases

Recover MySQL After Accidental Drop Using LVM Snapshots and Binlog

This guide demonstrates a complete MySQL disaster‑recovery workflow that combines LVM snapshot technology with binary‑log point‑in‑time recovery, allowing you to restore a dropped database by creating a snapshot, extracting it, and replaying binlog events up to the failure moment.

LVMbinary logmysql

0 likes · 7 min read

Recover MySQL After Accidental Drop Using LVM Snapshots and Binlog

dbaplus Community

Mar 8, 2020 · Databases

Why Distributed Databases Need a New Architecture: From Two‑Phase Commit to Raft

This article examines the pressures driving banks to redesign their core database systems, compares three distributed‑access approaches, explains the components of modern distributed databases, analyzes two‑phase and three‑phase commit issues, and evaluates consensus algorithms, CAP/BASE trade‑offs, GTM design, and point‑in‑time recovery.

CAP theoremGTMRaft

0 likes · 19 min read

Why Distributed Databases Need a New Architecture: From Two‑Phase Commit to Raft