EXPORT METADATA :: ShardingSphere

EXPORT METADATA

The EXPORT METADATA syntax is used to export cluster metadata in JSON format.

ExportMetaData ::=
  'EXPORT' 'METADATA' ('TO' 'FILE' filePath)?

filePath ::=
  string

Columns	Description
id	current compute node id
create_time	export time
cluster_info	exported metadata (or success message when `TO FILE` is set)

When filePath is not specified, the cluster_info column returns Base64-encoded metadata;
When filePath is specified, metadata is written to file and cluster_info returns a success message;
The parent directory of filePath will be created automatically if needed, and existing file content will be overwritten.

EXPORT METADATA;

EXPORT METADATA TO FILE '/tmp/metadata.json';

EXPORT, METADATA, TO, FILE

EXPORT METADATA