Tagged articles
database backup
46 articles · Page 1 of 1
Databasus is an open‑source backup management platform that unifies PostgreSQL, MySQL, MariaDB and MongoDB backups with a web UI, offering logical, physical and incremental backups, automated scheduling, AES‑256‑GCM encryption, multi‑cloud storage, RBAC collaboration, and optional agents for secure, out‑bound connections.
AES-256-GCMDatabasusDocker
0 likes · 14 min read

The article uses the drama “E‑commerce Storm” to illustrate how failures in the four‑layer e‑commerce architecture—front‑end, business logic, data persistence, and server/operations—lead to order chaos, permission breaches, database crashes, and DDoS attacks, and shows how refactoring and security hardening can prevent collapse.
Cloud OperationsRBACdatabase backup
0 likes · 6 min read

The article outlines why e‑commerce systems fail, presents a four‑layer high‑availability defense—including load balancing, service isolation, data protection, and fallback mechanisms—plus concrete monitoring, alerting, and emergency response practices illustrated with real‑world scenarios and code samples.
High Availabilitydatabase backupdisaster recovery
0 likes · 6 min read

Databasus is a free, self‑hosted open‑source backup solution that supports PostgreSQL, MySQL, MariaDB and MongoDB, offers flexible scheduling, multiple storage backends, enterprise‑grade encryption, team collaboration features, and can be installed via a Linux script or Docker with detailed usage steps.
Dockerautomationdatabase backup
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 guide explains why Amazon S3 is an economical, scalable storage option for SQL Server backups and provides a step‑by‑step tutorial—including IAM policy creation, bucket setup, backup job scripting, synchronization, and cleanup—to achieve automated, reliable, and cost‑effective data protection.
AWS S3SQL Serverautomation
0 likes · 7 min read

This guide explains how to use mysqldump to back up individual databases, multiple databases, all databases, specific tables, and how to compress backups, include drop statements, export only schema, and restore data using both interactive and non‑interactive MySQL commands, plus an automated backup script.
Bash ScriptCompressionMySQL
0 likes · 9 min read


21CTOApr 24, 2025 · Databases
MySQL 9.3 introduces powerful backup enhancements, JavaScript stored‑procedure support, advanced query optimization, and a new Group Replication primary‑election feature, all aimed at improving reliability, performance, and developer flexibility, making it a compelling upgrade for enterprises and developers alike.
Group ReplicationJavaScript stored proceduresMySQL
0 likes · 3 min read

This guide explains how to use mysqldump to back up a single MySQL database, multiple databases, or all databases, includes options for specific tables, compression with gzip, adding drop statements, exporting only schema, and provides restore procedures and a sample automated backup script.
MySQLSQLdatabase backup
0 likes · 11 min read

This article compiles real‑world operations incidents—from accidental database deletions and faulty deployments to hidden data tampering and network device failures—highlighting how quick diagnosis, preventive maintenance, and SRE practices can mitigate impact on users, reputation, and revenue.
Case StudiesSREdatabase backup
0 likes · 6 min read

This guide explains how to back up single or multiple MySQL databases, entire server instances, specific tables, or only schema, using mysqldump with options like -B, gzip compression, add‑drop flags, and provides restore procedures and an automated backup script.
GZIPMySQLRestore
0 likes · 10 min read

This article provides step-by-step Bash scripts for automating daily MySQL database backups, compressing tables, cleaning old archives, and configuring master‑master replication, including detailed commands for dumping databases, creating tar.gz packages, and setting up replication parameters on Linux servers.
MySQLReplicationautomation
0 likes · 4 min read

When a MySQL 5.7 instance crashes without backups or redundancy, this guide shows how to recover both table structures and data using the open‑source tools dbsake and ibd2sql, providing exact commands, parameter explanations, and practical tips for a successful rescue.
MySQLSQLdata recovery
0 likes · 5 min read

This step‑by‑step tutorial shows how to install Percona XtraBackup 2.4, create full, incremental and compressed backups of MySQL 5.1‑5.7, prepare the backups, and restore data using Docker or native Linux packages.
CompressionDockerLinux
0 likes · 11 min read


ITPUBAug 7, 2024 · Databases
This guide provides a comprehensive collection of ready-to-use shell scripts and step-by-step instructions for backing up and restoring major databases—including Oracle RMAN, logical and physical backups, MySQL full and incremental backups with Xtrabackup, PostgreSQL logical and physical backups, and openGauss dump scripts—plus scheduling and cleanup procedures.
MySQLOraclePostgreSQL
0 likes · 19 min read

The article explains how to respond to accidental MySQL data deletion by analyzing loss causes, choosing recovery methods such as mysqldump backups, binary‑log point‑in‑time restores, or Percona’s InnoDB tool, provides step‑by‑step commands, and recommends preventive practices like regular backups, transactions, and strict permissions.
Database SecurityMySQLbinlog
0 likes · 3 min read

This article explains the new mysqld-long-query-time option added to MySQL 8.0.30's mysqldump tool, shows how to configure it, presents comparative experiments demonstrating its effect on slow‑query logs, and provides conclusions and additional notes for practical database backup scenarios.
MySQLSQLdatabase backup
0 likes · 8 min read

This guide provides complete shell scripts and step‑by‑step instructions for performing remote backups and restores of MySQL, Oracle, and PostgreSQL databases on Linux, including directory creation, compression, secure copy, cron scheduling, and cleanup of old backup files.
LinuxMySQLOracle
0 likes · 15 min read

Vivo replaced its fragile Python‑Celery backup system on GlusterFS—characterized by two‑day MySQL backups, single‑point failures, and weak security—with a Java‑based architecture using a Redis cluster and object storage, adding automated copying, verification, point‑in‑time recovery and migration, cutting backup windows to about ten hours and achieving near‑100 % success.
MongoDBMySQLTiDB
0 likes · 28 min read

The article details Qunar’s senior DBA Qian Fangyuan’s redesign of the company’s database backup and recovery platform, explaining the shortcomings of the legacy system, the new architecture, high‑performance backup techniques using Xtrabackup, dynamic throttling, storage abstraction, and the resulting dramatic improvements in backup and restore speeds and reliability.
Dynamic ThrottlingStorage InterfaceXtraBackup
0 likes · 35 min read

This article presents a comprehensive analysis of the shortcomings of an existing database backup solution and details the architecture, high‑performance backup and restore mechanisms, dynamic throttling, storage abstraction, and experimental results of a newly designed, scalable backup‑recovery platform for MySQL databases.
Dynamic ThrottlingMySQLXtraBackup
0 likes · 33 min read

This article explains how to use Python to automatically back up SQL databases by installing required packages, establishing a connection with pyodbc, executing backup commands, recording backup details with pandas, and scheduling the script for regular execution, providing code examples for each step.
PandasSQLdatabase backup
0 likes · 7 min read

This guide explains TiDB Binlog fundamentals, its Pump‑Drainer architecture, how to scale Drainer nodes, use the Reparo tool to parse binlog files, and combine full backups with binlog for reliable data recovery after accidental deletions.
Cluster ScalingReparoTiDB
0 likes · 16 min read

This guide explains how to prepare the environment, install required dependencies and a newer GCC toolset, and then compile, build, and install Percona XtraBackup 8.0 from source on an Aarch64 Kylin v10 system, including troubleshooting tips for common issues.
LinuxMySQLPercona XtraBackup
0 likes · 9 min read

Easy Dump is a Bash‑based utility that streamlines PostgreSQL backups by wrapping pg_dump and pg_dumpall, offering multiple dump modes, parallel execution, table exclusion, automatic configuration generation, and detailed success or failure notifications for reliable database migration and maintenance.
Easy Dumpdatabase backupparallel dump
0 likes · 68 min read

This article explains why backup is the last line of data security, outlines multi‑location and multi‑media deployment requirements, compares physical and logical backup methods, reviews MySQL backup tools, evaluates their speed, and provides practical guidance for testing backup validity and minimizing RTO and RPO.
Logical BackupMySQLPhysical Backup
0 likes · 14 min read

The article investigates a bug introduced in MySQL 5.7.36 where mysqldump writes the SET @@GLOBAL.GTID_PURGED statement at the end of the dump file, causing GTID and data inconsistencies that break replication, and recommends using an older mysqldump version until the issue is fixed.
GTIDMySQLReplication
0 likes · 9 min read

This article recounts a real-world incident where a client mistakenly imported 60,000 rows of erroneous Excel data into a MySQL production database, leading to an accidental bulk delete, and explains how the team used MySQL binlog to recover the lost data while offering practical safeguards to prevent similar disasters.
MySQLSQLbinlog
0 likes · 17 min read

The article investigates the MySQL 5.7 sys schema ERROR 1356 caused by mysqldump --all-databases dropping mysql.proc, explains why the bug occurs, cites official documentation and bug reports, and provides four practical solutions including mysql_upgrade, separate sys backups, using --databases, and rebuilding from mysql‑sys.
ERROR 1356MySQLbug
0 likes · 12 min read

The MySQL Clone Plugin, added in 8.0.17, enables fast local or remote cloning of InnoDB data by installing the plugin, issuing CLONE commands, monitoring progress via performance_schema tables, and using the resulting GTID or binlog coordinates to build replicas, while observing limitations such as DDL restrictions and single‑instance operation, and offering advantages over XtraBackup through an extra page‑copy stage and simplified GTID handling.
Clone PluginInnoDBMySQL
0 likes · 22 min read

This guide explains how to install Percona XtraBackup 2.4, perform hot full backups of MySQL 5.7 databases, compress and transfer them, and configure master‑slave replication using innobackupex and standard MySQL commands.
MySQLPerconaReplication
0 likes · 6 min read

The article explains how MySQL multi‑source replication can be employed to back up, horizontally or vertically partition, and merge data from several servers into a single target database, illustrating three typical scenarios and providing example SQL for data consolidation.
Multi-Source ReplicationMySQLVertical Partitioning
0 likes · 5 min read

After costly data‑deletion mishaps, 37 Interactive Entertainment engineered a robust, multi‑region backup platform that evolved from simple cron scripts to streaming xtrabackup with Celery‑driven task queues, encrypted HDFS/S3 storage, automated rotation and restore verification, ensuring reliable protection against high‑impact data loss.
Backup ArchitectureXtraBackupcelery
0 likes · 7 min read

This tutorial explains how to use Navicat to back up a test database, delete and restore product data, and synchronize schema changes between test and production databases, providing detailed step‑by‑step instructions with screenshots.
NavicatSQLStructure Sync
0 likes · 5 min read

This guide explains why the community edition of MongoDB lacks native hot backup, how Percona MongoDB adds online backup support, the underlying backup and restore principles, and provides a step‑by‑step PHP script with environment setup, configuration, execution, and scheduling instructions.
HotBackupMongoDBPHP
0 likes · 7 min read

This article details YOOZOO Network's evolution from physical to virtualized and clustered game server architectures, the automation of operations across three generations, the design of the UJOBS job platform, robust database backup strategies, and a step‑by‑step migration of thousands of servers to Alibaba Cloud.
Cloud Operationsautomationdatabase backup
0 likes · 11 min read


21CTOFeb 2, 2017 · Operations
The GitLab production database was mistakenly deleted during a manual fix, exposing gaps in backup strategies, PostgreSQL configuration, and operational practices, and prompting a detailed post‑mortem that highlights the need for automated recovery, proper tooling, and transparent incident handling.
OperationsPostgreSQLdata loss
0 likes · 15 min read

This article explains a comprehensive database backup workflow—including daily full backups with xtrabackup, real‑time binlog incremental backups, multi‑level retention policies, automated failure detection, disaster‑recovery across multiple data centers, and fast table‑level restoration—to help prevent prolonged outages.
backup retentiondata recoverydatabase backup
0 likes · 6 min read

A GitLab.com database accident caused the loss of 310 GB of data, exposing multiple failed backup mechanisms and prompting a detailed analysis of technical, operational, and managerial lessons for reliable data protection.
DBAGitLabOperations
0 likes · 7 min read

This article examines the Hearthstone database rollback incident, highlighting the timeline, power‑related hardware failures, backup shortcomings, and offers concrete MySQL backup and server‑monitoring recommendations to prevent similar data loss in game operations.
MySQLdata recoverydatabase backup
0 likes · 5 min read


ITPUBOct 21, 2016 · Databases
A developer discovers a nearly full 1 TB server disk caused by large SQL Server backup files, learns the backup strategy, removes old backups while keeping monthly snapshots, manually syncs production data to a test server, and reflects on backup file formats and storage optimization.
DBASQL Serverdata synchronization
0 likes · 7 min read


ITPUBJul 28, 2016 · Databases
This guide provides comprehensive Oracle database interview questions and answers covering SQL tuning techniques such as join types, execution‑plan inspection, CBO vs RBO, heavy‑SQL identification, session tracing, index structures, binding variables, plan stability, memory settings, tablespace management, backup and recovery methods including RMAN and standby, as well as system performance diagnostics.
CBOOraclePerformance Diagnosis
0 likes · 19 min read


ITPUBApr 5, 2016 · Databases
This guide walks through adding a third MySQL replica to an existing master‑slave setup without restarting the service, comparing a logical mysqldump backup method with the faster physical XtraBackup approach and providing step‑by‑step commands and configuration details.
MySQLReplicationSlave Setup
0 likes · 11 min read

The article explains how Copy Data Virtualization technology, exemplified by Actifio, consolidates Oracle and VMware data backup, disaster recovery, and development testing into a single platform, reducing production load, storage costs, and recovery time while providing incremental, always‑on data copies.
Copy Data VirtualizationData ManagementOracle
0 likes · 12 min read


ITPUBNov 9, 2015 · Databases
This guide walks you through using the MySQL command‑line tools on Windows to export a database with mysqldump, troubleshoot common errors, and restore the data with the mysql client and source command, covering path setup, syntax nuances, and file locations.
MySQLcommand-linedatabase backup
0 likes · 4 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
