This article explains MySQL backup fundamentals, compares cold, snapshot, logical (mysqldump, mydumper) and physical (Xtrabackup) methods, outlines their workflows, pros and cons, and discusses lock‑related performance impacts and Percona's backup‑lock improvements.
This guide explains why data backup is essential, outlines backup types (full, incremental, differential), compares MySQL backup methods (hot, warm, cold), evaluates physical vs logical approaches, reviews common tools like mysqldump, cp, tar, LVM snapshots, and xtrabackup, and offers strategies for choosing the right solution.
This guide provides step‑by‑step instructions for connecting to MySQL, creating and managing users and permissions, displaying, creating and deleting databases and tables, performing backups and restores, and executing various query operations such as selecting, updating, and aggregating data.
This article explains the components, communication mechanisms, full and incremental backup procedures, and restoration steps of Percona XtraBackup (PXB), detailing how the innobackupex script and xtrabackup binary cooperate to perform hot physical backups of MySQL/InnoDB databases.
This article explains why the DBMP platform was created to automate MySQL operations, describes its architecture and key features such as host management, instance groups, backup, slow‑query handling, and scheduled tasks, and outlines future optimization directions and common technical Q&A.
Backup environments generate abundant duplicate data, making deduplication essential; this article examines how purpose‑built backup appliances (PBBA) and leading backup software implement variable‑length, global deduplication, compare scale‑out versus scale‑up architectures, and discuss performance trade‑offs and CPU bottlenecks.
This article examines how deduplication and compression technologies, widely used in backup environments, are adapted for primary storage systems—particularly HDD arrays—by analyzing differences in I/O size, patterns, performance requirements, resource allocation, and implementation approaches of major vendors such as NetApp and EMC.
This article explains data deduplication technology, its definition, various classification schemes based on execution time, block size, granularity, and location, and compares it with data compression, highlighting how both techniques can be combined to maximize storage savings.
This article presents a comprehensive guide to MySQL optimization, covering its strengths and weaknesses, daily DBA tasks, development and operational standards, sharding strategies, backup solutions, performance tuning, replication options, InnoDB configuration, system-level tweaks, and future improvement directions.
This article details Facebook's MySQL backup architecture, covering preparation, logical backup format, storage locations, source selection, full and incremental backup pipelines, verification mechanisms, and future directions such as RBR‑based logical incremental backups.
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.
To protect MySQL databases from unauthorized access and performance issues, this guide outlines fourteen essential security measures—including restricting remote access, regular backups, disabling default accounts, tightening user privileges, securing configuration files, and enabling logging—providing concrete commands and configuration snippets for robust protection.
This guide outlines practical MySQL hardening techniques—including restricting remote access, regular backups, disabling unsafe features, managing root credentials, removing test databases, and applying security patches—to protect data integrity and prevent unauthorized intrusion.
This article explains XenServer's high‑performance virtualization features, OVF/OVA export capabilities, snapshot‑based backup methods, disaster‑recovery replication, XenCenter management console functions, integration with Microsoft System Center, and the open XenAPI that enables third‑party automation.
This article provides a comprehensive guide to MySQL performance optimization, covering isolation levels, MVCC, schema design, index strategies, query execution, partitioning, replication, scaling, hardware considerations, and backup/recovery techniques for building high‑performance, reliable database systems.
This article presents a comprehensive overview of PostgreSQL, covering its history, architecture, core features, step‑by‑step lab exercises for database creation, CRUD operations, configuration tuning, performance monitoring, backup and recovery, Hot Standby replication, PGPOOL clustering, and a curated Q&A session addressing common DBA challenges.
This comprehensive guide outlines practical PostgreSQL security measures—including hardened authentication, encrypted data transmission, column‑level encryption, strict permission controls, backup strategies, auditing, patch management, and resource monitoring—to help DBAs protect their databases from unauthorized access and attacks.
This article explains why MySQL migration is essential, outlines various migration strategies—including full, partial, and cross‑datacenter moves—and provides detailed, step‑by‑step procedures, best‑practice tips, and precautionary measures to ensure a smooth, reliable transition.
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.
DD Boost integrates tightly with Oracle RMAN to provide a flexible, policy‑driven backup solution that allows DBAs to manage local and disaster‑recovery sites independently, simplifies deployment via a simple plugin, and dramatically improves performance by sending only unique data blocks to Data Domain for deduplication.
The article explains how NetWorker 8.0 introduced Synthetic Full Backup, its inefficiencies with Data Domain, and how NetWorker 8.1, NetBackup, and DD Boost add Virtual Synthetics to accelerate synthetic backups by using metadata pointers instead of full data restoration.
The article explains VMware vSphere as a cloud‑based data‑center virtualization suite, detailing its main components such as ESXi, vCenter, vSphere Client, and Web Access, and covering disaster recovery, backup technologies, storage APIs, and various storage provisioning methods like vSAN, VMFS, RDM, NFS/CIFS and vVol.
This article introduces EMC's DD Boost—a proprietary protocol for Data Domain that improves backup efficiency, lists the backup applications that support it, explains required TCP ports and storage unit setup, and outlines its key features such as distributed segment processing and load balancing.
Redis offers two persistence strategies—RDB snapshots and AOF command logging—each with distinct generation methods, configuration options, and recovery processes, allowing users to balance speed, safety, and data durability based on workload requirements.
This article walks through the full lifecycle of a MySQL database—from initial table design and single‑server deployment to performance tuning, kernel and hardware tweaks, scaling with replication, caching, sharding, partitioning, and essential maintenance tasks such as monitoring, slow‑query logging, backup and repair.
This article presents a comprehensive collection of useful Linux command-line utilities—including dstat, screen, tmux, multitail, rsync, and many others—explaining their purposes, typical use cases, and where to obtain them, helping system administrators and developers improve productivity and monitoring.
This article shares Meituan’s practical strategies for efficient database operations, covering rapid business growth handling, automated DDL workflows, systematic training, capacity planning, backup automation with xtrabackup, and real‑world Q&A on monitoring, replication, and disaster recovery.
This article explains how to convert and restore SQL Server 2000 backup files to SQL Server 2005, detailing direct restore steps, required file extensions, path adjustments, and key differences such as database creation requirements and naming conventions between the two versions.
Learn how to replace traditional backup methods with rsync and inotify for fast, secure, incremental file synchronization, covering rsync fundamentals, command options, server and client configuration, inotify monitoring scripts, and testing procedures to achieve real‑time data replication between Linux servers.
This article outlines four key practices—comprehensive engineering documentation, robust business backup, continuous online monitoring, and regular periodic inspections—that together ensure optimal performance, reliability, and long‑term benefits for data center operations.
This article compiles a comprehensive list of open‑source tools covering backup, cloning, cloud platforms, cloud workflows, distributed file systems, cloud storage, code review, collaboration suites, CMDB, configuration management, continuous integration/deployment, DNS, hosting control panels, IT asset management, and LDAP, providing a valuable resource for IT professionals.
MongoDB 3.0 introduces a pluggable storage engine API with WiredTiger support, expands backup set capacity, adds sharding enhancements, improves security with SCRAM‑SHA‑1 authentication, and upgrades tooling and logging, while retaining MMAPv1 as the default engine.
This guide walks Linux system administrators through rsync's core concepts and a comprehensive set of options—such as -t, -I, -v, -z, -r, -l, -p, -a, and delete flags—explaining their effects, pitfalls, and best‑practice usage for reliable file and directory synchronization.
This guide explains how rsync synchronizes files and directories on Linux, details its most useful options, shows how to configure an rsync daemon with the required configuration files, and outlines the various command syntaxes for local and remote operations.
