v.1.1.54388New Feature

New SYSTEM Queries for Replicated Tables

Official CH changelog text
Several new SYSTEM queries for replicated tables (RESTART REPLICAS, SYNC REPLICA, [STOP|START] [MERGES|FETCHES|SENDS REPLICATED|REPLICATION QUEUES]).
Added several new SYSTEM queries for managing replicated tables, including RESTART REPLICAS, SYNC REPLICA, and commands to STOP or START merges, fetches, sends replicated parts, and replication queues.

Why it matters

These new commands provide enhanced control over the replication process in ClickHouse. They allow users to manually synchronize replicas, restart replication processes, and manage background operations such as merges and fetches. This helps in maintaining data consistency and resolving replication issues without downtime.

How to use it

Users can execute the new commands in the ClickHouse client or any query interface using the SYSTEM keyword, for example:

SYSTEM RESTART REPLICAS
SYSTEM SYNC REPLICA
SYSTEM STOP MERGES
SYSTEM START FETCHES

These commands target replicated tables to control replication behavior as needed.
PreviousNext