SQLite Cloud

LIST NODES

Syntax

LIST NODES

Privileges

CLUSTERADMIN, CLUSTERMONITOR

Description

The LIST NODES command returns a rowset with information about all the nodes that compose the cluster environment. In addition to static information, this command also reports up-to-date information about the Raft status of each node.

Return

A Rowset with the following columns:

  • id: node ID
  • node: public node DNS name and port
  • cluster: DNS name and port used for Raft intra-node communication
  • status: Follower or Leader
  • progress: Probe, Replicate, Snapshot or Unknown
  • match: Raft log ID
  • last_activity: last activity date and time

Example

> LIST NODES
----|--------------------------|---------------------------|----------|-----------|-------|---------------------|
 id | node                     | cluster                   | status   | progress  | match | last_activity       |
----|--------------------------|---------------------------|----------|-----------|-------|---------------------|
 1  | dev1.sqlitecloud.io:9960 | dev1.sqlitecloud.io:10960 | Follower | Replicate | 13463 | 2023-02-08 08:17:08 |
 2  | dev2.sqlitecloud.io:9960 | dev2.sqlitecloud.io:10960 | Leader   | Replicate | 13463 | 2023-02-08 08:17:08 |
 3  | dev3.sqlitecloud.io:9960 | dev3.sqlitecloud.io:10960 | Follower | Replicate | 13463 | 2023-02-08 08:17:08 |
----|--------------------------|---------------------------|----------|-----------|-------|---------------------|