v.23.5Improvement

Add zookeeper_name Column to system.replicas for Metadata Storage Indication

Official CH changelog text
Add a new column zookeeper_name in system.replicas, to indicate on which (auxiliary) zookeeper cluster the replicated table's metadata is stored. #48549 (cangyin).
Added a new column zookeeper_name to the system.replicas table to indicate the auxiliary ZooKeeper cluster where the replicated table's metadata is stored.

Why it matters

This feature allows users to identify on which ZooKeeper cluster the metadata of replicated tables resides, especially useful when multiple auxiliary ZooKeeper clusters are used. It enhances transparency and monitoring capabilities for distributed replicated tables.

How to use it

Users can query the system.replicas table and use the new zookeeper_name column to determine the ZooKeeper cluster associated with each replica's metadata storage. No additional configuration is required to enable this feature.

Related resources

PreviousNext