Tagged articles

Distributed DDL

2 articles · Page 1 of 1

Dec 8, 2022 · Databases

Understanding ClickHouse Distributed DDL Execution: Cases, Principles, and Mitigation Guide

This article analyzes ClickHouse distributed DDL execution by presenting typical failure scenarios, dissecting the underlying Zookeeper‑based workflow, and offering practical mitigation steps to avoid DDL timeouts and improve cluster stability for large‑scale data operations.

Big DataClickHouseDatabase operations

0 likes · 12 min read

Understanding ClickHouse Distributed DDL Execution: Cases, Principles, and Mitigation Guide

Aikesheng Open Source Community

May 5, 2022 · Databases

Resolving Stuck Distributed DDL in ClickHouse: Diagnosis and Workaround

An online ClickHouse 10-node cluster experienced a distributed DDL task that hung for over 100 hours, blocking subsequent operations; the article explains the FIFO execution model, diagnosis steps, and a workaround using table renaming to unblock the queue, recommending version upgrade.

ClickHouseDatabase TroubleshootingDistributed DDL

0 likes · 5 min read

Resolving Stuck Distributed DDL in ClickHouse: Diagnosis and Workaround