Outdated Version
You are viewing an older version of this section. View current production version.
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 ).
Info
This MemSQL feature is only available in MemSQL Enterprise Edition. MemSQL Enterprise Edition includes 24x7 support and several enterprise-only features for critical deployments. For more information about MemSQL Developer and MemSQL Enterprise, see the MemSQL Editions page.
Example
memsql> RESTORE REDUNDANCY on memsql_demo;
Query OK, 1 row affected (2.89 sec)