v.20.10New Feature

Allow User-Defined Settings for ReplicatedMergeTree Storage in Config File

Official CH changelog text
Allow user to specify settings for ReplicatedMergeTree* storage in <replicated_merge_tree> section of config file. It works similarly to <merge_tree> section. For ReplicatedMergeTree* storages settings from <merge_tree> and <replicated_merge_tree> are applied together, but settings from <replicated_merge_tree> has higher priority. Added system.replicated_merge_tree_settings table. #13573 (Amos Bird).
Allows users to specify configuration settings for ReplicatedMergeTree* storage engines within the <replicated_merge_tree> section of the ClickHouse config file, similar to the existing <merge_tree> settings section.

Why it matters

This feature provides finer control over ReplicatedMergeTree* storage behaviors by enabling custom settings that have higher priority than those defined in the <merge_tree> section. It simplifies configuration management and improves flexibility for replicated table setups.

How to use it

To use this feature, add the desired settings under the <replicated_merge_tree> section in your ClickHouse configuration file. These settings are applied together with those from <merge_tree>, but take precedence. Additionally, users can query the new system.replicated_merge_tree_settings table to view the effective settings for ReplicatedMergeTree* storages.

Related resources

PreviousNext