You are viewing an older version of this section. View current production version.
Restore redundancy by replicating any partitions with only one instance.
RESTORE REDUNDANCY ON db_name
db_nameis the name of a MemSQL database.
REBALANCE PARTITIONSrestores redundancy by replicating any partitions with only one instance. However,
REBALANCE PARTITIONSthen 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 ).
memsql> RESTORE REDUNDANCY on memsql_demo; Query OK, 1 row affected (2.89 sec)