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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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%.
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.
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.
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.
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.
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.
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.
