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 SingleStoreDB 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 causes implicit commits. See COMMIT for more information.
This command cannot be run on system databases.
See the Permission Matrix for the required permission.
Example
RESTORE REDUNDANCY on memsql_demo; Query OK, 1 row affected (2.89 sec)