CHECK EXTERNAL CONNECTION

The CHECK EXTERNAL CONNECTION tests the connection from each node in the cluster to an external cloud storage location. CHECK EXTERNAL CONNECTION will measure the time it takes each node to write a file, read it, and delete it from the specified storage location. You can adjust the number and concurrency of the test runs as well as the size of the file to write and read for each test.

You can use the CHECK EXTERNAL CONNECTION to test the connection to locations.

Synopsis

Parameters

Parameter	Description
connection_uri	The URI to the external storage. Specify the (e.g., gs://bucket_name?AUTH...) or a user-defined (e.g., external://gcs).

Options

Option	Value	Description
concurrently	INT	Run multiple connection tests concurrently. If you also set the time option, it will run the specified number of concurrent tests until the time has elapsed. By default, only 1 connection test will run.
time	STRING	Run the test repeatedly until the duration has elapsed.
transfer	STRING	The size of the file that is written and read during each iteration of the connection test. By default, this will transfer a 32MiB file.

Responses

Field	Value	Description
node	INT	The node ID.
locality	STRING	The of the node.
ok	BOOL	Whether the test run succeeded.
error	STRING	Errors encountered during the test run.
transferred	STRING	The size of the file transferred during the test.
read_speed	STRING	The speed at which the node read the test file.
write_speed	STRING	The speed at which the node wrote the test file.
can_delete	BOOL	Whether file deletion succeeded.

Test an external connection

Specify the connection URI to the , or a created :

CHECK EXTERNAL CONNECTION 'external://cloud-storage';

  node |                 locality                  | ok | error | transferred | read_speed  | write_speed | can_delete
-------+-------------------------------------------+----+-------+-------------+-------------+-------------+-------------
     1 | cloud=gce,region=us-east1,zone=us-east1-b | t  |       | 32 MiB      | 66.17 MiB/s | 37.52 MiB/s |     t
     3 | cloud=gce,region=us-east1,zone=us-east1-b | t  |       | 32 MiB      | 41.77 MiB/s | 33.55 MiB/s |     t
     2 | cloud=gce,region=us-east1,zone=us-east1-b | t  |       | 32 MiB      | 14.23 MiB/s | 37.12 MiB/s |     t

To modify the testing parameters, use one or a combination of the options: concurrently, time, transfer. For details on each, refer to Options.

CHECK EXTERNAL CONNECTION 'external://cloud-storage' WITH transfer = '50MiB', concurrently = 5, time = '1ms';

  node |                 locality                  | ok | error | transferred | read_speed  | write_speed | can_delete
-------+-------------------------------------------+----+-------+-------------+-------------+-------------+-------------
     2 | cloud=gce,region=us-east1,zone=us-east1-b | t  |       | 50 MiB      | 59.85 MiB/s | 34.99 MiB/s |     t
     1 | cloud=gce,region=us-east1,zone=us-east1-b | t  |       | 50 MiB      | 58.26 MiB/s | 34.91 MiB/s |     t
     1 | cloud=gce,region=us-east1,zone=us-east1-b | t  |       | 50 MiB      | 57.69 MiB/s | 32.30 MiB/s |     t
     2 | cloud=gce,region=us-east1,zone=us-east1-b | t  |       | 50 MiB      | 55.51 MiB/s | 33.02 MiB/s |     t
     3 | cloud=gce,region=us-east1,zone=us-east1-b | t  |       | 50 MiB      | 59.29 MiB/s | 31.45 MiB/s |     t
     3 | cloud=gce,region=us-east1,zone=us-east1-b | t  |       | 50 MiB      | 55.61 MiB/s | 32.58 MiB/s |     t
     3 | cloud=gce,region=us-east1,zone=us-east1-b | t  |       | 50 MiB      | 61.04 MiB/s | 29.63 MiB/s |     t
     1 | cloud=gce,region=us-east1,zone=us-east1-b | t  |       | 50 MiB      | 47.69 MiB/s | 34.04 MiB/s |     t
     1 | cloud=gce,region=us-east1,zone=us-east1-b | t  |       | 50 MiB      | 55.66 MiB/s | 30.39 MiB/s |     t
     1 | cloud=gce,region=us-east1,zone=us-east1-b | t  |       | 50 MiB      | 57.77 MiB/s | 29.64 MiB/s |     t
     2 | cloud=gce,region=us-east1,zone=us-east1-b | t  |       | 50 MiB      | 44.95 MiB/s | 34.41 MiB/s |     t
     2 | cloud=gce,region=us-east1,zone=us-east1-b | t  |       | 50 MiB      | 46.77 MiB/s | 33.31 MiB/s |     t
     2 | cloud=gce,region=us-east1,zone=us-east1-b | t  |       | 50 MiB      | 57.64 MiB/s | 28.96 MiB/s |     t
     3 | cloud=gce,region=us-east1,zone=us-east1-b | t  |       | 50 MiB      | 58.99 MiB/s | 26.65 MiB/s |     t
     3 | cloud=gce,region=us-east1,zone=us-east1-b | t  |       | 50 MiB      | 15.14 MiB/s | 33.45 MiB/s |     t

See also