BestHub
Sign in
Tagged articles
483 articles
Page 2 of 5
MaGe Linux Operations
MaGe Linux Operations
Aug 29, 2024 · Databases

Database Server Ops: Hardware, Tuning, Backup & Security Best Practices

This guide outlines comprehensive best practices for database server operations, covering hardware selection, OS and kernel tuning, storage choices, MySQL configuration, performance monitoring, backup strategies, security measures, high availability, automation, and systematic maintenance procedures to ensure optimal reliability and efficiency.

BackupOperationsSecurity
0 likes · 7 min read
Database Server Ops: Hardware, Tuning, Backup & Security Best Practices
Open Source Linux
Open Source Linux
Aug 23, 2024 · Operations

10 Proven Ops Practices to Prevent System Failures

This article shares ten practical operations strategies—including change rollbacks, safe handling of destructive commands, prompt customization, rigorous backup and verification, production environment discipline, careful handovers, robust alerting, cautious automatic failover, meticulous checks, and simplicity—to dramatically improve system reliability and availability.

BackupOperationsincident response
0 likes · 17 min read
10 Proven Ops Practices to Prevent System Failures
Liangxu Linux
Liangxu Linux
Jul 29, 2024 · Databases

Automate MySQL Backups and Restores with Bash, Cron, and Find

This guide shows how to create a Bash script that backs up a specific MySQL database using mysqldump, compresses the dump, automatically deletes old backups, explains the find -mtime option, and schedules the process with cron, plus detailed steps for restoring the data.

BackupDatabase Restorationcron
0 likes · 7 min read
Automate MySQL Backups and Restores with Bash, Cron, and Find
Java Tech Enthusiast
Java Tech Enthusiast
Jul 3, 2024 · Databases

MySQL Database Backup with Shell Script and Cron

This guide explains how to set up automated MySQL database backups using a shell script that runs mysqldump (optionally compressed), stores the files on a local disk, makes the script executable, and schedules it with a cron job after verifying disk space and cron availability.

BackupShellcron
0 likes · 5 min read
MySQL Database Backup with Shell Script and Cron
Architecture and Beyond
Architecture and Beyond
Jun 1, 2024 · Operations

Comprehensive Guide to Data Backup and Disaster Recovery Strategies

This article examines real-world backup failures, explains why backups are essential, outlines what data and system components should be backed up, describes backup principles, classifications, technologies, and disaster recovery planning, and offers practical guidance for building robust, multi-layered backup strategies.

BackupCloud BackupIT Operations
0 likes · 13 min read
Comprehensive Guide to Data Backup and Disaster Recovery Strategies
DevOps Operations Practice
DevOps Operations Practice
May 20, 2024 · Cloud Computing

Google Cloud Data Deletion Incident at UniSuper: Causes, Impact, and Lessons Learned

Google Cloud mistakenly deleted data and backups for Australian pension fund UniSuper, causing over 600,000 members to lose access for more than a week, and the incident highlights the risks of single‑provider reliance, the importance of robust backup strategies, and the growing relevance of hybrid and multi‑cloud architectures.

BackupData lossGoogle Cloud
0 likes · 5 min read
Google Cloud Data Deletion Incident at UniSuper: Causes, Impact, and Lessons Learned
MaGe Linux Operations
MaGe Linux Operations
May 19, 2024 · Databases

How to Deploy Xenon: A Raft‑Based MySQL HA Solution with Semi‑Sync and Parallel Replication

This guide walks through deploying Xenon, an open‑source Raft‑based MySQL high‑availability solution, covering environment setup, installation of Go and Percona XtraBackup, configuring Xenon’s JSON, starting the cluster, monitoring status, and troubleshooting backup failures caused by misconfigured host settings.

BackupDatabase ReplicationGo
0 likes · 8 min read
How to Deploy Xenon: A Raft‑Based MySQL HA Solution with Semi‑Sync and Parallel Replication
macrozheng
macrozheng
Apr 29, 2024 · Databases

How to Recover Accidentally Deleted MySQL Data: A Step-by-Step Guide

This guide explains how to answer MySQL accidental deletion interview questions and outlines practical recovery methods—including backup restoration, binlog usage, third‑party tools—and essential preventive practices such as regular backups, transaction handling, and permission management.

BackupBinlogData Recovery
0 likes · 5 min read
How to Recover Accidentally Deleted MySQL Data: A Step-by-Step Guide
21CTO
21CTO
Apr 12, 2024 · Databases

PostgreSQL vs MySQL: Which Database Wins for Full‑Stack Development?

This article compares PostgreSQL and MySQL across history, ACID compliance, performance, scalability, advanced features, tooling, security, backup strategies, and Linux installation steps, helping full‑stack developers choose the most suitable open‑source relational database for their projects.

ACIDBackupLinux Installation
0 likes · 12 min read
PostgreSQL vs MySQL: Which Database Wins for Full‑Stack Development?
ITPUB
ITPUB
Apr 12, 2024 · Databases

How to Recover Accidentally Deleted Oracle Databases: Step‑by‑Step Guide

This guide explains how to rescue both physically and logically deleted Oracle databases, covering RMAN file recovery, full database restoration, flashback table techniques, recycle‑bin usage, flashback database configuration, and essential backup strategies to prevent data loss.

BackupDatabase RecoveryFlashback
0 likes · 10 min read
How to Recover Accidentally Deleted Oracle Databases: Step‑by‑Step Guide
Liangxu Linux
Liangxu Linux
Apr 10, 2024 · Operations

Master Advanced tar Techniques: Compression, Incremental Backups, and Encryption

This guide explains the tar command’s advanced capabilities—including adding files to existing archives, using gzip or bzip2 compression, extracting specific files with wildcards, creating incremental backups, excluding paths, encrypting archives, limiting archive size, and directing output to custom directories—providing clear examples for each scenario.

BackupFile Compressioncommand-line
0 likes · 6 min read
Master Advanced tar Techniques: Compression, Incremental Backups, and Encryption
Selected Java Interview Questions
Selected Java Interview Questions
Mar 14, 2024 · Cloud Native

Comprehensive Guide to Kubernetes Fundamentals, Networking, Security, and Best Practices

This article provides an extensive overview of Kubernetes, covering its core architecture, pod IP design, environment setup, networking models, plugins, security measures, backup strategies, monitoring solutions, Helm usage, gray releases, service mesh concepts, and CI/CD pipeline implementation, offering practical insights for developers and operators.

BackupCloud NativeNetworking
0 likes · 32 min read
Comprehensive Guide to Kubernetes Fundamentals, Networking, Security, and Best Practices
Liangxu Linux
Liangxu Linux
Mar 7, 2024 · Operations

Replace scp with rsync: Reliable File Transfers and Resume Support

This guide explains why rsync outperforms scp for file copying, shows how to install it on various Linux and macOS systems, and demonstrates command options—including compression, partial transfers, and SSH tunneling—to reliably resume interrupted transfers.

Backupfile transferlinux
0 likes · 5 min read
Replace scp with rsync: Reliable File Transfers and Resume Support
MaGe Linux Operations
MaGe Linux Operations
Feb 16, 2024 · Databases

Master Oracle Data Guard: Step‑by‑Step Master‑Slave Setup Guide

This comprehensive tutorial walks you through configuring Oracle Data Guard for master‑slave replication, covering prerequisites, detailed command‑by‑command steps, common pitfalls, testing procedures, switchover operations, and post‑switch recovery, all illustrated with diagrams and code snippets.

BackupData GuardDatabase Replication
0 likes · 24 min read
Master Oracle Data Guard: Step‑by‑Step Master‑Slave Setup Guide
Java Captain
Java Captain
Feb 16, 2024 · Databases

Key MySQL Concepts and Best Practices

This article summarizes essential MySQL concepts—including basic terminology, data types, SQL commands, indexes, views, storage engines, backup methods, and performance tuning techniques—to help developers understand and effectively apply this powerful open‑source relational database in real‑world projects.

BackupStorageEnginedatabase
0 likes · 4 min read
Key MySQL Concepts and Best Practices
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 7, 2024 · Databases

Accelerating MySQL Data Recovery with Xtrabackup: Scenarios and Techniques

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.

BackupRecoveryReplication
0 likes · 21 min read
Accelerating MySQL Data Recovery with Xtrabackup: Scenarios and Techniques
MaGe Linux Operations
MaGe Linux Operations
Feb 7, 2024 · Databases

How to Build a Real‑Time Data Guard System for Dameng Database

This guide walks through setting up a Dameng data‑guard service using a primary, standby, and monitor server, covering data preparation, configuration of dm.ini, dmmal.ini, dmarch.ini, dmwatcher.ini, starting services, OGUID setup, mode switching, and monitoring to achieve high‑availability replication.

BackupDamengData Guard
0 likes · 12 min read
How to Build a Real‑Time Data Guard System for Dameng Database
Open Source Linux
Open Source Linux
Jan 15, 2024 · Cloud Native

Automate Kubernetes Local Storage and Backup with Carina and Velero

This guide explains why local storage remains essential in the cloud‑native era, outlines a step‑by‑step plan to set up a Kubernetes cluster, deploy Carina for automated local disk management, configure a test Nginx workload, install MinIO and Velero for backup, and finally perform backup and restore operations to verify data integrity.

BackupCarinaCloud Native Storage
0 likes · 30 min read
Automate Kubernetes Local Storage and Backup with Carina and Velero
Zuoyebang Tech Team
Zuoyebang Tech Team
Dec 22, 2023 · Databases

Unlocking Intelligent Database Operations: Inside Zyb’s Multi‑Cloud Platform

This article details how Zyb’s multi‑cloud database platform integrates diverse database types, a unified proxy layer, intelligent lifecycle management, automated task orchestration, monitoring, resource allocation, backup, and fault‑handling to achieve efficient, reliable, and secure database operations across cloud environments.

BackupIntelligent Operationsdatabases
0 likes · 19 min read
Unlocking Intelligent Database Operations: Inside Zyb’s Multi‑Cloud Platform
ITPUB
ITPUB
Nov 21, 2023 · Operations

How I Survived an Accidental rm -fr /* Disaster and Restored My Server

A developer recounts accidentally running rm -fr /* on a production server, explains how quick interruption, clever use of remaining commands, and step‑by‑step recovery restored critical directories, and shares practical safeguards to prevent such catastrophic deletions in the future.

BackupData RecoverySafety
0 likes · 11 min read
How I Survived an Accidental rm -fr /* Disaster and Restored My Server
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 13, 2023 · Databases

MySQL Backup and Recovery Best Practices

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.

BackupPercona XtraBackupRPO
0 likes · 13 min read
MySQL Backup and Recovery Best Practices
php Courses
php Courses
Nov 4, 2023 · Databases

Common Causes of MySQL Database Crashes and Their Solutions

This article outlines the typical reasons MySQL databases crash—such as hardware failures, software issues, external attacks, and poor design—and provides practical remedies including regular backups, using myisamchk for repair, leveraging binary logs, optimizing schemas, and upgrading to newer MySQL versions.

BackupDatabase CrashRepair
0 likes · 4 min read
Common Causes of MySQL Database Crashes and Their Solutions
php Courses
php Courses
Sep 26, 2023 · Databases

Best Practices for MySQL Backup: Strategy, Tools, Automation, and Recovery

This guide outlines a comprehensive MySQL backup solution, covering backup strategy planning, choosing physical versus logical backups, using tools like mysqldump and Percona XtraBackup, automating backups with scripts and cron, storage and retention considerations, and regular recovery testing to ensure data integrity.

AutomationBackupPercona XtraBackup
0 likes · 5 min read
Best Practices for MySQL Backup: Strategy, Tools, Automation, and Recovery
Liangxu Linux
Liangxu Linux
Aug 23, 2023 · Operations

Why rsync Beats scp for Reliable File Transfers (and How to Use It)

This guide explains what rsync is, the platforms it supports, how to install it on Linux and macOS, and provides step‑by‑step commands with key options like -partial and -z to reliably copy files and resume interrupted transfers, offering a more robust alternative to scp.

Backupfile transferlinux
0 likes · 5 min read
Why rsync Beats scp for Reliable File Transfers (and How to Use It)
php Courses
php Courses
Jul 30, 2023 · Operations

How to Schedule Automatic Backups for PHP Websites on CentOS

This guide explains three practical methods—using crontab, rsync, and mysqldump—to set up scheduled backups of PHP website files and databases on a CentOS server, ensuring data protection through automated daily or periodic tasks.

BackupCentOSPHP
0 likes · 4 min read
How to Schedule Automatic Backups for PHP Websites on CentOS
Liangxu Linux
Liangxu Linux
Jul 16, 2023 · Operations

Essential Ops Checklist: Prevent Data Loss, Secure Servers, and Optimize Performance

This article compiles practical operations guidelines covering safe testing, rigorous confirmation before commands, limiting multi‑person access, mandatory backups, careful use of destructive commands, SSH hardening, firewall rules, fine‑grained permissions, continuous monitoring, performance tuning steps, and a disciplined mindset to avoid costly incidents.

BackupSecuritymonitoring
0 likes · 10 min read
Essential Ops Checklist: Prevent Data Loss, Secure Servers, and Optimize Performance
Laravel Tech Community
Laravel Tech Community
Jun 27, 2023 · Operations

Linux System Administration Commands Reference

This article provides a comprehensive reference of common Linux system administration commands, covering system information, date handling, shutdown/reboot, file and directory manipulation, searching, mounting, disk usage, user/group management, permissions, compression, package management, backup, CD/DVD handling, and networking utilities.

BackupNetworkingShell Commands
0 likes · 24 min read
Linux System Administration Commands Reference
Open Source Linux
Open Source Linux
May 12, 2023 · Operations

15 Must-Have Linux Tools to Boost Your System Management Skills

This guide introduces fifteen essential Linux utilities—from cleaning and disk recovery to encryption, configuration editing, and backup—explaining how each tool works and why it can make your system administration tasks more efficient and secure.

AdministrationBackupopen-source
0 likes · 6 min read
15 Must-Have Linux Tools to Boost Your System Management Skills
Liangxu Linux
Liangxu Linux
May 5, 2023 · Operations

15 Essential Linux Tools Every Programmer Should Know

This guide introduces fifteen powerful Linux utilities—including FSlint, TestDisk, TrueCrypt, BleachBit, and Wine—explaining their main functions, typical use cases, and how they can help programmers keep systems clean, recover data, secure files, and improve productivity.

BackupSystem Toolsopen-source
0 likes · 7 min read
15 Essential Linux Tools Every Programmer Should Know
Open Source Linux
Open Source Linux
May 5, 2023 · Operations

Essential Ops Lessons from 3.5 Years of Real-World Crises

Drawing from three and a half years of operations work, this article shares hard‑earned best practices on testing, backups, security, monitoring, performance tuning, and the right mindset to avoid costly mistakes such as data loss, service outages, and security breaches.

Backupmonitoringperformance-tuning
0 likes · 12 min read
Essential Ops Lessons from 3.5 Years of Real-World Crises
Liangxu Linux
Liangxu Linux
Apr 27, 2023 · Operations

Mastering tar: Create, Extract, List, and Manage Linux Archives

This guide explains how to use the Linux tar command to create uncompressed, gzip‑compressed, and bzip2‑compressed archives, extract whole or individual files, list archive contents, append files, verify archives, and check archive sizes, with clear examples for each operation.

Backuparchivingcommand-line
0 likes · 15 min read
Mastering tar: Create, Extract, List, and Manage Linux Archives
Efficient Ops
Efficient Ops
Apr 18, 2023 · Databases

Mastering MongoDB Clusters: Setup, Monitoring, Migration, and Optimization

This comprehensive guide explains MongoDB cluster architecture, component roles, common use cases, monitoring commands, essential maintenance operations, data migration steps, troubleshooting of typical production issues, and practical optimization recommendations for high‑performance deployments.

BackupClusterMongoDB
0 likes · 20 min read
Mastering MongoDB Clusters: Setup, Monitoring, Migration, and Optimization
Liangxu Linux
Liangxu Linux
Mar 24, 2023 · Operations

Mastering Rsync: From Basic Sync to Daemon and Real‑Time Inotify Integration

This guide explains what Rsync is, its underlying algorithm, key features, and provides step‑by‑step commands for local, LAN, and user‑specific synchronization, daemon configuration, testing scenarios, and how to combine Rsync with inotify‑tools for real‑time bidirectional file replication.

Backupcrondaemon
0 likes · 18 min read
Mastering Rsync: From Basic Sync to Daemon and Real‑Time Inotify Integration
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 16, 2023 · Databases

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
DaTaobao Tech
DaTaobao Tech
Feb 27, 2023 · Cloud Computing

Design of a Generic Backup and Disaster Recovery Solution

The proposed generic backup and disaster‑recovery framework introduces three business layers—backup data, DR retrieval, and dirty‑data cleanup—supporting both manual and scheduled backups, automatic or manual cleanup, pagination, bucketed delivery, sharding, and customizable filter chains to prevent large‑scale inconsistencies during failures.

BackupBucketarchitecture
0 likes · 7 min read
Design of a Generic Backup and Disaster Recovery Solution
dbaplus Community
dbaplus Community
Feb 14, 2023 · Databases

10 Common PostgreSQL Mistakes and How to Avoid Them

This article outlines the ten most frequent PostgreSQL pitfalls—from default configurations and poor schema design to inadequate backups and mismanaged extensions—providing concrete SQL queries, tuning tools, and best‑practice recommendations to help DBAs detect, diagnose, and prevent each issue before it harms production workloads.

BackupConnection PoolingDatabase Administration
0 likes · 16 min read
10 Common PostgreSQL Mistakes and How to Avoid Them
Liangxu Linux
Liangxu Linux
Feb 12, 2023 · Fundamentals

8 Common Mistakes to Avoid After Installing Linux

This guide outlines eight frequent pitfalls new Linux users should steer clear of—such as blindly copying commands, overusing root privileges, deleting system files, adding untrusted repositories, switching OSes too quickly, fearing the terminal, pushing Linux on others, and neglecting backups—to ensure a stable and secure system.

Backupbeginner guidebest practices
0 likes · 8 min read
8 Common Mistakes to Avoid After Installing Linux
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 17, 2023 · Databases

Understanding Redis Persistence: RDB and AOF Overview

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.

AOFBackupPersistence
0 likes · 10 min read
Understanding Redis Persistence: RDB and AOF Overview
Efficient Ops
Efficient Ops
Jan 9, 2023 · Operations

Boost Ops Efficiency: 5 Python Scripts Every Sysadmin Should Use

This article explains how Python can automate common operations tasks—remote command execution, log parsing, system monitoring with alerts, bulk software deployment, and backup/restore—providing code examples for each and highlighting additional tools that help sysadmins improve efficiency and reduce errors.

BackupDeploymentPython
0 likes · 9 min read
Boost Ops Efficiency: 5 Python Scripts Every Sysadmin Should Use
政采云技术
政采云技术
Dec 27, 2022 · Databases

Comprehensive Guide to MySQL Backup Types, Tools, and Procedures

This article provides an in‑depth overview of MySQL backup classifications—including hot, warm, and cold backups—explains physical versus logical backup methods, compares built‑in and third‑party tools such as mysqldump, mysqlhotcopy, LVM snapshots, XtraBackup, and presents step‑by‑step command examples for each approach.

BackupData RecoveryLVM
0 likes · 14 min read
Comprehensive Guide to MySQL Backup Types, Tools, and Procedures
Open Source Linux
Open Source Linux
Nov 14, 2022 · Operations

Essential Ops Checklist: From Safe Commands to Performance Tuning

This article shares practical operations guidelines covering safe command usage, backup strategies, security hardening, daily monitoring, performance tuning, and the right mindset to prevent data loss and ensure stable, secure Linux server management.

Backupbest practicesmonitoring
0 likes · 12 min read
Essential Ops Checklist: From Safe Commands to Performance Tuning
ITPUB
ITPUB
Nov 9, 2022 · Databases

Mastering Redis Persistence: RDB vs AOF Explained

This article provides a comprehensive guide to Redis persistence, covering the theory and configuration of both RDB snapshotting and AOF append‑only logging, their advantages, drawbacks, practical setup commands, recovery procedures, and performance‑tuning tips for reliable data durability.

AOFBackupConfiguration
0 likes · 16 min read
Mastering Redis Persistence: RDB vs AOF Explained
MaGe Linux Operations
MaGe Linux Operations
Nov 6, 2022 · Cloud Native

How to Safely Shut Down and Restart a Kubernetes Cluster

This guide walks you through the essential steps, commands, and precautions for safely draining nodes, backing up applications, CRDs, and etcd, then shutting down and later restarting a Kubernetes cluster while avoiding common pitfalls.

BackupCluster MaintenanceKubernetes
0 likes · 6 min read
How to Safely Shut Down and Restart a Kubernetes Cluster
Liangxu Linux
Liangxu Linux
Oct 2, 2022 · Operations

Essential Linux Ops Practices: Prevent Disasters and Boost Stability

Drawing from three and a half years of Linux operations, this guide outlines practical standards for testing, confirming commands, avoiding concurrent edits, mandatory backups, data safety, security hardening, continuous monitoring, performance tuning, and the right mindset to keep production environments stable and secure.

BackupOperationsbest practices
0 likes · 12 min read
Essential Linux Ops Practices: Prevent Disasters and Boost Stability
Top Architect
Top Architect
Sep 28, 2022 · Databases

Optimizing Large MySQL Tables: Slow‑Query Analysis, Index Tuning, and Efficient Deletion

This article details a comprehensive performance investigation of a massive MySQL table, using pt‑query‑digest to analyze slow queries, exposing index inefficiencies, proposing index redesign, demonstrating backup/restore with mydumper, comparing online DDL and pt‑osc for index rebuilding, and recommending small‑batch deletions to reduce latency and maintenance overhead.

BackupDDLIndex Optimization
0 likes · 15 min read
Optimizing Large MySQL Tables: Slow‑Query Analysis, Index Tuning, and Efficient Deletion
dbaplus Community
dbaplus Community
Aug 24, 2022 · Databases

Mastering SQL Server: Essential Commands, Advanced Queries, and Maintenance Techniques

This guide compiles fundamental SQL Server commands for creating, modifying, and deleting databases and tables, advanced query operators, join strategies, pagination, data synchronization, performance tuning, backup and restore procedures, and useful built‑in functions, providing a comprehensive reference for database professionals.

BackupReplicationSQL Commands
0 likes · 27 min read
Mastering SQL Server: Essential Commands, Advanced Queries, and Maintenance Techniques
Architects Research Society
Architects Research Society
Aug 22, 2022 · Operations

Backup Strategies: Full, Incremental, and Differential Backups

This article explains the three main backup methods—full, incremental, and differential—detailing their processes, advantages, disadvantages, and suitable use cases for organizations of different sizes, helping readers choose the most appropriate backup strategy for their business needs.

BackupData ProtectionFull Backup
0 likes · 7 min read
Backup Strategies: Full, Incremental, and Differential Backups
Top Architect
Top Architect
Aug 20, 2022 · Databases

Comprehensive SQL Server Cheat Sheet: Commands, Queries, and Administration Tips

An extensive collection of SQL Server commands, queries, and administrative procedures covering database creation, table manipulation, indexing, backup, security, replication, and performance tuning, presented with code examples and practical tips for developers and DBAs seeking a handy reference guide.

BackupDatabase AdministrationReplication
0 likes · 24 min read
Comprehensive SQL Server Cheat Sheet: Commands, Queries, and Administration Tips
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 16, 2022 · Databases

Resolving Xtrabackup Backup Failures Caused by Too Many Open Files in MySQL

This article explains why Percona Xtrabackup backups of MySQL 5.7 can fail with "Too many open files" errors, demonstrates how to reproduce the issue under both non‑root and root users, analyzes the open‑files‑limit settings, and provides practical solutions to adjust system and user limits for successful backups.

BackupDatabase Administrationlinux
0 likes · 12 min read
Resolving Xtrabackup Backup Failures Caused by Too Many Open Files in MySQL
Java Architect Essentials
Java Architect Essentials
Aug 3, 2022 · Databases

Comprehensive SQL Server Database Operations and Replication Guide

This article provides an extensive collection of SQL Server commands and techniques covering basic database creation, table manipulation, advanced queries, backup and maintenance, as well as detailed steps for setting up linked servers, snapshot replication, and synchronization procedures between servers.

BackupLinked ServerReplication
0 likes · 23 min read
Comprehensive SQL Server Database Operations and Replication Guide
Architecture Digest
Architecture Digest
Jul 27, 2022 · Databases

Comprehensive Guide to etcd: Overview, Architecture, Deployment, and Usage

This article provides a detailed introduction to etcd, covering its purpose as a highly‑available distributed key‑value store, core Raft‑based architecture, key concepts, common application scenarios, step‑by‑step installation and cluster deployment, as well as essential command‑line operations for managing data, backups, and cluster members.

BackupDeploymentKubernetes
0 likes · 26 min read
Comprehensive Guide to etcd: Overview, Architecture, Deployment, and Usage
dbaplus Community
dbaplus Community
Jul 3, 2022 · Databases

Master MySQL Clone Plugin: Installation, Usage, and Optimization

This guide explains MySQL 8.0.17's Clone Plugin—how to install it, perform local and remote clones, monitor progress via performance_schema, build replicas from cloned data, understand its internal stages, configure parameters, and compare it with XtraBackup.

BackupClone PluginDatabase Replication
0 likes · 19 min read
Master MySQL Clone Plugin: Installation, Usage, and Optimization
Open Source Linux
Open Source Linux
Jun 28, 2022 · Operations

Essential Ops Lessons: 22 Hard‑Earned Rules to Prevent Disasters

Drawing from three and a half years of DevOps experience, this guide compiles critical operational practices—ranging from cautious command execution and strict change control to robust backup, security hardening, continuous monitoring, performance tuning, and a disciplined mindset—to help engineers avoid costly outages and data loss.

BackupDevOpsOperational Best Practices
0 likes · 12 min read
Essential Ops Lessons: 22 Hard‑Earned Rules to Prevent Disasters
Efficient Ops
Efficient Ops
Jun 16, 2022 · Operations

Build an Ansible Custom Module to Backup MongoDB in Docker

An Ansible custom module was developed to back up MongoDB databases within a Docker container, including Dockerfile setup, Python handler code, parameter definitions, and a test playbook, with both successful and failure scenarios demonstrated, highlighting automation benefits for operations.

AnsibleAutomationBackup
0 likes · 10 min read
Build an Ansible Custom Module to Backup MongoDB in Docker
Efficient Ops
Efficient Ops
May 10, 2022 · Operations

How to Containerize Ansible for Automated MySQL Backups

This article demonstrates how to package Ansible in a Docker container, use the mysql_db module to create MySQL backups, and run a simple playbook, highlighting the benefits of containerized deployment for clean, flexible operations automation.

AnsibleAutomationBackup
0 likes · 10 min read
How to Containerize Ansible for Automated MySQL Backups
Practical DevOps Architecture
Practical DevOps Architecture
Apr 22, 2022 · Operations

GitLab Installation and Basic Configuration Guide on CentOS

This guide walks through installing GitLab on a CentOS server, configuring its external URL, setting up admin credentials, performing basic GitLab operations such as disabling auto‑registration, creating projects, configuring SSH keys, testing repository cloning, and configuring webhooks and backup management.

BackupConfigurationGitLab
0 likes · 4 min read
GitLab Installation and Basic Configuration Guide on CentOS
Open Source Linux
Open Source Linux
Apr 22, 2022 · Operations

Essential Bash Scripts for Linux Engineers: From Games to System Monitoring

This article compiles a collection of practical Bash scripts for Linux engineers, covering interactive games, network connection checks, process management, system monitoring, file operations, user account handling, and automated backups, each presented with clear explanations and ready-to-use code examples.

BackupBashShell scripting
0 likes · 23 min read
Essential Bash Scripts for Linux Engineers: From Games to System Monitoring
Liangxu Linux
Liangxu Linux
Apr 7, 2022 · Databases

Essential MySQL Interview Guide: Normal Forms, Permissions, ACID, Indexes & More

This comprehensive guide covers MySQL fundamentals including the three normal forms, permission tables, ACID properties, index design principles, SQL statement categories, sharding, deadlock resolution, isolation anomalies, view characteristics, SQL lifecycle, primary key choices, performance troubleshooting, replication, GTID, backup tools, and backup planning.

BackupDatabase designReplication
0 likes · 13 min read
Essential MySQL Interview Guide: Normal Forms, Permissions, ACID, Indexes & More
Architects' Tech Alliance
Architects' Tech Alliance
Apr 2, 2022 · Industry Insights

How Financial Institutions Secure Database Continuity: Disaster Recovery Strategies & Market Trends

This article examines the critical role of databases in finance, defines disaster recovery and backup concepts, outlines industry requirements and regulations, analyzes market growth, and compares distributed database disaster‑recovery architectures such as single‑center, city‑level mutual backup, active‑active, and two‑site three‑center solutions.

BackupDistributed SystemsFinancial Services
0 likes · 15 min read
How Financial Institutions Secure Database Continuity: Disaster Recovery Strategies & Market Trends
Java High-Performance Architecture
Java High-Performance Architecture
Mar 20, 2022 · Databases

Master MySQL Data Recovery: From Full Backups to Point‑in‑Time Restoration

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.

BackupBinlogFlashback
0 likes · 15 min read
Master MySQL Data Recovery: From Full Backups to Point‑in‑Time Restoration
Qingyun Technology Community
Qingyun Technology Community
Mar 4, 2022 · Cloud Native

How to Secure KubeSphere Virtualization with Kasten K10: A Step‑by‑Step Guide

This article walks through using Kasten K10 to protect the KubeSphere Virtualization (KSV) platform, covering environment setup, project and VM creation, K10 installation, backup policy configuration, and restoration of virtual machines with QingStor object storage, demonstrating a complete cloud‑native data protection workflow.

BackupKasten K10KubeSphere Virtualization
0 likes · 21 min read
How to Secure KubeSphere Virtualization with Kasten K10: A Step‑by‑Step Guide
Architect's Guide
Architect's Guide
Mar 2, 2022 · Databases

How to Perform Scheduled MySQL Backups Using mysqldump and Cron

This article explains various methods for scheduled MySQL backups, covering mysqldump command usage, example backup commands for whole or specific databases, a Bash script to retain a fixed number of backups, and configuring cron jobs to automate the backup and restoration processes.

BackupBashDatabase Administration
0 likes · 11 min read
How to Perform Scheduled MySQL Backups Using mysqldump and Cron
Dada Group Technology
Dada Group Technology
Feb 25, 2022 · Databases

Practical Deployment and Operation Guide for StarRocks OLAP Database

This article presents a comprehensive overview of StarRocks, covering its key features, deployment challenges, backup and synchronization methods, cluster configuration and upgrade procedures, as well as monitoring and alerting solutions, followed by practical lessons learned from real‑world usage.

BackupStarRocksmonitoring
0 likes · 13 min read
Practical Deployment and Operation Guide for StarRocks OLAP Database