Database Automation

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 GenerationDatabase AutomationEvent Scheduler

0 likes · 9 min read

MySQL Event Scheduler: Concepts, Operations, and Practical Examples

Selected Java Interview Questions

Jan 6, 2024 · Databases

MySQL Event Scheduler: Concepts, Operations, and Practical Examples

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

DevOps Cloud Academy

Dec 1, 2022 · Databases

Integrating Bytebase SQL Review into GitHub and GitLab CI/CD Pipelines

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

Integrating Bytebase SQL Review into GitHub and GitLab CI/CD Pipelines

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 CommunicationDatabase AutomationEncryption

0 likes · 9 min read

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

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.

CeleryDBA toolsDatabase Automation

0 likes · 10 min read

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

Aikesheng Open Source Community

Apr 17, 2020 · Operations

Exploring Database Operations Automation at Tiancheng Financial – Interview with Senior DBA Ge Haoqiang

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

Exploring Database Operations Automation at Tiancheng Financial – Interview with Senior DBA Ge Haoqiang

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.

AIOpsDBADatabase Automation

0 likes · 20 min read

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

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.

Cloud DatabaseDB OperationsDatabase Automation

0 likes · 14 min read

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

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.

Backup and RecoveryContainerDBDatabase Automation

0 likes · 22 min read

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

Qunar Tech Salon

Aug 24, 2018 · Databases

Building an Automated Database Operations Platform: From Monitoring to Multi‑Active Deployment

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

Building an Automated Database Operations Platform: From Monitoring to Multi‑Active Deployment

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 ManagementDatabase AutomationHigh Availability

0 likes · 14 min read

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

360 Zhihui Cloud Developer

Jul 25, 2017 · Databases

How HULK Private Cloud Automates MySQL: Architecture, Scaling, and Recovery

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.

BackupDatabase AutomationHigh Availability

0 likes · 18 min read

How HULK Private Cloud Automates MySQL: Architecture, Scaling, and Recovery

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 rollbackDatabase AutomationInception

0 likes · 5 min read

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

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