mutations_sync = 1 vs Asynchronous Mutations for Schema Consistency
Schema Update Propagation in ReplicatedMergeTree When executing ALTER TABLE ... UPDATE or similar mutations on a ReplicatedMergeTree table across a cluster, ClickHouse manages these changes asynchronously by default. The metadata is propagated via ZooKeeper, but the actual data rewriting occurs in the background as parts are merged. In environments requiring
clickhouse