v.25.5Improvement

Support ALTERing database on cluster

Support ALTERing database on cluster. #79242 (Tuan Pham Anh).
Added support for executing ALTER commands on databases across a cluster in ClickHouse.

Why it matters

This feature enables users to modify database properties or settings consistently on all nodes within a cluster using a single ALTER DATABASE command, simplifying cluster management and ensuring configuration uniformity.

How to use it

Use the ALTER DATABASE statement with the ON CLUSTER clause to apply changes across all nodes. For example:

ALTER DATABASE db_name ON CLUSTER cluster_name MODIFY SETTING ...