v.25.8New Feature

New SYSTEM RESTORE DATABASE REPLICA

Official CH changelog text
The new SYSTEM RESTORE DATABASE REPLICA for Replicated databases, similar to the existing functionality for restore in ReplicatedMergeTree. #73100 (Konstantin Morozov).
Introduces the SYSTEM RESTORE DATABASE REPLICA command for replicated databases, enabling restoration of database replicas similarly to the existing restore functionality in ReplicatedMergeTree tables.

Why it matters

This feature addresses the need to restore replicated database replicas to a consistent state after failures or issues, extending restore capabilities beyond individual tables to entire databases. It enhances reliability and ease of recovery for users managing replicated database setups.

How to use it

Users can run the command SYSTEM RESTORE DATABASE REPLICA <database_name> to initiate restoration of a replicated database replica. This command should be executed on the replica that requires restoration.

Related resources

PreviousNext