v.22.3Experimental Feature

Add database_replicated_allow_only_replicated_engine setting for Replicated databases

Official CH changelog text
Add database_replicated_allow_only_replicated_engine setting. When enabled, it only allowed to only create Replicated tables or tables with stateless engines in Replicated databases. #35214 (Nikolai Kochetov). Note that Replicated database is still an experimental feature.
Introduced the database_replicated_allow_only_replicated_engine setting which restricts table creation within Replicated databases to only Replicated tables or tables with stateless engines.

Why it matters

This setting ensures consistency and proper usage of Replicated databases by preventing users from creating non-replicated tables, which could lead to replication issues or misconfigurations. It enforces best practices for managing replicated data and improves data reliability within these experimental database types.

How to use it

Enable the database_replicated_allow_only_replicated_engine setting in your ClickHouse server configuration or session to restrict table creation inside Replicated databases. Once enabled, attempting to create non-replicated tables in such databases will be disallowed.

Related resources

PreviousNext