v.23.6Experimental Feature

Do not replicate ALTER PARTITION queries in single-shard ReplicatedMergeTree

Do not replicate ALTER PARTITION queries and mutations through Replicated database if it has only one shard and the underlying table is ReplicatedMergeTree. #51049 (Alexander Tokmakov).
Prevent replication of ALTER PARTITION queries and mutations in Replicated databases that contain only a single shard with ReplicatedMergeTree tables.

Why it matters

This feature optimizes the behavior of Replicated databases by avoiding unnecessary replication of ALTER PARTITION commands and mutations when there is only one shard. It reduces overhead and improves efficiency by eliminating redundant replication operations that do not provide any benefit in a single-shard setup.

How to use it

No specific user action is required. The change automatically applies to Replicated databases with only one shard and underlying tables of type ReplicatedMergeTree, preventing replication of relevant ALTER PARTITION queries and mutations.