Tagged articles
Database Automation
30 articles · Page 1 of 1

liandkAug 25, 2026 · Databases
This concluding tutorial walks beginners through SQL Server stored procedures, highlighting their speed, reusability, and automation advantages over single statements and views, and demonstrates creating, invoking (with and without parameters), altering, and dropping procedures while sharing naming conventions and common pitfalls.
Database AutomationSQLSQL Server
0 likes · 6 min read

The article shows how AI can replace tedious manual MySQL commands with generated scripts, walks through setting up a Docker Compose MySQL environment, demonstrates AI‑written SQL, performance tuning, backup automation, and highlights version‑specific pitfalls.
AI-assisted SQLBackup ScriptsDatabase Automation
0 likes · 10 min read

This guide explains why go-zero’s database automation is an engineering standard rather than a shortcut, outlines the problems it solves for large Go back‑ends, details the generation pipeline, shows how to integrate caching, and provides production‑grade practices such as custom queries, transactions, high‑concurrency tuning, testing, and deployment for an e‑commerce order service.
BackendDatabase Automationcode generation
0 likes · 29 min read

This article presents a step‑by‑step demonstration of using the OpenClaw AI agent to deploy a minimal TiDB v8.5.5 cluster, modify root and create a dbadmin user, run sysbench/TPCC performance tests, and evaluate the feasibility of AI‑driven production‑grade database operations.
AI agentDatabase AutomationOpenClaw
0 likes · 11 min read

This guide walks you through quickly integrating Moltbot with Alibaba Cloud RDS AI to build an AI‑driven database operations assistant, covering why the combo matters, required preparations, step‑by‑step skill configuration, credential setup, verification commands, and practical usage scenarios.
AI OpsDatabase AutomationDevOps
0 likes · 6 min read

This article explains MySQL event scheduler fundamentals, including enabling/disabling the scheduler, creating, altering, and dropping events, scheduling syntax, and practical examples such as generating real-time sales data and periodic statistics, providing code snippets and best‑practice guidance for database automation.
Data GenerationDatabase AutomationEvent Scheduler
0 likes · 9 min read

This article explains MySQL event scheduler fundamentals, its advantages, common commands for managing events, detailed syntax for creating events, and provides practical examples such as generating real‑time sales data and scheduled statistics, helping developers automate repetitive database tasks.
Data GenerationDatabase AutomationEvent Scheduler
0 likes · 10 min read


ITPUBApr 5, 2023 · Operations
This article details how Zhaozhuan's DBA team transformed TiDB cluster management by addressing metadata, resource allocation, upgrade, and alert challenges through a comprehensive automation platform that streamlines work orders, node operations, scaling, monitoring, and alert handling, ultimately reducing manual effort and improving reliability.
Database AutomationTiDBalerting
0 likes · 22 min read

This article provides a step‑by‑step guide to seamlessly integrate Bytebase’s SQL review feature into GitHub and GitLab CI/CD pipelines, covering prerequisite setup, configuring the SQL review CI, and verifying automatic SQL script checks on merge requests.
BytebaseCI/CDDatabase Automation
0 likes · 4 min read

This article describes the layered architecture of Qunar's next‑generation database automation platform, outlines the design goals for secure Agent/Plugin‑Server communication, compares communication and encryption methods, and details the authentication and request flow using symmetric encryption and token‑based security.
Agent-Server CommunicationDatabase AutomationGo
0 likes · 9 min read

This guide explains how to use MySQL stored procedures, events (timers), and triggers—including their creation, variable handling, control structures, parameter passing, loops, scheduling options, and practical examples—to automate reporting, data monitoring, and business logic directly at the database layer.
Database AutomationEvent SchedulerMySQL
0 likes · 11 min read

This article introduces ZTO Technology’s Ark Platform, a database PaaS solution that automates deployment, backup, monitoring, data flashback, and slow‑SQL optimization, detailing its architecture, core features, and the operational benefits it brings to large‑scale logistics environments.
Database AutomationPaaSPython
0 likes · 9 min read


ITPUBFeb 3, 2021 · Artificial Intelligence
This article demonstrates how GPT‑3 can translate plain‑English questions into SQL statements, starting with simple counts and progressing to multi‑table joins, while highlighting prompting techniques, limitations, and the impact of model variants such as GPT‑3 Instruct.
AI-generated codeDatabase AutomationGPT-3
0 likes · 7 min read

This article describes Qunar's DBA department automated migration platform, detailing its motivation, overall architecture, task pool and templates, customizable web‑based workflow, scheduling, execution queue, tooling, and the significant efficiency and reliability gains achieved across numerous database migration scenarios.
DBA toolsDatabase AutomationPython
0 likes · 10 min read

In this interview, senior DBA Ge Haoqiang from Tiancheng Financial discusses the scale of their database clusters, the efficiency gains from automation, DevOps culture, language choices, and how they adapt to new database features, offering insights into modern database operations automation.
DBADatabase AutomationDevOps
0 likes · 6 min read

A major bank transformed its legacy vendor‑managed .NET/Oracle applications by automating data‑patch deployments through Git, Jenkins, and custom database tools, enabling weekday releases, reducing manual effort, cutting overtime, and achieving continuous delivery despite outdated systems.
Continuous DeliveryDatabase AutomationDevOps
0 likes · 9 min read

This article details NetEase's journey in designing and implementing a large‑scale database automation platform, covering its requirements, tool‑based operations, architecture, AIOps integration, and the practical lessons learned for managing thousands of database clusters efficiently.
AIOpsDatabase AutomationOperations
0 likes · 20 min read

The article summarizes the 58 Group technical salon where experts from Tujia.com, Kingsoft Cloud, and 58 Group shared their experiences on building block‑based database automation systems, cloud database architectures, high‑availability designs, self‑service platforms, and intelligent operation practices for large‑scale database services.
Cloud DatabaseDB OperationsDatabase Automation
0 likes · 14 min read

This article details how a DBA team built a standardized, automated MySQL/Redis management platform—covering OS and DB standardization, deployment scripts, a three‑layer web‑task‑module architecture, RESTful APIs, and modular design—to enable a handful of DBAs to manage thousands of instances efficiently.
DBADatabase AutomationMySQL
0 likes · 13 min read

This article details JD.com's database automation journey, covering their intelligent database management platform (DBS), automated deployment systems, intelligent analysis and diagnostics, and the evolution from traditional containerization to ContainerDB, a smart database service with elastic scheduling and resource optimization.
ContainerDBDatabase AutomationDatabase High Availability
0 likes · 22 min read

This article details JD.com’s database team’s evolution from manual operations to a fully automated, AI‑driven platform—covering metadata management, automated deployment, intelligent analysis, auto‑switching, backup & recovery, and the ContainerDB elastic scheduling system that powers future smart, fast, and cost‑effective database services.
AIOpsContainerDBDatabase Automation
0 likes · 25 min read

The article describes how a DBA team at Ele.me transformed manual database management into a fully automated, platform‑driven operation covering monitoring, alarm handling, MHA automation, resource pooling, large‑scale migration, SQL review, and multi‑active DDL release using Go‑based tools and custom workflows.
DBA toolsDatabase AutomationGo
0 likes · 20 min read

ZanDB is Youzan’s automated database‑management platform that standardizes OS and MySQL configurations, employs a Python/Django stack with a Go‑based agent and Celery scheduler, and provides unified modules for backup, host, instance, metadata, log and HA management, currently automating about 70 % of manual operations while targeting full‑scale monitoring, diagnostics and sharding automation.
Backup ManagementDatabase AutomationHigh Availability
0 likes · 14 min read


ITPUBApr 19, 2018 · Databases
This article outlines Didi's MySQL database architecture, the challenges of managing thousands of instances, and the step‑by‑step automation framework—including dbproxy, high‑availability, backup, monitoring, and deployment modules—that reduces manual DBA work by over 70%.
DBADatabase AutomationDidi
0 likes · 14 min read

This article details the design, automation, high‑availability architecture, backup strategy, and operational workflow of the HULK private‑cloud MySQL service, covering instance provisioning, table management, testing environments, optimization tips, data recovery, and future plans.
Database AutomationMySQLbackup
0 likes · 18 min read

Meituan Dianping’s technical salon showcased its automation journey—detailing database automation platforms, service‑tree management, Puppet‑based web control, and a CMDB case study from Shanghai Zhaogang—highlighting rapid iteration, standardization challenges, and the evolution of automation from tools to core operational practice.
Database AutomationDevOpsMeituan
0 likes · 4 min read

Meituan’s Database Automation Platform evolved from a simple Django‑based 1.0 system into a modular 2.0 architecture using CMDB, RabbitMQ, and Celery, standardizing metadata, providing self‑service APIs, and automating tasks such as cluster provisioning, online schema changes, and high‑availability failover, now handling hundreds of daily operations for over a thousand developers while planning further component‑library refactoring.
CMDBDatabase AutomationDevOps
0 likes · 27 min read

The article explains the design motivations, architectural choices, and implementation details of Inception, a MySQL‑compatible SQL review and execution platform that follows programmers' habits, prevents common human errors, fully supports MySQL syntax, and integrates audit, backup, and rollback capabilities.
Database AutomationInceptionMySQL
0 likes · 5 min read


21CTOApr 11, 2016 · Databases
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

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.
Database AutomationFailoverMySQL
0 likes · 14 min read
