BestHub
Sign in
Tagged articles
28 articles
Page 1 of 1
Ray's Galactic Tech
Ray's Galactic Tech
Apr 4, 2026 · Backend Development

How to Turn go-zero’s DB Automation into Production‑Ready CRUD

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.

BackendCode GenerationGolang
0 likes · 29 min read
How to Turn go-zero’s DB Automation into Production‑Ready CRUD
Code Ape Tech Column
Code Ape Tech Column
Jan 12, 2024 · Databases

MySQL Event Scheduler: Concepts, Operations, and Practical Examples

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 GenerationEvent SchedulerSQL
0 likes · 9 min read
MySQL Event Scheduler: Concepts, Operations, and Practical Examples
ITPUB
ITPUB
Apr 5, 2023 · Operations

Automating TiDB Operations: From Manual Pain Points to a Scalable Platform

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.

AlertingCluster ManagementTiDB
0 likes · 22 min read
Automating TiDB Operations: From Manual Pain Points to a Scalable Platform
Qunar Tech Salon
Qunar Tech Salon
Nov 2, 2022 · Databases

Design of a Next‑Generation Qunar Database Automation Platform: Architecture, Communication Protocol, and Security

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 CommunicationGoSecurity Protocol
0 likes · 9 min read
Design of a Next‑Generation Qunar Database Automation Platform: Architecture, Communication Protocol, and Security
Liangxu Linux
Liangxu Linux
Jul 19, 2022 · Databases

Master MySQL Stored Procedures, Events, and Triggers for Automated Data Workflows

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.

Event SchedulerSQLStored Procedure
0 likes · 11 min read
Master MySQL Stored Procedures, Events, and Triggers for Automated Data Workflows
ITPUB
ITPUB
Feb 3, 2021 · Artificial Intelligence

Can GPT‑3 Write Complex SQL Queries? A Hands‑On Exploration

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 codeGPT-3Prompt engineering
0 likes · 7 min read
Can GPT‑3 Write Complex SQL Queries? A Hands‑On Exploration
Qunar Tech Salon
Qunar Tech Salon
Nov 19, 2020 · Databases

Automated Migration Platform for Qunar DBA: Architecture, Implementation, and Outcomes

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 toolsPythonSaltStack
0 likes · 10 min read
Automated Migration Platform for Qunar DBA: Architecture, Implementation, and Outcomes
Efficient Ops
Efficient Ops
Mar 6, 2019 · Databases

How NetEase Built an Automated DBA Platform with AIOps for Massive Scale

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.

OperationsScalabilityaiops
0 likes · 20 min read
How NetEase Built an Automated DBA Platform with AIOps for Massive Scale
58 Tech
58 Tech
Jan 17, 2019 · Databases

Insights from the 58 Group Technical Salon: Database Operations Platform Construction and Practices

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.

DB OperationsPerformance MonitoringSelf-Service Platform
0 likes · 14 min read
Insights from the 58 Group Technical Salon: Database Operations Platform Construction and Practices
dbaplus Community
dbaplus Community
Sep 10, 2018 · Operations

Scaling MySQL Management with a Fully Automated DBA Platform

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.

DBAPythondatabase automation
0 likes · 13 min read
Scaling MySQL Management with a Fully Automated DBA Platform
JD Retail Technology
JD Retail Technology
Aug 27, 2018 · Databases

JD.com's Database Automation and ContainerDB: Evolution of Intelligent Database Management

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.

ContainerDBIntelligent DiagnosticsMySQL Management
0 likes · 22 min read
JD.com's Database Automation and ContainerDB: Evolution of Intelligent Database Management
dbaplus Community
dbaplus Community
Aug 26, 2018 · Databases

Inside JD.com’s Intelligent Database Automation Platform: Architecture, Features, and Future Roadmap

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.

ContainerDBIntelligent Operationsaiops
0 likes · 25 min read
Inside JD.com’s Intelligent Database Automation Platform: Architecture, Features, and Future Roadmap
Youzan Coder
Youzan Coder
Apr 20, 2018 · Databases

ZanDB: An Automated Database Management Platform for Large-Scale Operations

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 ManagementZanDBdatabase automation
0 likes · 14 min read
ZanDB: An Automated Database Management Platform for Large-Scale Operations
ITPUB
ITPUB
Apr 19, 2018 · Databases

How Didi Scales MySQL: From Manual Ops to Full 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%.

DBADidiOperations
0 likes · 14 min read
How Didi Scales MySQL: From Manual Ops to Full Automation
Meituan Technology Team
Meituan Technology Team
Apr 14, 2017 · Operations

Meituan Dianping's Automation Concepts and Practices

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.

DevOpsMeituanOperations Automation
0 likes · 4 min read
Meituan Dianping's Automation Concepts and Practices
Meituan Technology Team
Meituan Technology Team
Sep 23, 2016 · Databases

Database Automation Platform at Meituan: Architecture, Practices, and Lessons

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.

CMDBDevOpsdatabase automation
0 likes · 27 min read
Database Automation Platform at Meituan: Architecture, Practices, and Lessons
Qunar Tech Salon
Qunar Tech Salon
Sep 8, 2016 · Databases

Design Principles and Implementation of Inception – A MySQL SQL Review and Automation Tool

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.

Backup and rollbackInceptionSQL Review
0 likes · 5 min read
Design Principles and Implementation of Inception – A MySQL SQL Review and Automation Tool
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 operationsJD.comdatabase automation
0 likes · 15 min read
How JD Scaled MySQL: Evolution, Automation, and Ops Insights
Efficient Ops
Efficient Ops
Mar 2, 2016 · Databases

How DBMP Automates MySQL Management and Cuts DBA Workload

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.

Backupdatabase automationfailover
0 likes · 14 min read
How DBMP Automates MySQL Management and Cuts DBA Workload