v.24.1New Feature

Added FROM Modifier for SYSTEM SYNC REPLICA LIGHTWEIGHT Query

Official CH changelog text
Added FROM <Replicas> modifier for SYSTEM SYNC REPLICA LIGHTWEIGHT query. With the FROM modifier ensures we wait for fetches and drop-ranges only for the specified source replicas, as well as any replica not in zookeeper or with an empty source_replica. #58393 (Jayme Bird).
Added a FROM <Replicas> modifier to the SYSTEM SYNC REPLICA LIGHTWEIGHT query, allowing synchronization to target specific source replicas.

Why it matters

This feature solves the problem of broad synchronization scope in the SYSTEM SYNC REPLICA LIGHTWEIGHT query by enabling users to wait for fetches and drop-ranges only from specified source replicas. It improves control and efficiency when managing replica synchronization, especially in environments with multiple replicas.

How to use it

Use the enhanced SYSTEM SYNC REPLICA LIGHTWEIGHT query with the FROM <Replicas> modifier to specify the source replicas to synchronize from. For example:

SYSTEM SYNC REPLICA LIGHTWEIGHT FROM replica1, replica2

This command waits for fetches and drop-ranges only for the listed replicas, as well as for any replica not present in ZooKeeper or having an empty source_replica field.

Related resources

PreviousNext