This article introduces a collection of practical open‑source utilities—including SQLTXPLAIN, SOAR, SQLAdvisor, and Percona Toolkit tools—that streamline common MySQL DBA tasks such as schema changes, replication checks, slow‑query analysis, and data consistency verification, helping engineers work faster and more efficiently.
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.
This article describes how a DBA team introduced the open‑source Inception tool and built a custom web UI called Overmind to automate MySQL SQL auditing, streamline dev/QA workflows, and safely manage production deployments with email‑based DBA approvals.
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.
This article explains why protecting database systems is critical, reviews existing SQL‑analysis tools, and dives deep into MySQL's lexical and syntax parsing techniques—including Bison‑generated parsers, core data structures, and practical applications such as useless‑condition removal and SQL feature generation—to help DBAs automate and optimize their workflows.
gh‑ost is a lightweight, trigger‑free, Go‑based online MySQL schema‑change tool that reads binary logs, applies alterations to temporary tables, and offers pauseable, auditable, and dynamically controllable migrations via socket commands, supporting master‑only, replica‑assisted, or replica‑testing modes and used extensively at GitHub.
This article details the challenges of large‑scale database operations, the selection and design of a custom audit platform, its architecture, data collection, rule parsing, implementation, results, and lessons learned, while sharing the open‑source repository for the system.
OrzDBA, a Perl‑based monitoring script from Taobao's DBA team, provides real‑time insight into Linux system metrics and MySQL performance indicators, offering commands to view load, CPU, swap, disk I/O, network traffic, and detailed MySQL statistics.
A practical guide introduces nine free Oracle DBA utilities—including OS Watcher, oratop, ora, SQL Developer, AWR/ASH/ADDM, ORAchk, RDA, RMAN, and OEM CC—detailing their installation, usage, and key features for effective database monitoring and maintenance.
