Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
RESTORE REDUNDANCY
On this page
Restore redundancy by replicating any partitions with only one instance.
Syntax
RESTORE REDUNDANCY ON db_name
Remarks
-
db_
is the name of a SingleStore database.name -
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.
Refer to COMMIT for more information. -
This command cannot be run on system databases.
-
Refer to the Permission Matrix for the required permission.
Example
RESTORE REDUNDANCY on memsql_demo;
Query OK, 1 row affected (2.89 sec)
Last modified: July 31, 2023