MV_ REPLICATION_ MANAGEMENT_ REF_ DB_ STATE
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.
This view shows the state of the reference database replica on the node.
This view is also available as an LMV (local view per node) view.
Column Name |
Description |
---|---|
NODE_ |
The node ID for the node that originated this replication management row. |
ID |
Internal ID for replication management. |
DISTRIBUTED_ |
The ID of this distributed database, in the sharded database table of cluster database metadata. |
INSTANCE_ |
The ID of the node that hosts this reference database replica. |
METADATA_ |
The role of this instance in cluster metadata. |
LOCAL_ |
The role of this instance locally on the node where it exists. |
DR_ |
Whether the database is a DR replica or not, and if so whether it is paused or not. |
MASTER_ |
Term uniquely identifies a period during which an instance of a database is a master. |
LOCAL_ |
Term uniquely identifies a period during which an instance of a database is a master. |
UPDATE_ |
The last iteration counter on which this state was updated. |
DATABASE_ |
Name of the database. |
RUNTIME_ |
Records whether the runtime state for this reference database was successfully updated or not (this includes partition boundaries, for example). |
Last modified: September 14, 2022