RESTORE REDUNDANCY
Restore redundancy by replicating any partitions with only one instance.
Syntax
RESTORE REDUNDANCY ON db_name
Remarks
db_name
is the name of a MemSQL 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 MemSQL Commands ).
Example
memsql> RESTORE REDUNDANCY on memsql_demo;
Query OK, 1 row affected (2.89 sec)