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 SingleStore 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. Refer to COMMIT for more information.

  • Node Requirements for SingleStore Commands

  • 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

Was this article helpful?