BestHub
Sign in
Tagged articles

database operations

94 articles · Page 1 of 1
Su San Talks Tech
Su San Talks Tech
Aug 13, 2026 · Databases

How to Safely Add a Column to a Tens‑Million‑Row MySQL Table? 6 Proven Methods

Adding a column to a MySQL table with tens of millions of rows can lock the table for minutes or even hours, disrupting services, so this article evaluates six practical approaches—including native online DDL, offline maintenance, PT‑OSC, logical migration with dual‑write, gh‑ost, and partition sliding‑window—detailing their mechanisms, trade‑offs, and suitable scenarios.

MySQLOnline DDLdatabase operations
0 likes · 13 min read
How to Safely Add a Column to a Tens‑Million‑Row MySQL Table? 6 Proven Methods
liandk
liandk
Aug 8, 2026 · Databases

SQL for Absolute Beginners: Core Database Operations (Create, View, Delete)

This tutorial walks SQL newcomers through the three essential database commands—creating a database, listing all databases, switching to a specific one, and safely dropping a database—providing copy‑paste code, practical scenarios, and beginner‑focused pitfalls.

Database BasicsSQLSQL Server
0 likes · 3 min read
SQL for Absolute Beginners: Core Database Operations (Create, View, Delete)
Raymond Ops
Raymond Ops
Aug 1, 2026 · Databases

Essential MySQL Backup and Recovery Process Every Ops Engineer Must Master

This comprehensive guide walks MySQL administrators through the fundamentals of backup and recovery, covering RPO/RTO concepts, tool comparisons (mysqldump, mydumper, xtrabackup), step‑by‑step scripts for full, incremental, and binlog backups, encryption, compression, troubleshooting, and best‑practice monitoring to ensure data safety and rapid restoration.

MySQLRecoveryXtraBackup
0 likes · 35 min read
Essential MySQL Backup and Recovery Process Every Ops Engineer Must Master
21CTO
21CTO
May 14, 2026 · Databases

MySQL 9.7 LTS Launch: First Major Release Since 8.4 Brings Enterprise Features to the Community

Oracle announced MySQL 9.7.0 LTS, the first major LTS since 8.4, introducing community‑available enterprise features such as the Hypergraph optimizer, dynamic data masking, enhanced replication observability, and new operational tools, while addressing community concerns about Oracle’s commitment and recent development slowdown.

Dynamic data maskingHypergraph OptimizerLTS
0 likes · 8 min read
MySQL 9.7 LTS Launch: First Major Release Since 8.4 Brings Enterprise Features to the Community
Ops Community
Ops Community
Apr 22, 2026 · Databases

Is MySQL CPU Spike a Database Issue or an Application Issue? Troubleshooting Guide

When MySQL CPU usage spikes above 80% or hits 100%, this guide walks you through a systematic investigation—from confirming the MySQL process consumes CPU, checking system and MySQL status, analyzing connection counts, slow queries, lock waits, and configuration settings, to applying short‑term mitigations and long‑term architectural fixes.

CPUMySQLdatabase operations
0 likes · 17 min read
Is MySQL CPU Spike a Database Issue or an Application Issue? Troubleshooting Guide
Raymond Ops
Raymond Ops
Feb 8, 2026 · Operations

MySQL Ops Nightmares: Lessons from a 3 AM Production Crash

A seasoned DBA recounts a 3 AM MySQL outage caused by an unindexed query, then shares practical strategies for indexing, connection‑pool sizing, slow‑query tuning, replication lag handling, monitoring, automation, performance tuning, security hardening, and future‑proofing MySQL deployments.

MySQLdatabase operations
0 likes · 14 min read
MySQL Ops Nightmares: Lessons from a 3 AM Production Crash
ITPUB
ITPUB
Jan 11, 2026 · Databases

6 Proven Strategies to Add Columns to Billion‑Row MySQL Tables Without Downtime

This article examines why adding a column to a MySQL table with tens of millions of rows can lock the table, then presents six practical solutions—including native online DDL, PT‑OSC, gh‑ost, dual‑write migration, maintenance downtime, and partition sliding‑window—detailing their procedures, trade‑offs, and suitable scenarios.

MySQLOnline DDLdatabase operations
0 likes · 12 min read
6 Proven Strategies to Add Columns to Billion‑Row MySQL Tables Without Downtime
Xiao Liu Lab
Xiao Liu Lab
Dec 21, 2025 · Databases

Master MySQL for Ops: DML/DQL Tricks, Permissions & Transaction Pitfalls

This guide equips MySQL ops engineers with practical DML/DQL commands, permission management, transaction handling, and common pitfalls, offering step‑by‑step examples, performance tips and safety checklists to ensure reliable database maintenance and troubleshooting.

MySQLTransactionsdatabase operations
0 likes · 27 min read
Master MySQL for Ops: DML/DQL Tricks, Permissions & Transaction Pitfalls
dbaplus Community
dbaplus Community
Nov 17, 2025 · Databases

6 Proven Strategies to Safely Add Columns to Massive MySQL Tables

When adding a column to a MySQL table with tens of millions of rows, lock contention can cripple services, so this guide compares six practical solutions—including native online DDL, PT‑OSC, gh‑ost, partition sliding windows, downtime maintenance, and dual‑write migration—detailing their mechanisms, trade‑offs, use‑cases, and step‑by‑step commands to ensure minimal disruption.

MySQLOnline DDLdatabase operations
0 likes · 12 min read
6 Proven Strategies to Safely Add Columns to Massive MySQL Tables
Alibaba Cloud Developer
Alibaba Cloud Developer
Oct 22, 2025 · Artificial Intelligence

Why Human‑Designed Task Planning Beats Fully Autonomous AI Agents in Enterprise Databases

This article examines the architecture of AI agents, compares fully autonomous task planning with human‑crafted planning in Alibaba Cloud's RDS AI Assistant, presents real‑world accuracy data, and proposes a hybrid, case‑library‑driven approach to achieve reliable, explainable, and repeatable database operations.

AI Agentdatabase operationstask planning
0 likes · 18 min read
Why Human‑Designed Task Planning Beats Fully Autonomous AI Agents in Enterprise Databases
MaGe Linux Operations
MaGe Linux Operations
Sep 24, 2025 · Operations

How a 3 AM MySQL Crash Taught Me Essential Ops Lessons

This article recounts a 3 AM MySQL outage, analyzes its root causes, and shares comprehensive operational strategies—including index optimization, connection‑pool tuning, slow‑query fixing, replication lag handling, monitoring metrics, automation scripts, performance tuning, security hardening, and future trends—to help DBAs prevent and resolve similar incidents.

MySQLSecurityautomation
0 likes · 15 min read
How a 3 AM MySQL Crash Taught Me Essential Ops Lessons
Wukong Talks Architecture
Wukong Talks Architecture
Sep 22, 2025 · Databases

How AI‑Powered AIOps Transforms TiDB Database Operations

This article explores how integrating AI‑driven AIOps with the TiDB distributed database can automate monitoring, enable proactive anomaly detection, streamline root‑cause analysis, and optimize capacity planning, ultimately shifting database operations from manual firefighting to intelligent, data‑driven management.

AIOpsCapacity PlanningTiDB
0 likes · 12 min read
How AI‑Powered AIOps Transforms TiDB Database Operations
Alibaba Cloud Developer
Alibaba Cloud Developer
Jun 30, 2025 · Databases

How Large Language Models Can Revolutionize MySQL Operations

This guide explains how integrating large language models with MySQL can transform traditional database management by enabling intelligent fault diagnosis, automatic SQL optimization, knowledge‑base updates, and a complete monitoring‑optimization feedback loop, complete with implementation steps, code samples, and best‑practice recommendations.

MySQLdatabase operations
0 likes · 17 min read
How Large Language Models Can Revolutionize MySQL Operations
dbaplus Community
dbaplus Community
Feb 13, 2025 · Databases

Automating Redis Resource Balancing to Cut DBA Effort

To handle growing memory pressure across thousands of Redis servers, the platform implements an automated, daily resource‑balancing scheduler that selects overloaded hosts, chooses optimal nodes based on instance count, tier, and placement rules, then safely migrates them through a multi‑step process with rigorous validation.

RedisResource Balancingautomation
0 likes · 14 min read
Automating Redis Resource Balancing to Cut DBA Effort
Zhihu Tech Column
Zhihu Tech Column
Oct 28, 2024 · Databases

TiDB Architecture, Deployment Choices, and Zhihu’s Database Platform Practices

This article explains TiDB’s distributed relational database architecture, compares Kubernetes‑based and physical‑machine deployments, and describes Zhihu’s platform‑driven approach—including TiDB Operator, TiUP, self‑service tooling, monitoring, backup, security, and FinOps—to enable efficient database management for both developers and DBAs.

FinOpsKubernetesTiDB
0 likes · 15 min read
TiDB Architecture, Deployment Choices, and Zhihu’s Database Platform Practices
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 11, 2024 · Databases

ClickHouse Data Recovery Procedure for a Failed Disk in a 4‑Shard 3‑Replica Cluster

This article details a step‑by‑step recovery of a ClickHouse 4‑shard, 3‑replica cluster after a node’s disks failed, covering verification of residual data, Zookeeper metadata cleanup, table reconstruction, distributed table restoration, and validation of synchronization across replicas.

ZooKeeperdata recoverydatabase operations
0 likes · 8 min read
ClickHouse Data Recovery Procedure for a Failed Disk in a 4‑Shard 3‑Replica Cluster
Baidu Geek Talk
Baidu Geek Talk
Feb 7, 2024 · Artificial Intelligence

Design and Implementation of a Knowledge-Base Intelligent Q&A System for Database Operations Using Large Models

The paper details Baidu Intelligent Cloud’s design and deployment of a domain‑specific knowledge‑base Q&A system for database operations, combining prompt‑engineered LLMs with hybrid vector‑search using LangChain, BES vector store, and custom ingestion, addressing recall, token limits, and hallucination challenges across dashboard and IM bot interfaces.

AILangChaindatabase operations
0 likes · 16 min read
Design and Implementation of a Knowledge-Base Intelligent Q&A System for Database Operations Using Large Models
Code Ape Tech Column
Code Ape Tech Column
Jun 2, 2023 · Backend Development

Custom SQL Injector Guide for MyBatis-Plus: Built‑in and User‑Defined Injectors

This article explains what SQL injectors are in MyBatis‑Plus, lists the built‑in extended injectors, shows how to configure them globally, demonstrates custom mapper creation, provides complete code examples and test cases, and guides readers through building their own SQL injector for full‑field updates and batch operations.

Custom MapperJava backendMyBatis-Plus
0 likes · 9 min read
Custom SQL Injector Guide for MyBatis-Plus: Built‑in and User‑Defined Injectors
Efficient Ops
Efficient Ops
Mar 8, 2023 · Databases

Scaling Multi-Cloud Database Operations: Huolala’s Stability and Automation Playbook

The article details Huolala’s comprehensive approach to managing diverse databases across multiple clouds, covering systematic stability engineering, automated SQL governance, Redis and Kafka reliability strategies, cost‑optimization tactics, and the evolving roles of modern DBAs in a complex, high‑scale environment.

DBAMulti-CloudPerformance Optimization
0 likes · 16 min read
Scaling Multi-Cloud Database Operations: Huolala’s Stability and Automation Playbook
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 1, 2023 · Operations

Guide to Expanding an OceanBase Cluster: Adding Zones and Resources

This article provides a step‑by‑step guide for scaling an OceanBase cluster, covering both white‑screen and black‑screen methods to add zones (replicas) and resources (OBServers), including configuration file preparation, deployment commands, zone addition, verification queries, and procedures for both expansion and contraction.

OceanBaseSQLZone Expansion
0 likes · 12 min read
Guide to Expanding an OceanBase Cluster: Adding Zones and Resources
HomeTech
HomeTech
Feb 1, 2023 · Databases

TiDB Database Deployment and Operational Practices at AutoHome

This article presents a comprehensive case study of TiDB, an open‑source distributed relational database, detailing its features, architecture, evolution within AutoHome, key business applications such as recommendation pools, financial reporting, and interactive events, as well as the automated operations and troubleshooting practices adopted to ensure high availability and scalability.

AutohomeHTAPTiDB
0 likes · 6 min read
TiDB Database Deployment and Operational Practices at AutoHome
vivo Internet Technology
vivo Internet Technology
Nov 16, 2022 · Operations

Understanding and Mitigating Bigkey Issues in Redis Operations

Bigkeys—Redis values over 1 MB or structures with more than 2,000 elements—cause memory imbalance, command blocking, network overload, and migration failures, so DBAs must detect them using built‑in commands or RDB analysis, split or partition oversized keys, and tune migration settings to preserve performance and availability.

BigKeyPerformanceRedis
0 likes · 14 min read
Understanding and Mitigating Bigkey Issues in Redis Operations
ITPUB
ITPUB
Jun 24, 2022 · Databases

How to Build MySQL Master‑Master HA with Keepalived: A Step‑by‑Step Guide

This article walks through the complete process of creating a highly available MySQL master‑master cluster using Docker containers, MySQL replication, and Keepalived for automatic health checks, virtual IP failover, and seamless traffic switching, while also sharing common pitfalls and their solutions.

DockerLinuxMaster-Master Replication
0 likes · 24 min read
How to Build MySQL Master‑Master HA with Keepalived: A Step‑by‑Step Guide
ITPUB
ITPUB
Dec 20, 2021 · Databases

From Database Developer to New DBA: Boosting MySQL Efficiency and Automation

The article shares a senior DBA's journey from early database engine development to modern MySQL operations, outlining practical methods for improving efficiency, automating monitoring, building data‑driven processes, and redefining the DBA role for proactive, high‑impact service delivery.

DBAMySQLautomation
0 likes · 33 min read
From Database Developer to New DBA: Boosting MySQL Efficiency and Automation
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 16, 2021 · Databases

Resolving MySQL 8 Clone Plugin Restart Failures with Systemd Configuration

This article explains why MySQL 8's clone plugin may report a restart failure (error 3707), analyzes the role of the monitoring process, and provides systemd service configurations—including RestartForceExitStatus=16 and Environment=MYSQLD_PARENT_PID=1—to ensure automatic restarts succeed after clone operations while preventing unwanted restarts in other failure scenarios.

Clone PluginMySQLRestart Failure
0 likes · 5 min read
Resolving MySQL 8 Clone Plugin Restart Failures with Systemd Configuration
Architect's Tech Stack
Architect's Tech Stack
Apr 29, 2021 · Databases

Analyzing Redis Latency Issues and How to Diagnose Them

This article explains common causes of Redis latency spikes—including slow commands, large keys, concentrated expirations, memory limits, fork overhead, CPU binding, AOF settings, swap usage, and network saturation—and provides step‑by‑step diagnostic commands and practical mitigation techniques.

Redisdatabase operationslatency
0 likes · 18 min read
Analyzing Redis Latency Issues and How to Diagnose Them
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 18, 2021 · Databases

How to Build a Professional DBA Operations Team: Infrastructure, Standards, Training, Knowledge Base, and Culture

The article explains how to construct an effective DBA operations team by focusing on reusable infrastructure, clear team standards, a structured training system, a comprehensive knowledge base, and a positive team atmosphere, providing practical tools and methods for each aspect.

DBAInfrastructuredatabase operations
0 likes · 4 min read
How to Build a Professional DBA Operations Team: Infrastructure, Standards, Training, Knowledge Base, and Culture
Ctrip Technology
Ctrip Technology
Dec 24, 2020 · Databases

CTrip Redis Governance Evolution: Horizontal Scaling and Shrinking Solution

This article describes how CTrip tackled rapid Redis cluster growth by moving from vertical scaling to a containerized horizontal splitting approach, then introduced a binlog‑server based horizontal expansion and shrinkage method that reduces operation time, eliminates data migration, supports both scaling up and down, and improves resource utilization.

ContainerizationRedisdatabase operations
0 likes · 13 min read
CTrip Redis Governance Evolution: Horizontal Scaling and Shrinking Solution
Qunar Tech Salon
Qunar Tech Salon
Nov 24, 2020 · Databases

Analysis of Galera GTID vs MySQL GTID Issues During Percona XtraDB Cluster Split at Qunar

This article examines how differences between Galera GTID and MySQL GTID caused replication interruptions during a Percona XtraDB Cluster (PXC) split at Qunar, details the migration procedure, reproduces the problem with step‑by‑step commands, explains GTID concepts, and proposes operational improvements to avoid data inconsistency.

GTIDGaleraMySQL
0 likes · 17 min read
Analysis of Galera GTID vs MySQL GTID Issues During Percona XtraDB Cluster Split at Qunar
360 Tech Engineering
360 Tech Engineering
Aug 10, 2020 · Databases

TiDB Cluster Write‑Write Conflict Investigation and Resolution

This article analyzes a TiDB cluster performance incident where QPS dropped and duration spiked due to write‑write conflicts, detailing the monitoring data, root‑cause investigation of server‑busy and scheduler latch issues, and the attempted mitigation steps such as enabling txn‑local‑latches and adjusting insert statements.

Cluster troubleshootingPerformance MonitoringTiDB
0 likes · 10 min read
TiDB Cluster Write‑Write Conflict Investigation and Resolution
Architect's Alchemy Furnace
Architect's Alchemy Furnace
Jul 6, 2020 · Databases

Mastering MySQL HA: Step‑by‑Step MHA Setup and Failover Guide

This article walks through preparing a four‑node MySQL environment, configuring password‑less SSH, setting up master‑slave replication with GTID, installing and configuring MHA, testing connectivity, running the manager, verifying automatic failover, and highlighting the key advantages of using MHA for high availability.

GTIDMHAMySQL
0 likes · 24 min read
Mastering MySQL HA: Step‑by‑Step MHA Setup and Failover Guide
Ctrip Technology
Ctrip Technology
May 7, 2020 · Databases

CTrip's Redis Governance: Architecture, Scaling, and Hybrid Cloud Practices

This article details CTrip's evolution of Redis management—from early single‑instance deployments and custom CRedis client, through automated scaling, containerization with Kubernetes, secondary scheduling algorithms, Intel Optane integration, and hybrid‑cloud deployment—highlighting operational challenges, solutions, and performance outcomes.

ContainerizationKubernetesRedis
0 likes · 16 min read
CTrip's Redis Governance: Architecture, Scaling, and Hybrid Cloud Practices
dbaplus Community
dbaplus Community
Apr 20, 2020 · Operations

Preventing Database Disasters: Key Lessons from the Zhengda Hospital Outage

The Zhengda Hospital HIS database outage, caused by unauthorized scripts and poor permission controls, sparked a detailed discussion on how to prevent reckless production testing, enforce proper authorization, design efficient yet secure workflows, improve outsourcing oversight, and build robust emergency and compliance practices.

DevOpsPermission Managementcompliance
0 likes · 12 min read
Preventing Database Disasters: Key Lessons from the Zhengda Hospital Outage
dbaplus Community
dbaplus Community
Apr 6, 2020 · Databases

How AI‑Driven Intelligent Ops Transform Database Management in Banking

This article examines the severe time‑critical pain points of bank database operations, explains why AI‑based intelligent ops are needed, describes the platform architecture, unsupervised algorithms (3σ, Isolation Forest, DBSCAN, Pearson, Apriori), and presents a real‑world case study that demonstrates anomaly detection, root‑cause analysis, and practical optimization recommendations.

AIOpsContainerizationPython
0 likes · 23 min read
How AI‑Driven Intelligent Ops Transform Database Management in Banking
Efficient Ops
Efficient Ops
Feb 4, 2020 · Databases

How Multi‑Active Database Architecture Is Redefining Bank Disaster Recovery

In this interview, a senior database expert from Huaxia Bank shares twelve years of experience and explains how moving from traditional replication to multi‑active, real‑time consistent data centers, combined with automation and mobile remote operations, is transforming banking database reliability and security.

database operationsdisaster recoveryhigh availability
0 likes · 9 min read
How Multi‑Active Database Architecture Is Redefining Bank Disaster Recovery
iQIYI Technical Product Team
iQIYI Technical Product Team
Nov 15, 2019 · Databases

Database Selection Strategies and iQIYI's Implementation of MySQL, Redis, Couchbase, and HiKV

The article outlines practical database selection criteria—cost, stability, performance, scalability, security—and details iQIYI’s concrete implementations of MySQL, Redis, Couchbase, and the custom HiKV store, describing their architectures, backup and scaling mechanisms, operational tooling evolution, and a decision‑tree guide for matching workloads to the appropriate database technology.

CouchbaseHiKVMySQL
0 likes · 18 min read
Database Selection Strategies and iQIYI's Implementation of MySQL, Redis, Couchbase, and HiKV
58 Tech
58 Tech
Jul 8, 2019 · Databases

Design and Implementation of WMHA: A Modified MySQL High‑Availability Solution

This article explains the need for high‑availability MySQL services, critiques the original in‑house HA approach, and details how the mature MHA framework was extended into WMHA with added VIP monitoring, enhanced failover procedures, richer notifications, and a reorganized deployment structure to improve reliability and reduce DBA intervention.

MHAMySQLWMHA
0 likes · 9 min read
Design and Implementation of WMHA: A Modified MySQL High‑Availability Solution
Tencent Cloud Developer
Tencent Cloud Developer
May 16, 2019 · Operations

TDSQL Intelligent Operation Platform – Bianque Architecture and Practice

Bianque, TDSQL’s intelligent operation platform, automatically collects and indexes database metrics, applies a knowledge‑base‑driven analysis engine to diagnose availability, performance and reliability issues, issue risk warnings and optimization recommendations, dramatically cutting DBA effort and support tickets across Tencent’s cloud services.

Fault AnalysisPerformance MonitoringTDSQL
0 likes · 17 min read
TDSQL Intelligent Operation Platform – Bianque Architecture and Practice
NetEase Game Operations Platform
NetEase Game Operations Platform
Apr 4, 2019 · Databases

Deep Dive into mongos Connection Model and Adaptive Thread Pools in MongoDB

This article explains how MongoDB's mongos router manages client‑to‑mongos and mongos‑to‑mongod connections, compares the default per‑connection‑per‑thread model with the adaptive thread‑pool introduced in version 3.6, details the internal traditional and ASIO connection pools, relevant configuration parameters, and provides practical guidance on interpreting connection‑pool statistics.

MongoDBTaskExecutoradaptive thread pool
0 likes · 21 min read
Deep Dive into mongos Connection Model and Adaptive Thread Pools in MongoDB
Tencent Cloud Developer
Tencent Cloud Developer
Feb 27, 2019 · Operations

Operational Challenges and Strategies for Tencent Cloud Redis

Facing metadata inconsistency, ten‑thousand‑device scale, and the need for intelligent, event‑driven automation, Tencent Cloud Redis’s sole operations lead built a unified DB‑CMDB, a job‑platform for reusable workflows, and AI‑assisted scheduling, transforming DBAs into developer‑operators and driving 300% efficiency gains.

DevOpsRedisTencent Cloud
0 likes · 9 min read
Operational Challenges and Strategies for Tencent Cloud Redis
Youzan Coder
Youzan Coder
Jan 30, 2019 · Operations

Why Do MySQL RR Transactions Deadlock? A Deep Dive into Index Locking

This article examines two MySQL deadlock scenarios under REPEATABLE READ isolation—one with a non‑unique index and another with a unique index—by presenting table definitions, test data, raw deadlock logs, and step‑by‑step analysis of lock acquisition and waiting, ultimately offering practical recommendations to avoid such deadlocks.

InnoDBMySQLRR isolation
0 likes · 12 min read
Why Do MySQL RR Transactions Deadlock? A Deep Dive into Index Locking
dbaplus Community
dbaplus Community
Dec 18, 2018 · Operations

How a Chinese Telecom Built an Automated MySQL Management Platform

This article outlines the evolution from manual MySQL DBA tasks to a fully automated, platform‑based solution at China Mobile’s "Mobile Cloud", detailing standardization, tooling, Ansible‑driven deployment, platform architecture, and key features such as backup, inspection, user management, and SQL review.

MySQLPlatform Architectureansible
0 likes · 19 min read
How a Chinese Telecom Built an Automated MySQL Management Platform
Meituan Technology Team
Meituan Technology Team
Dec 13, 2018 · Databases

From Automation to Intelligent Database Operations: Meituan DBA Team’s Journey and Practices

Meituan’s DBA team progressed from simple scripting through tooling, productization, private‑cloud self‑service and full automation to an emerging intelligent‑operation model that leverages extensive data collection, risk‑driven pre‑warning, AI‑assisted analysis, and self‑healing mechanisms to meet rapid growth, stability and scalability demands.

DBAMeituanPlatform Evolution
0 likes · 14 min read
From Automation to Intelligent Database Operations: Meituan DBA Team’s Journey and Practices
21CTO
21CTO
Sep 28, 2018 · Databases

Mastering NoSQL at Scale: KV Architecture Evolution, Codis+, and Aerospike Insights

In the era of big data, DBAs face higher demands and NoSQL technologies have risen, so this article shares GeTui's KV storage architecture evolution, operational challenges, NoSQL selection criteria, Codis+ enhancements, Aerospike evaluation, monitoring practices, and best‑practice recommendations for scalable database operations.

AerospikeCodisNoSQL
0 likes · 16 min read
Mastering NoSQL at Scale: KV Architecture Evolution, Codis+, and Aerospike Insights
dbaplus Community
dbaplus Community
Sep 18, 2018 · Databases

How to Split a Percona XtraDB Cluster into Multiple Instances on a Single Node

This article details a real‑world engineering case where a Percona XtraDB Cluster (PXC) was re‑architected to run separate OP and CLM MySQL instances on the same physical server, covering background, problem analysis, design choices, port configuration, directory restructuring, configuration files, step‑by‑step commands, automation script updates, and post‑change verification.

HAProxyInstance SplittingMySQL
0 likes · 14 min read
How to Split a Percona XtraDB Cluster into Multiple Instances on a Single Node
dbaplus Community
dbaplus Community
Sep 16, 2018 · Databases

How Meituan Dianping Built a Reliable MySQL Group Replication HA Architecture

This article details Meituan Dianping's practical experience deploying MySQL Group Replication (MGR) for CMDB high availability, covering background, MGR fundamentals, configuration limits, parameter tuning, architecture design, deployment timeline, typical issues, a custom Python client, and daily operational practices.

Group ReplicationMGRMySQL
0 likes · 11 min read
How Meituan Dianping Built a Reliable MySQL Group Replication HA Architecture
Efficient Ops
Efficient Ops
Jul 9, 2018 · Databases

How YY Scaled Its Database Platform: From Manual Ops to Intelligent Automation

This article details YY's journey in transforming its database operations—from early quality and efficiency challenges to a multi‑stage platform that automates resource pooling, high‑availability proxy, cost control, quality monitoring, and security, outlining future intelligent extensions.

Cost OptimizationSecuritydatabase operations
0 likes · 16 min read
How YY Scaled Its Database Platform: From Manual Ops to Intelligent Automation
dbaplus Community
dbaplus Community
May 1, 2018 · Operations

How to Achieve Zero‑Fault Database Operations: Real‑World Cases and Management Practices

This article shares practical experiences from a DBAplus Guangzhou tech salon, detailing three real Oracle database incident cases, the root‑cause analyses, and a three‑step framework for rapid resolution, prevention, and team management to maintain zero‑fault operations across thousands of database instances.

OracleTeam Practiceschange management
0 likes · 22 min read
How to Achieve Zero‑Fault Database Operations: Real‑World Cases and Management Practices
ITPUB
ITPUB
Sep 23, 2017 · Databases

Essential DBA Checklist: Avoid Common MySQL Mistakes and Boost Reliability

This guide shares a seasoned DBA's practical checklist covering environment awareness, hardware considerations, runtime monitoring, data security, routine operations, fault‑prevention plans, architecture insights, and the right mindset to help database professionals reduce errors and improve system stability.

DBAMySQLdata security
0 likes · 19 min read
Essential DBA Checklist: Avoid Common MySQL Mistakes and Boost Reliability
Efficient Ops
Efficient Ops
Aug 10, 2017 · Operations

Avoid Costly DBA Mistakes: Essential MySQL Operations and Best Practices

This comprehensive guide shares a senior DBA's hard‑learned lessons on MySQL environment setup, data security, routine operations, architecture insights, online execution tips, and the right mindset, helping database professionals prevent common pitfalls and improve reliability.

DBAMySQLdatabase operations
0 likes · 19 min read
Avoid Costly DBA Mistakes: Essential MySQL Operations and Best Practices
Efficient Ops
Efficient Ops
Jan 19, 2017 · Databases

What Really Caused Blizzard’s Hearthstone Outage? Inside Oracle RAC Failure

An in‑depth look at Blizzard’s Hearthstone outage reveals that a power interruption likely triggered storage failures in an Oracle RAC cluster, leading to corrupted blocks, incomplete recovery, and a reliance on backups, while highlighting broader lessons on database backup, disaster recovery, and operational decision‑making.

OracleRACdatabase operations
0 likes · 13 min read
What Really Caused Blizzard’s Hearthstone Outage? Inside Oracle RAC Failure
Efficient Ops
Efficient Ops
Jan 17, 2017 · Databases

Inside WeChat Pay: Scaling MySQL for Millions of Payments per Second

Zhou Tang, head of WeChat Pay operations at Tencent, shares how his team built a massive MySQL‑based payment platform handling up to 150 k transactions per second, covering background, DB‑CMDB design, change management, monitoring, security, high availability, and why Golang became their core development language.

MySQLWeChat Paydatabase operations
0 likes · 21 min read
Inside WeChat Pay: Scaling MySQL for Millions of Payments per Second
dbaplus Community
dbaplus Community
Dec 26, 2016 · Databases

How to Build a Scalable, Automated MySQL Operations Platform

This article explains how to standardize and automate MySQL management at scale, covering dedicated instance deployment, configuration consistency, multi‑instance creation, metadata collection, backup, monitoring, high‑availability with Zookeeper, and task orchestration using DBTask to achieve rapid, reliable database services.

DBTaskMySQLZooKeeper
0 likes · 12 min read
How to Build a Scalable, Automated MySQL Operations Platform
Weidian Tech Team
Weidian Tech Team
Dec 15, 2016 · Databases

How to Build a Scalable Automated MySQL Operations Platform

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.

MySQLbackupdatabase operations
0 likes · 11 min read
How to Build a Scalable Automated MySQL Operations Platform
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Nov 17, 2016 · Operations

Why Large Redis Instances Cause Disasters and How to Prevent Them

This article examines the operational challenges of oversized Redis instances—including slow failover, prolonged slave resynchronization, network‑induced avalanches, and persistence blocking—and offers practical mitigation strategies such as key expiration, data compression, and using high‑performance alternatives like Pika.

Performance OptimizationPikaRedis
0 likes · 9 min read
Why Large Redis Instances Cause Disasters and How to Prevent Them
Practical DevOps Architecture
Practical DevOps Architecture
Jul 1, 2016 · Databases

SQL Data Import/Export and Table Operations Tutorial

This tutorial demonstrates how to create a MySQL database and table, import data from /etc/passwd, add an auto‑increment primary key, export selected records to a file, and perform common SQL queries, conditions, and table‑record manipulations such as insert, update, and delete.

Data ExportMySQLSQL
0 likes · 10 min read
SQL Data Import/Export and Table Operations Tutorial
21CTO
21CTO
Apr 11, 2016 · Databases

How JD Scaled MySQL: Evolution, Automation, and Ops Insights

This article chronicles JD.com's transition from commercial to open‑source databases, detailing MySQL's rapid growth, the development of the JMySQL automation platform, and future directions for database design, security, monitoring, and performance optimization in large‑scale e‑commerce environments.

Database AutomationJD.comMySQL
0 likes · 15 min read
How JD Scaled MySQL: Evolution, Automation, and Ops Insights
Qunar Tech Salon
Qunar Tech Salon
Mar 26, 2016 · Databases

MySQL User Management, Database and Table Operations Guide

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.

MySQLQueriesRestore
0 likes · 14 min read
MySQL User Management, Database and Table Operations Guide
Efficient Ops
Efficient Ops
Aug 31, 2015 · Databases

Why SQL Server Excels in Operations: Expert Insights on Strategy, Tools, and Challenges

During a lively Q&A session organized by the ‘Efficient Operations’ community, Oracle InnoDB principal developer Lai Zheng and Microsoft SQL Server product manager Lin Mo discuss SQL Server’s operational advantages over other databases, Microsoft’s product roadmap, common maintenance challenges, and the ideal career path for a modern DBA.

DBAMicrosoftOracle
0 likes · 10 min read
Why SQL Server Excels in Operations: Expert Insights on Strategy, Tools, and Challenges