Tag

DBA tools

1 views collected around this technical thread.

Efficient Ops
Efficient Ops
Jul 10, 2024 · Databases

Boost MySQL DBA Productivity with Essential Open‑Source Tools

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.

DBA toolsMySQLPercona Toolkit
0 likes · 8 min read
Boost MySQL DBA Productivity with Essential Open‑Source Tools
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.

CeleryDBA toolsDatabase Automation
0 likes · 10 min read
Automated Migration Platform for Qunar DBA: Architecture, Implementation, and Outcomes
Efficient Ops
Efficient Ops
Sep 6, 2018 · Databases

Automating MySQL SQL Audits with Inception and Overmind

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.

DBA toolsInceptionMySQL
0 likes · 6 min read
Automating MySQL SQL Audits with Inception and Overmind
Qunar Tech Salon
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
Tencent Cloud Developer
Tencent Cloud Developer
Mar 23, 2018 · Databases

Using gh-ost for Online MySQL Schema Changes: Features, Modes, and Practical Tips

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.

DBA toolsMySQLOnline Schema Change
0 likes · 17 min read
Using gh-ost for Online MySQL Schema Changes: Features, Modes, and Practical Tips