Support ALTER DATABASE

Why it matters

This feature enables users to perform ALTER DATABASE operations on multiple nodes within a cluster simultaneously. It simplifies the management of distributed database environments by allowing consistent and synchronized schema changes across all cluster nodes, reducing manual effort and the risk of configuration drift.

How to use it

Use the extended syntax ALTER DATABASE ... ON CLUSTER <cluster_name> to apply database alterations across all servers in the specified cluster. For example:

ALTER DATABASE my_database ON CLUSTER my_cluster MODIFY SETTING some_setting = 'value';