Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

EXPLAIN RESTORE REDUNDANCY

The EXPLAIN RESTORE REDUNDANCY command returns the set of steps RESTORE REDUNDANCY would run.

Syntax

EXPLAIN RESTORE REDUNDANCY ON db_name

Remarks

  • db_name: name of the SingleStore Helios database.

  • This command must be run on the master aggregator node.

Examples

The following query returns a set of steps that RESTORE REDUNDANCY will run if executed at the same time on trades database.

EXPLAIN RESTORE REDUNDANCY ON trades;
+----------------------+---------+-------------+-------------+-------+
| Action               | Ordinal | Target_Host | Target_Port | Phase |
+----------------------+---------+-------------+-------------+-------+
| COPY PARTITION FORCE |       0 | 127.0.0.1   |        3309 |     2 |
| COPY PARTITION FORCE |       1 | 127.0.0.1   |        3309 |     2 |
| COPY PARTITION FORCE |       2 | 127.0.0.1   |        3309 |     2 |
| COPY PARTITION FORCE |       3 | 127.0.0.1   |        3309 |     2 |
| COPY PARTITION FORCE |       4 | 127.0.0.1   |        3309 |     2 |
| COPY PARTITION FORCE |       5 | 127.0.0.1   |        3309 |     2 |
| COPY PARTITION FORCE |       6 | 127.0.0.1   |        3309 |     2 |
| COPY PARTITION FORCE |       7 | 127.0.0.1   |        3309 |     2 |
+----------------------+---------+-------------+-------------+-------+
8 rows in set (0.01 sec)

Last modified:

Was this article helpful?