Retro Eye care Haitian Deep Dark Default

EXPORT STORAGE NODES

Description

The EXPORT STORAGE NODES syntax is used to export storage node configurations in JSON format.

Syntax

ExportStorageNodes ::=
  'EXPORT' 'STORAGE' 'NODES' ('FROM' databaseName)? ('TO' 'FILE' filePath)?

databaseName ::=
  identifier

filePath ::=
  string

Return Value Description

Columns Description
id current compute node id
create_time export time
storage_nodes exported storage node JSON (or success message when TO FILE is set)

Supplement

  • When databaseName is not specified, storage nodes of all logical databases are exported;
  • When databaseName is specified, only storage nodes of the specified logical database are exported;
  • If the specified databaseName does not exist, export will fail;
  • When filePath is specified, the result is written to file and existing file content will be overwritten;
  • Exported JSON contains connection information such as username and password; protect the output properly.

Example

EXPORT STORAGE NODES;

EXPORT STORAGE NODES FROM sharding_db TO FILE '/tmp/storage-nodes.json';

Reserved word

EXPORT, STORAGE, NODES, FROM, TO, FILE