Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

RESTORE REDUNDANCY

Info

SingleStore Managed Service does not support this command.

Restore redundancy by replicating any partitions with only one instance.

Syntax

RESTORE REDUNDANCY ON db_name

Remarks

  • db_name is the name of a SingleStore DB database.
  • Similarly, REBALANCE PARTITIONS restores redundancy by replicating any partitions with only one instance. However, REBALANCE PARTITIONS then does the additional step of moving partitions around to ensure balance across all the leaves.
  • This command must be run on the master aggregator node (see Node Requirements for SingleStore DB Commands ).

Example

RESTORE REDUNDANCY on memsql_demo;
Query OK, 1 row affected (2.89 sec)