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.
EXPLAIN RESTORE REDUNDANCY
On this page
Returns the set of steps RESTORE REDUNDANCY would run if executed.
Syntax
EXPLAIN RESTORE REDUNDANCY ON db_nameRemarks
-
db_: name of the SingleStore database.name -
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: November 16, 2022