This article explains the MySQL Clone plugin introduced in version 8.0.17, describes its underlying mechanism, installation and execution steps, outlines usage constraints and scenarios, and presents a detailed performance comparison with LVM snapshots and Xtrabackup under various workloads.
This article provides a comprehensive guide to MySQL InnoDB tablespace encryption, covering its architecture, supported plugins, configuration steps, key rotation, limitations, encrypted table operations, import/export procedures, and backup/restore methods using mysqlbackup and innobackupex.
This article explains the definitions of disaster tolerance, fault tolerance, and disaster recovery, compares their purposes, discusses backup versus disaster‑tolerance solutions, outlines key metrics such as RTO and RPO, and presents common architectural and investment considerations for building resilient enterprise systems.
This article explains how the apply‑log‑only option in Percona XtraBackup affects MySQL restoration, illustrates the risk of data inconsistency when the option is omitted, and provides guidance on correctly using the parameter during full and incremental backup recovery to ensure complete transaction replay.
This guide explains how to configure rsync as a remote backup server on Linux, covering installation, configuration files, user authentication, service management, command options, and scheduling automated backups with cron for reliable and efficient data protection.
Effective MySQL backup and disaster recovery are essential for protecting critical business data; this guide explains backup types, tools like Percona XtraBackup, scheduling, local and remote strategies, incremental processes, preparation and restoration steps, and introduces a platform for automated backup management.
This article explains CB‑SQL's two backup approaches—logical (using DUMP and IMPORT) and physical (using BACKUP and RESTORE)—detailing their mechanisms, supported formats, storage options, performance characteristics, and how they ensure reliable data recovery for large‑scale distributed databases.
This guide explains why Linux dominates modern IT, then walks through fourteen practical hardening measures—including physical security, updates, minimal installations, login restrictions, user and file management, firewall configuration, package handling, disabling Ctrl‑Alt‑Del, monitoring, log centralization, backups, security tools, and management policies—to build a robust and attack‑resistant Linux server.
The article analyzes the evolution of data protection—from manual copies and scripts to snapshots and Continuous Data Protection (CDP)—explaining CDP's technical principles, implementation models, advantages over traditional backup, and how Copy Data Management (CDM) complements modern storage strategies in large‑scale enterprises.
Continuous Data ProtectionCopy Data Managementbackup
Snapshot technology creates point‑in‑time copies of files, directories or volumes, addressing common backup issues such as large data volumes, write‑in‑progress files, performance impact, and consistency, while offering various implementations—from file‑system and LVM to NAS, hypervisors, and databases—each with distinct advantages and trade‑offs.
This article demonstrates how to install and verify the MySQL 8.0.17 clone plugin, create privileged clone users on both donor and recipient servers, configure cloning parameters, execute a full instance clone, set up replication with CHANGE MASTER, and discusses the plugin's limitations such as InnoDB‑only support and DDL restrictions.
This article explains OpenStack Trove’s role as a Database-as-a-Service platform, outlines its core components, and details QiYun’s custom enhancements—including automated backup, monitoring, and a streamlined single-API master-slave instance creation with isolated networks and VIP-based failover for improved security and availability.
This article provides a comprehensive tutorial on MySQL 8.0's Clone Plugin, covering its concepts, local and remote cloning procedures, required permissions, configuration steps, monitoring queries, and a detailed comparison with XtraBackup for fast data replication and recovery.
This guide provides step‑by‑step Oracle commands for creating and dropping databases, performing full and selective backups, restoring data locally or remotely, managing tables—including creation, deletion, renaming, column alterations, primary keys, indexes, and views—as well as querying, inserting, updating, deleting, and copying data efficiently.
A developer recounts how a misconfigured production environment led to the accidental deletion of both content and user databases, the frantic scramble to diagnose the issue, the discovery of a backup oversight, and the hard‑earned lessons on backups, testing, and authentication security.
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.
This guide explains why backing up WeChat public account articles is essential and provides a Python solution that captures article content, fixes image URLs, and generates PDF files—either one per article or a combined document—complete with code examples and usage tips.
Discover a concise guide to essential backup solutions—including Git version control, Rsync command-line syncing, Dropbox cloud storage, and macOS Time Machine—explaining their core features, practical usage, and how they collectively safeguard your files, code, and system data.
This guide reviews four practical backup solutions—Git for versioned file control, Rsync for command‑line incremental syncing, Dropbox for cloud‑based GUI storage, and macOS Time Machine for full system snapshots—explaining their key features, typical use cases, and basic setup steps.
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.
When a MySQL server contains many databases but you only need to recover one database or a single table, you can extract the relevant CREATE and INSERT statements from a full mysqldump using sed or grep, then import them, avoiding a costly full‑instance restore.
After his father's PC was infected by the GANDCRAB ransomware, the author recounts the alarming symptoms, explains how ransomware works, explores the role of the dark web and DASH cryptocurrency in ransom demands, and shares practical backup methods—from simple USB copies to the 3‑2‑1 principle—to protect personal data.
This article outlines comprehensive IT operations practices, covering methods, documentation, process flows, essential technical skills, monitoring strategies, backup solutions, and the overall value of operations in supporting business objectives.
This article curates a comprehensive list of technical resources covering backup system architectures, distributed technology designs, cloud computing frameworks, high‑performance computing, storage solutions, server virtualization, networking, big data, databases and AI, providing readers with links to in‑depth analyses and best‑practice guides.
This tutorial walks you through installing the Spatie Laravel‑Backup package, configuring email notifications, setting filename prefixes, limiting storage usage, enabling compression, monitoring backups, and automating the process with cron to protect your Laravel application from data loss.
This article explains data protection concepts—including file‑level and block‑level backup, remote file copy and remote volume imaging, snapshot mechanisms such as CoFW and RoFW, and clone technologies—while discussing their advantages, drawbacks, and practical backup architectures.
This guide explains why database backups are essential, outlines storage media options, and provides step‑by‑step instructions—including creating a backup directory, writing a Bash script, setting executable permissions, and scheduling the job with crontab—to reliably automate MySQL backups on a Linux server.
The talk by Tencent’s senior MySQL engineer explains high‑availability concepts—99.95% uptime, RPO/RTO metrics, backup methods, and replication modes—while comparing single‑node, shared‑storage, and share‑nothing architectures, detailing failover tools (Keepalived, MMM, MHA), cluster solutions (PXC, MGC, Group Replication) and NewSQL examples such as Aurora, PolarDB and CynosDB.
Microsoft's Volume Shadow Service (VSS) is a backup and recovery framework that creates consistent point-in-time snapshots by coordinating requestors, writers, and providers, supporting fast data backup, file-level restores, and various storage scenarios through full and copy-on-write snapshot methods.
The article provides a comprehensive overview of the Network Data Management Protocol (NDMP), explaining its architecture, core concepts, backup mechanisms, version differences, supported backup software, and various network topologies such as 2‑way, 3‑way, and remote configurations for efficient NAS data protection.
This article offers eight practical operations‑team strategies—inspection, monitoring alerts, capacity planning, network restrictions, risk pre‑plans, data backup, on‑call mechanisms, and staying connected—to ensure system stability and enjoy the Golden Week holiday without incidents.
This comprehensive guide walks you through mastering MySQL by covering server configuration choices, storage engine selection, data type recommendations, index strategies, backup methods, logging options, and practical advice on triggers, views, stored procedures, and character set handling, all aimed at boosting performance and avoiding common mistakes.
This article explores the multifaceted role of IT operations, emphasizing how automation, documentation, processes, monitoring, and backup strategies create business value, and shares practical insights from over ten years of experience to help professionals elevate their operational impact.
The article details JD.com's Database Technology Department's development of an intelligent operations platform, automated deployment, monitoring, fault self‑healing, backup/recovery systems, and the ContainerDB elastic MySQL service, highlighting architectural designs, key components, and future directions for smarter, faster, and more cost‑effective database management.
This tutorial walks you through creating a dedicated git user, configuring a bare repository, setting up SSH key authentication, installing GitLab on CentOS 7, managing groups and permissions, and performing backup and restore operations, all with concrete command examples and screenshots.
This article walks through diagnosing a MySQL crash, using innodb_force_recovery to start the server, exporting the data with mysqldump, handling charset mismatches, importing into a new instance, and restoring normal operation while offering best‑practice backup recommendations.
This guide explains three practical ways to track SQL Server backup and restore operations—using SSMS UI, T‑SQL with the STATS option, and dynamic management views—plus how to retrieve backup history and avoid common pitfalls.
This article examines common hardware and network failures in data centers, analyzes real‑world outage cases, classifies fault domains, and presents comprehensive strategies for database fault handling—including logging, checkpointing, backup, replication, and high‑availability architectures—to improve reliability and reduce downtime.
A developer recounts a terrifying production database loss, explores how a misconfigured environment caused the outage, highlights the critical role of backups, and shares hard‑earned lessons about authentication token handling and preventing similar catastrophes in future projects.
The article details Veritas Velocity’s hybrid‑cloud data replica solution, its architecture, deployment steps, role‑based access, workflow automation with Oracle RMAN, and performance benchmarks that show up to 8.8× faster test‑environment provisioning while halving required manpower.
Data Copy Management (CDM) is a storage‑efficiency technology that reduces redundant data copies through block‑level snapshots and virtualization, improving performance, compliance, and cost while complementing but not replacing traditional backup solutions, with a growing market and diverse vendor offerings.
This article explains Redis's two persistence methods—RDB snapshots and AOF append‑only logs—including their operation, configuration options, advantages, disadvantages, and guidance on choosing the appropriate strategy for data durability and recovery.
The article examines how Continuous Data Protection (CDP) transforms traditional backup and disaster‑recovery approaches by offering near‑real‑time recovery points, finer granularity, and flexible implementation models across applications, files, and storage blocks, while comparing its benefits and trade‑offs with conventional methods.
When accidental deletion removes files from the /data/webapps/.../upload directory, this guide shows how to install extundelete, locate the relevant inodes, and safely recover the lost data using read‑only mounts and specific restore commands.
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.
This guide explains how to safely migrate a Zabbix monitoring server to a new machine by backing up the MySQL database with mysqldump, importing it on the new host, updating configuration files, restarting services, and ensuring time synchronization to maintain uninterrupted monitoring.
From Hearthstone’s dual‑database crash to Uber’s massive data breach, this 2017 Linux operations roundup chronicles twelve critical incidents—highlighting backup failures, Docker rebranding, ransomware, BGP hijacking, and more—offering key lessons for sysadmins and DevOps professionals.
This guide explains how to manually export and import MySQL databases using mysqldump and mysql commands, and provides a Bash script with crontab scheduling for automated daily backups, including necessary path adjustments and usage notes.
This article outlines ZanDB's approach to standardizing MySQL environments, implementing a real‑time backup monitoring system, and building a comprehensive automation platform that includes task scheduling, host and instance management, log handling, metadata tracking, and daily maintenance to streamline DBA operations.
This article explains how MongoDB’s security features—including access control, authentication, encryption, data discovery, retention policies, zone sharding, backup, monitoring, and audit logging—help organizations meet GDPR requirements while minimizing operational overhead and ensuring data sovereignty.
Oracle provides several powerful recovery mechanisms—logical backups with the import tool, physical file restoration with incomplete recovery, LogMiner analysis of redo logs, and Flashback Query—each illustrated through a scenario where a mistaken update to the TFUNDASSET table is corrected using step‑by‑step procedures and commands.
The article describes Qunar's 99.99% high‑availability goal for MySQL databases, outlines its HA designs (MMM, PXC, QMHA), compares hot and cold backup methods, discusses common backup challenges, and details Qunar's comprehensive backup and recovery solution including Percona XtraBackup, dedicated backup nodes, centralized management, and consistency verification.
This article explains the concept of Database-as-a-Service (DBaaS), introduces MongoDB’s core capabilities, outlines the essential components such as lifecycle management, disaster recovery, monitoring, and value‑added services, and provides practical guidance on building a production‑grade MongoDB DBaaS platform.
This article compiles a comprehensive set of MySQL interview questions covering replication mechanisms, differences between MyISAM and InnoDB, character type nuances, transaction logging, binlog formats, performance tuning, backup strategies, monitoring, consistency checks, and handling large datasets, providing concise answers for each topic.
This article details LeTV's diverse database landscape, explains the design and implementation of its private‑cloud RDS built on Docker and Percona XtraDB Cluster, outlines monitoring solutions such as Lepus, Prometheus and Open‑Falcon, and shares practical backup approaches and operational lessons learned.
This guide explains how to create a reliable MySQL backup solution by checking disk space, setting up a backup directory, writing a shell script for mysqldump (with optional compression), granting execution rights, scheduling the script with crontab, and verifying the job, while also covering crontab syntax and examples.
This guide explains why database backups are essential, walks through checking disk space, creating a backup directory, writing a Bash script to dump and compress MySQL data, granting execution rights, and scheduling the script with crontab to ensure reliable, automated backups.
This comprehensive guide shares a seasoned DBA's practical advice on environment awareness, hardware considerations, security, routine operations, architecture, and mindset to help database professionals avoid common pitfalls and improve reliability in MySQL production systems.
This article details Tongcheng Travel's extensive experience of running over a thousand MySQL instances in Docker, describing the motivations, architecture, resource scheduling, backup, monitoring, high‑availability, migration, and operational benefits of their private cloud database platform.
Drawing from a year‑and‑a‑half of ops experience, this guide outlines six practical categories—online operation standards, data handling, security, daily monitoring, performance tuning, and mindset—to help engineers avoid costly mistakes and maintain stable, secure systems.
This article explains what raw (裸) devices are, how to identify and use them with Oracle on Unix, their performance advantages, when they should be employed, and practical tips for configuration, backup, and related storage considerations.
This article details the design, automation, high‑availability architecture, backup strategy, and operational workflow of the HULK private‑cloud MySQL service, covering instance provisioning, table management, testing environments, optimization tips, data recovery, and future plans.
This article provides a comprehensive, step‑by‑step guide on MySQL backup strategies, security hardening, SQL coding standards, and system planning, offering practical recommendations, verification methods, and actionable checklists to help DBAs build resilient and well‑managed database environments.
This guide explains how to use SRVCTL to view the status of Oracle RAC databases, instances, services, node applications, and ASM instances, retrieve configuration details, start and stop the cluster, and perform backup and restore operations with concrete command examples.
After a mistaken rm -rf command wiped an entire production server—including MySQL data—the author chronicles a step‑by‑step recovery using ext3grep, custom scripts, and binlog restoration, highlighting lessons learned and best practices for future incident handling.
This article explains RAID fundamentals, compares common RAID levels, shows how to identify the configured RAID using MegaCli, evaluates write policies and battery status, and recommends optimal RAID configurations for MySQL data, binary logs, and redo files.
This guide explains MySQL backup fundamentals, comparing cold backups, LVM snapshot backups, logical tools like mysqldump and mydumper, and physical solutions such as Percona Xtrabackup, detailing each method’s workflow, advantages, limitations, and how to achieve consistent recovery points and times.
This guide shares a senior DBA’s hard‑learned lessons on mastering MySQL environments, ensuring data security, handling routine operations, designing robust architectures, and adopting the right mindset to reduce costly mistakes and improve reliability in production systems.
This guide explains how to restore an accidentally dropped MySQL database by leveraging nightly full backups and incremental binlog files, detailing the required configuration, command usage, and step‑by‑step procedures to safely recover lost data.
This guide outlines the ten core toolsets—ranging from Linux basics and network services to scripting, firewalls, monitoring, clustering, and backup—that aspiring Linux operations engineers need to master for effective system administration.
WeChat’s WCDB component tackles pervasive SQLite corruption on mobile devices by combining dump‑based, backup, and B‑tree parsing recovery methods, achieving up to 78% success while supporting encrypted databases, large data volumes, and seamless user experience.
This guide walks through the most common MySQL backup methods—including mysqldump, mysqlbackup, mysqlhotcopy, and Percona XtraBackup—detailing command syntax, options, lock behavior, restoration steps, and practical examples for both logical and physical backups.
This article presents two comprehensive Shell scripts—one to validate Oracle RMAN backup sets and another to perform a full backup‑restore experiment—detailing SSH trust configuration, source information collection, log transfer, directory preparation, and step‑by‑step RMAN restore commands, all illustrated with practical screenshots and a GitHub repository link.
This tutorial walks through essential MySQL command-line operations on Linux, covering database connection, creation, deletion, backup strategies, restoration, renaming, and detailed table manipulation such as creating, modifying, and querying data.
Facing a 0.02% SQLite corruption rate that threatened years of chat history, the WeChat mobile team identified three main causes—insufficient space, power loss, and sync failures—and implemented space management, full sync settings, and master‑table backups, halving damage and doubling repair success.
This guide outlines nine practical MySQL recovery methods—including full backup with binlog, business‑logic rollback, flashback tools, innodb_force_recovery, tablespace discard/import, manual ibd editing, extundelete, and Percona's recovery utility—to help DBAs restore data after accidental deletions, corruption, or hardware failures.
WeChat reduced its SQLite chat‑record corruption rate by over 50% by optimizing storage space, enforcing full file synchronization (including iOS fullfsync), and implementing a dual‑backup strategy for the master table with CRC checks and pre‑allocated space, dramatically improving repair success.
This article outlines practical steps DBAs can take to prevent data leakage and loss, covering user and profile management, privilege minimization, audit logging, vulnerability patching, high‑availability solutions like RAC and Data Guard, and effective backup and recovery drills.
This guide explains how to use Percona XtraBackup for fast single‑table recovery in both local full‑backup and remote streaming scenarios, detailing preparation steps, command examples, and essential configuration tweaks to minimize downtime and data loss.
This article provides a comprehensive overview of backup concepts, various backup architectures such as Host, LAN, LAN‑free, Server‑free and Server‑less, evaluates leading enterprise backup solutions, and analyzes key features like deduplication, NDMP support, OS compatibility and maintainability.
This article outlines the five evolutionary stages of a MySQL deployment—table design, deployment, performance tuning, architecture scaling, and maintenance—detailing practical configuration tweaks, kernel and hardware optimizations, replication strategies, caching, sharding, partitioning, and essential monitoring and backup techniques.
This article explains why Redis data must be persisted, compares the two built‑in methods—RDB snapshotting and Append‑Only File (AOF)—and provides practical configuration tips, command usage, performance considerations, and verification tools for reliable backup and recovery.
The article reflects on the GitLab database deletion incident, analyzing how human error, decision fatigue, inadequate backup strategies, and insufficient safeguards exposed reliability gaps, and proposes practical DevOps practices—such as pair operations, diversified redundancy, strict command restrictions, and continuous feedback—to strengthen complex software systems.
The article recounts a GitLab production database deletion caused by a mistaken command, analyzes why the backup mechanisms failed, and offers technical and cultural recommendations—including automation, proper replication, and transparent post‑mortems—to build more reliable, high‑availability systems.
This article recounts the GitLab production database deletion incident, analyzes why backup mechanisms failed, shares technical and cultural lessons on operational practices, and offers concrete recommendations for building resilient, high‑availability systems to prevent data loss.
GitLab.com suffered a catastrophic database outage on February 1, 2017 when an exhausted operator mistakenly ran a destructive rm command on the wrong server, wiping most production data; the incident’s timeline, root causes, recovery steps, and lessons learned are detailed in this post‑mortem.
This guide walks through simulating a catastrophic Oracle database failure, performing incremental RMAN backups, verifying backup completeness, and executing a full restore and recovery—including spfile, controlfile, datafiles, and archived logs—so you can confidently recover a database after total data loss.
This article explains how to standardize and automate MySQL operations—including multi‑instance deployment, metadata collection, monitoring, backup, and high‑availability using Zookeeper—so that large‑scale database services can be provisioned, managed, and scaled with minimal human intervention.
This comprehensive guide explains MySQL GTID fundamentals, its syntax, how to view and generate GTIDs, configure GTID‑based replication, troubleshoot replication errors, integrate GTID with backup/restore, MHA failover, and ensure crash‑safe slaves while discussing performance trade‑offs.
This article provides a comprehensive, hands‑on guide to MySQL master‑slave replication, covering configuration changes, creating replication users, backing up the master, restoring to slaves, setting up read/write splitting, handling master failures, implementing dual‑master setups, and performing full and incremental backups and restores.
This article explains the importance of data storage, describes single‑node storage engines and data models, outlines transaction and concurrency control, and covers distributed storage principles, CAP and FLP theorems, 2PC and Paxos protocols, as well as redundancy, backup, and failover mechanisms.
This article explains how to design and implement a reliable etcd disaster‑recovery system for a Kubernetes‑based platform, covering backup scheduling, data synchronization across sites, code structure, and the advantages and drawbacks of the approach.
This guide explains why backup security is critical for enterprise databases, introduces Oracle RMAN's three encryption strategies, and provides step‑by‑step commands to configure password‑based encryption, perform backups, handle decryption errors, and finally disable encryption safely.
This guide walks through exporting Oracle PL/SQL user objects and table data with PL/SQL Developer, then restoring them by dropping the existing user, recreating it with necessary privileges, executing the exported SQL script, and importing table data while handling constraints and triggers.
This article explains NetEase Hive RDS's instance migration feature, covering use cases, technical challenges such as consistent backup, business impact, data import speed, incremental sync, and the solutions implemented—including multi‑threaded logical backup with mydumper, load‑aware throttling, parallel import with myloader, and filtered replication—to achieve efficient and safe MySQL migrations.
This guide shows how to restore a MySQL database that was accidentally dropped by combining a nightly full mysqldump backup (with master‑log info) and the subsequent binlog files, extracting only the needed statements and replaying them in order.
This article outlines the lifecycle of a mature MySQL database architecture, covering table design, deployment, performance tuning, scaling strategies such as replication, sharding and partitioning, as well as maintenance tasks like monitoring, backup, and repair, with practical configuration examples.