BestHub
search
Sign in
Tag

OnlineDDL

0 views collected around this technical thread.

Zhuanzhuan Tech
Zhuanzhuan Tech
Feb 28, 2024 · Databases

Evolution of ZzoNlineDDL: From 1.0 to 2.0 – Architecture, Features, and Lessons Learned

This article chronicles the development of ZzoNlineDDL's schema‑change platform from its early 1.0 version with limited capabilities to the robust 2.0 release, detailing architectural diagrams, intelligent alteration logic, partitioning, scheduling, monitoring, user interaction, problem analysis, and practical recommendations for MySQL online DDL operations.

DatabaseOperationsMySQLOnlineDDL
0 likes · 35 min read
Evolution of ZzoNlineDDL: From 1.0 to 2.0 – Architecture, Features, and Lessons Learned
Aikesheng Open Source Community
Aikesheng Open Source Community
May 6, 2021 · Databases

Designing an Online DDL Work Order System for MySQL

This article examines the pain points of MySQL DDL operations for large tables, analyzes the limitations of online DDL, compares tools like gh‑ost and pt‑osc, and outlines a comprehensive workflow and implementation details for an automated online DDL work‑order system.

DDLDatabase AdministrationMySQL
0 likes · 9 min read
Designing an Online DDL Work Order System for MySQL
Architecture Digest
Architecture Digest
Jan 21, 2018 · Databases

Common MySQL Concurrency Issues: Table Locks, Metadata Locks, Deadlocks, and Lock Waits

This article examines typical MySQL concurrency problems—including table lock‑induced slow queries, metadata lock blocking during online schema changes, deadlock scenarios, and lock‑wait timeouts—provides step‑by‑step reproductions, analysis of lock behavior, and practical mitigation strategies such as using InnoDB, online DDL tools, and monitoring techniques.

ConcurrencyInnoDBLocks
0 likes · 15 min read
Common MySQL Concurrency Issues: Table Locks, Metadata Locks, Deadlocks, and Lock Waits