Querying a StarRocks Instance

Function

This API is used to query a StarRocks instance. Before calling this API:

Learn how to authorize and authenticate it.
Obtain the required region and endpoint.

URI

GET /v3/{project_id}/instances/{instance_id}/starrocks/{starrocks_instance_id}

**Table 1** URI parameters
Parameter	Mandatory	Type	Description
project_id	Yes	String	Project ID of a tenant in a region. To obtain this value, see Obtaining a Project ID.
instance_id	Yes	String	GaussDB(for MySQL) instance ID, which is compliant with the UUID format.
starrocks_instance_id	Yes	String	StarRocks instance ID, which is compliant with the UUID format.

Request Parameters

**Table 2** Request header parameters
Parameter	Mandatory	Type	Description
X-Auth-Token	Yes	String	User token. To obtain this value, call the IAM API for obtaining a user token. The value of X-Subject-Token in the response header is the token value.
Content-Type	Yes	String	Content type. Value: application/json
X-Language	No	String	Request language type. The default value is en-us. Values: en-us zh-cn

Response Parameters

Status code: 200

**Table 3** Response body parameters
Parameter	Type	Description
instances	Array of instances objects	Instance information.

**Table 4** instances
Parameter	Type	Description
id	String	Instance ID, which is compliant with the UUID format.
name	String	Instance name.
project_id	String	Project ID of a tenant in a region.
public_ip	String	Public IP address.
data_vip	String	Data IP address of the frontend node. Use commas (,) to separate multiple IP addresses.
can_enable_public_access	Boolean	Whether the instance can be accessed from a public network.
current_backup_node_id	String	ID of the backup node.
cluster_mode	String	Deployment mode.
status	String	Instance status.
is_frozen	Integer	Whether the instance is frozen.
frozen_time	Long	Frozen time.
db_user	String	Default username.
bak_period	String	Backup cycle.
bak_keep_day	Integer	Backup retention days.
bak_expected_start_time	Long	Estimated backup start time.
data_store_version_id	String	DB version ID.
data_store_version	String	DB version.
data_store_type	String	DB engine.
create_at	Long	Instance creation time.
update_at	Long	Instance update time.
delete_at	Long	Instance deletion time.
db_port	String	Database port.
param_group	String	Parameter template.
actions	Array of QueryAction objects	Instance actions.
create_fail_error_code	String	Error code for creation failure.
groups	Array of groups objects	Instance groups.
ops_window	ops_window object	Instance operation time window.
tags_info	tags_info object	Instance tags.
time_zone	String	Time zone.
backup_used_space	String	Used backup space.
az_mode	String	AZ type. Values: single: single AZ multi: multiple AZs
enterprise_project_id	String	Enterprise project ID.
port_info	port_info object	Port information.
fe_node_volume_code	String	Storage type of the frontend node.
be_node_volume_code	String	Storage type of the backend node.
fe_node_volume_size	String	Storage space of the frontend node.
be_node_volume_size	String	Storage space of the backend node.
support_data_replication	Boolean	Whether data replication is supported.
new_version_available	Boolean	Whether there is a new DB version available.
ssl_option	Boolean	SSL switch.
dedicated_resource_id	String	Dedicated resource pool ID. This parameter is returned only when the instance belongs to a dedicated resource pool.
pay_model	String	Billing mode.

**Table 5** groups
Parameter	Type	Description
id	String	Group ID.
name	String	Group name.
nodes	Array of nodes objects	Instance node information.
group_type_name	String	Instance group type name.
group_node_type	String	Type of the node in the instance group.

**Table 6** nodes
Parameter	Type	Description
id	String	Instance node ID.
name	String	Instance node name.
type	String	Instance node type.
status	String	Node status. Values: creating: The node is being created. normal: The node is normal. abnormal: The node is abnormal. createfail: The node failed to be created.
period	String	Instance node subscription period.
volume	volume object	Instance node storage information.
cpu	String	vCPUs of the instance node.
mem	String	Memory size (GB) of the instance node.
datastore	datastore object	Database information.
actions	Array of QueryAction objects	Node actions.
priority	Integer	Node priority.
frozen_flag	Integer	Frozen flag.
db_port	Integer	Database port number. The default value is 3306.
pay_model	String	Billing mode.
order_id	String	Order ID.
traffic_ip	String	Data IP address.
traffic_ipv6	String	Data IPv6 address.
az_code	String	AZ code.
az_description	String	AZ description.
az_type	String	AZ type.
region_code	String	Region where the instance is deployed.
create_at	Long	Time when the node was created.
update_at	Long	Time when the node was updated.
flavor_id	String	Node specification ID.
flavor_ref	String	Node specification code.
iaas_flavor_ref	String	IaaS specification code.
max_connections	String	Maximum number of public network connections.
vpc_id	String	VPC ID.
subnet_id	String	Subnet ID.
need_restart	Boolean	Whether a reboot is required for parameter update.
sg_id	String	Security group.
param_group	Map<String,ParamGroup>	Parameter template information.

**Table 7** volume
Parameter	Type	Description
type	String	Storage type of the instance node.
size	String	Storage space of the instance node.

**Table 8** datastore
Parameter	Type	Description
id	String	Database ID.
type	String	Database type.
version	String	DB version.

**Table 9** QueryAction
Parameter	Type	Description
id	String	Instance or node action ID.
action	String	Instance or node action name.
object_id	String	Object ID of the instance or node action.
type	String	Instance or node action type.
job_id	String	Task ID of the instance or node action.
status	String	Instance or node action status. Enumerated values: OK_TO_RUN DELETED
created_at	Long	Time when the instance or node action was created.
updated_at	Long	Time when the instance or node action was updated.

**Table 10** ParamGroup
Parameter	Type	Description
id	String	Parameter template ID.
name	String	Parameter template name.

**Table 11** ops_window
Parameter	Type	Description
period	String	Time window period.
start_time	String	Start time of the time window.
end_time	String	End time of the time window.

**Table 12** tags_info
Parameter	Type	Description
tags	Array of tags objects	User tags.
sys_tags	Array of sys_tags objects	System tags.

**Table 13** tags
Parameter	Type	Description
key	String	Tag key. It can contain a maximum of 36 Unicode characters. It cannot be an empty string, a space, or left blank. It can contain uppercase and lowercase letters, digits, hyphens (-), underscores (_), and Unicode characters (\u4E00-\u9FFF).
value	String	Tag value. It can contain a maximum of 43 Unicode characters. It can be an empty string. It can contain uppercase and lowercase letters, digits, periods (.), hyphens (-), underscores (_), and Unicode characters (\u4E00-\u9FFF).

**Table 14** sys_tags
Parameter	Type	Description
key	String	Tag key. It can contain a maximum of 36 Unicode characters. It cannot be an empty string, a space, or left blank. It can contain uppercase and lowercase letters, digits, hyphens (-), underscores (_), and Unicode characters (\u4E00-\u9FFF).
value	String	Tag value. It can contain a maximum of 43 Unicode characters. It can be an empty string. It can contain uppercase and lowercase letters, digits, periods (.), hyphens (-), underscores (_), and Unicode characters (\u4E00-\u9FFF).

**Table 15** port_info
Parameter	Type	Description
mysql_port	Integer	GaussDB(for MySQL) port number. The default value is 3306.

Status code: 400

**Table 16** Response body parameters
Parameter	Type	Description
error_code	String	Error code.
error_msg	String	Error message.

Status code: 500

**Table 17** Response body parameters
Parameter	Type	Description
error_code	String	Error code.
error_msg	String	Error message.

Example Request

Querying the ID of a StarRocks instance

GET https://{endpoint}/v3/23a50154cf494ec9ad6883979a12db0a/instances/fb632d1d531a4107804f0f082581810fin07/starrocks/b6280c323ce449f2ad02af74e21f3dc5in17

Example Response

Status code: 200

Success.

{
  "instances" : [ {
    "id" : "b6280c323ce449f2ad02af74e21f3dc5in17",
    "name" : "htap-7ef5",
    "project_id" : "23a50154cf494ec9ad6883979a12db0a",
    "public_ip" : "",
    "data_vip" : "10.0.0.156,10.0.0.179,10.0.0.199,10.0.0.152",
    "can_enable_public_access" : false,
    "current_backup_node_id" : null,
    "cluster_mode" : "Cluster",
    "status" : "abnormal",
    "is_frozen" : 0,
    "frozen_time" : null,
    "db_user" : null,
    "bak_period" : null,
    "bak_keep_day" : null,
    "bak_expected_start_time" : null,
    "data_store_version_id" : "38197973-8895-36ed-b853-52daeefb6d3a",
    "data_store_version" : "3.1.6.0",
    "data_store_type" : "star-rocks",
    "create_at" : 1711421838049,
    "update_at" : 1711423400451,
    "delete_at" : null,
    "db_port" : "3306",
    "param_group" : null,
    "actions" : [ ],
    "create_fail_error_code" : null,
    "groups" : [ {
      "id" : "73a7c579381041e1867e9facdf11ca7egr17",
      "name" : "htap-7ef5_fe_shard01",
      "nodes" : [ {
        "id" : "21f14a5974a540f2afb541eaf6e90107no17",
        "name" : "htap-7ef5_fe_shard01_node04",
        "type" : "fe-follower",
        "status" : "normal",
        "period" : "null",
        "volume" : {
          "type" : "SSD",
          "size" : "50000000000",
          "used" : null,
          "iops" : null
        },
        "cpu" : "4",
        "mem" : "16",
        "datastore" : {
          "id" : "38197973-8895-36ed-b853-52daeefb6d3a",
          "type" : "star-rocks",
          "version" : "3.1.6.0"
        },
        "actions" : [ ],
        "priority" : 1,
        "frozen_flag" : 0,
        "db_port" : 3306,
        "pay_model" : "0",
        "order_id" : null,
        "traffic_ip" : "10.0.0.156",
        "traffic_ipv6" : "",
        "az_code" : "az",
        "az_description" : "az1",
        "az_type" : "Center",
        "region_code" : "region1",
        "create_at" : 1711421838049,
        "update_at" : 1711422776266,
        "flavor_id" : "afef3bfd-ac7c-32e1-ba44-c388acbb196a",
        "flavor_ref" : "gaussdb.sr-fe.xlarge.x86.4",
        "iaas_flavor_ref" : "c6.xlarge.4",
        "max_connections" : "0",
        "vpc_id" : "d5a1a29b-1476-490f-9682-c1a59593e7b0",
        "subnet_id" : "2ce0bc80-bfc5-4d5e-9b78-a7f91572e03b",
        "need_restart" : false,
        "sg_id" : "967a0ac2-3cae-4e57-a49a-d0f6ff07dcc1",
        "param_group" : null
      }, {
        "id" : "60c7b1dda3c14366b9e6314de0be905bno17",
        "name" : "htap-7ef5_fe_shard01_node03",
        "type" : "fe-follower",
        "status" : "normal",
        "period" : "null",
        "volume" : {
          "type" : "SSD",
          "size" : "50000000000",
          "used" : null,
          "iops" : null
        },
        "cpu" : "4",
        "mem" : "16",
        "datastore" : {
          "id" : "38197973-8895-36ed-b853-52daeefb6d3a",
          "type" : "star-rocks",
          "version" : "3.1.6.0"
        },
        "actions" : [ ],
        "priority" : 1,
        "frozen_flag" : 0,
        "db_port" : 3306,
        "pay_model" : "0",
        "order_id" : null,
        "traffic_ip" : "10.0.0.179",
        "traffic_vip" : "",
        "traffic_ipv6" : "",
        "traffic_vipv6" : "",
        "az_code" : "az",
        "az_description" : "az1",
        "az_type" : "Center",
        "region_code" : "region1",
        "create_at" : 1711421838049,
        "update_at" : 1711421838049,
        "flavor_id" : "afef3bfd-ac7c-32e1-ba44-c388acbb196a",
        "flavor_ref" : "gaussdb.sr-fe.xlarge.x86.4",
        "iaas_flavor_ref" : "c6.xlarge.4",
        "max_connections" : "0",
        "vpc_id" : "d5a1a29b-1476-490f-9682-c1a59593e7b0",
        "subnet_id" : "2ce0bc80-bfc5-4d5e-9b78-a7f91572e03b",
        "need_restart" : false,
        "sg_id" : "967a0ac2-3cae-4e57-a49a-d0f6ff07dcc1",
        "param_group" : null
      }, {
        "id" : "c786d7b2593645ffac4544a3107943b4no17",
        "name" : "htap-7ef5_fe_shard01_node02",
        "type" : "fe-follower",
        "status" : "normal",
        "period" : "null",
        "volume" : {
          "type" : "SSD",
          "size" : "50000000000",
          "used" : null,
          "iops" : null
        },
        "cpu" : "4",
        "mem" : "16",
        "datastore" : {
          "id" : "38197973-8895-36ed-b853-52daeefb6d3a",
          "type" : "star-rocks",
          "version" : "3.1.6.0"
        },
        "actions" : [ ],
        "priority" : 1,
        "frozen_flag" : 0,
        "db_port" : 3306,
        "pay_model" : "0",
        "order_id" : null,
        "traffic_ip" : "10.0.0.199",
        "traffic_vip" : "",
        "traffic_ipv6" : "",
        "traffic_vipv6" : "",
        "az_code" : "az",
        "az_description" : "az1",
        "az_type" : "Center",
        "region_code" : "region1",
        "create_at" : 1711421838049,
        "update_at" : 1711421838049,
        "flavor_id" : "afef3bfd-ac7c-32e1-ba44-c388acbb196a",
        "flavor_ref" : "gaussdb.sr-fe.xlarge.x86.4",
        "iaas_flavor_ref" : "c6.xlarge.4",
        "max_connections" : "0",
        "vpc_id" : "d5a1a29b-1476-490f-9682-c1a59593e7b0",
        "subnet_id" : "2ce0bc80-bfc5-4d5e-9b78-a7f91572e03b",
        "need_restart" : false,
        "sg_id" : "967a0ac2-3cae-4e57-a49a-d0f6ff07dcc1",
        "param_group" : null
      }, {
        "id" : "ffb9f510f9934b0384789a2a4652d3e0no17",
        "name" : "htap-7ef5_fe_shard01_node01",
        "type" : "fe-leader",
        "status" : "abnormal",
        "period" : "null",
        "volume" : {
          "type" : "SSD",
          "size" : "50000000000",
          "used" : null,
          "iops" : null
        },
        "cpu" : "4",
        "mem" : "16",
        "datastore" : {
          "id" : "38197973-8895-36ed-b853-52daeefb6d3a",
          "type" : "star-rocks",
          "version" : "3.1.6.0"
        },
        "actions" : [ ],
        "priority" : 1,
        "frozen_flag" : 0,
        "db_port" : 3306,
        "pay_model" : "0",
        "order_id" : null,
        "traffic_ip" : "10.0.0.152",
        "traffic_ipv6" : "",
        "az_code" : "az",
        "az_description" : "az1",
        "az_type" : "Center",
        "region_code" : "region1",
        "create_at" : 1711421838049,
        "update_at" : 1711422932204,
        "flavor_id" : "afef3bfd-ac7c-32e1-ba44-c388acbb196a",
        "flavor_ref" : "gaussdb.sr-fe.xlarge.x86.4",
        "iaas_flavor_ref" : "c6.xlarge.4",
        "max_connections" : "0",
        "vpc_id" : "d5a1a29b-1476-490f-9682-c1a59593e7b0",
        "subnet_id" : "2ce0bc80-bfc5-4d5e-9b78-a7f91572e03b",
        "need_restart" : false,
        "sg_id" : "967a0ac2-3cae-4e57-a49a-d0f6ff07dcc1",
        "param_group" : null
      } ],
      "group_type_name" : "starrocks",
      "group_node_type" : "fe"
    }, {
      "id" : "bf50855824c9485f9368845dfb4457dcgr17",
      "name" : "htap-7ef5_be_shard01",
      "nodes" : [ {
        "id" : "98e7f36d39fb4d9ca7c92c8c1fa4991ano17",
        "name" : "htap-7ef5_be_shard01_node02",
        "type" : "be",
        "status" : "normal",
        "period" : "null",
        "volume" : {
          "type" : "SSD",
          "size" : "50000000000",
          "used" : null,
          "iops" : null
        },
        "cpu" : "4",
        "mem" : "16",
        "datastore" : {
          "id" : "38197973-8895-36ed-b853-52daeefb6d3a",
          "type" : "star-rocks",
          "version" : "3.1.6.0"
        },
        "actions" : [ ],
        "priority" : 1,
        "frozen_flag" : 0,
        "db_port" : 3306,
        "pay_model" : "0",
        "order_id" : null,
        "traffic_ip" : "10.0.0.202",
        "traffic_vip" : "",
        "traffic_ipv6" : "",
        "traffic_vipv6" : "",
        "az_code" : "az",
        "az_description" : "az1",
        "az_type" : "Center",
        "region_code" : "region1",
        "create_at" : 1711421838049,
        "update_at" : 1711422835209,
        "flavor_id" : "de565db8-0a96-37ea-9388-61167624712c",
        "flavor_ref" : "gaussdb.sr-be.xlarge.x86.4",
        "iaas_flavor_ref" : "c6.xlarge.4",
        "max_connections" : "0",
        "vpc_id" : "d5a1a29b-1476-490f-9682-c1a59593e7b0",
        "subnet_id" : "2ce0bc80-bfc5-4d5e-9b78-a7f91572e03b",
        "need_restart" : false,
        "sg_id" : "967a0ac2-3cae-4e57-a49a-d0f6ff07dcc1",
        "param_group" : null
      }, {
        "id" : "be254b607c5e4f3d97c4d7886043e5bcno17",
        "name" : "htap-7ef5_be_shard01_node03",
        "type" : "be",
        "status" : "normal",
        "period" : "null",
        "volume" : {
          "type" : "SSD",
          "size" : "50000000000",
          "used" : null,
          "iops" : null
        },
        "cpu" : "4",
        "mem" : "16",
        "datastore" : {
          "id" : "38197973-8895-36ed-b853-52daeefb6d3a",
          "type" : "star-rocks",
          "version" : "3.1.6.0"
        },
        "actions" : [ ],
        "priority" : 1,
        "frozen_flag" : 0,
        "db_port" : 3306,
        "pay_model" : "0",
        "order_id" : null,
        "traffic_ip" : "10.0.0.115",
        "traffic_vip" : "",
        "traffic_ipv6" : "",
        "traffic_vipv6" : "",
        "az_code" : "az",
        "az_description" : "az1",
        "az_type" : "Center",
        "region_code" : "region1",
        "create_at" : 1711421838049,
        "update_at" : 1711421838049,
        "flavor_id" : "de565db8-0a96-37ea-9388-61167624712c",
        "flavor_ref" : "gaussdb.sr-be.xlarge.x86.4",
        "iaas_flavor_ref" : "c6.xlarge.4",
        "max_connections" : "0",
        "vpc_id" : "d5a1a29b-1476-490f-9682-c1a59593e7b0",
        "subnet_id" : "2ce0bc80-bfc5-4d5e-9b78-a7f91572e03b",
        "need_restart" : false,
        "sg_id" : "967a0ac2-3cae-4e57-a49a-d0f6ff07dcc1",
        "param_group" : null
      }, {
        "id" : "c8899a3a68184de6a7fd140028392b27no17",
        "name" : "htap-7ef5_be_shard01_node01",
        "type" : "be",
        "status" : "normal",
        "period" : "null",
        "volume" : {
          "type" : "SSD",
          "size" : "50000000000",
          "used" : null,
          "iops" : null
        },
        "cpu" : "4",
        "mem" : "16",
        "datastore" : {
          "id" : "38197973-8895-36ed-b853-52daeefb6d3a",
          "type" : "star-rocks",
          "version" : "3.1.6.0"
        },
        "actions" : [ ],
        "priority" : 1,
        "frozen_flag" : 0,
        "db_port" : 3306,
        "pay_model" : "0",
        "order_id" : null,
        "traffic_ip" : "10.0.0.17",
        "traffic_vip" : "",
        "traffic_ipv6" : "",
        "traffic_vipv6" : "",
        "az_code" : "az",
        "az_description" : "az1",
        "az_type" : "Center",
        "region_code" : "region1",
        "create_at" : 1711421838049,
        "update_at" : 1711421838049,
        "flavor_id" : "de565db8-0a96-37ea-9388-61167624712c",
        "flavor_ref" : "gaussdb.sr-be.xlarge.x86.4",
        "iaas_flavor_ref" : "c6.xlarge.4",
        "max_connections" : "0",
        "vpc_id" : "d5a1a29b-1476-490f-9682-c1a59593e7b0",
        "subnet_id" : "2ce0bc80-bfc5-4d5e-9b78-a7f91572e03b",
        "need_restart" : false,
        "sg_id" : "967a0ac2-3cae-4e57-a49a-d0f6ff07dcc1",
        "param_group" : null
      } ],
      "group_type_name" : "starrocks",
      "group_node_type" : "be"
    } ],
    "ops_window" : {
      "period" : null,
      "start_time" : "18:00",
      "end_time" : "22:00"
    },
    "tags_info" : {
      "tags" : [ ],
      "sys_tags" : [ {
        "key" : "_sys_enterprise_project_id",
        "value" : "0"
      } ]
    },
    "time_zone" : "UTC+08:00",
    "backup_used_space" : null,
    "az_mode" : "single",
    "enterprise_project_id" : "0",
    "port_info" : {
      "mysql_port" : 3306
    },
    "fe_node_volume_code" : "gaussdb.sr.evs.ultrahighio",
    "be_node_volume_code" : "gaussdb.sr.evs.ultrahighio",
    "fe_node_volume_size" : "50000000000",
    "be_node_volume_size" : "50000000000",
    "support_data_replication" : true,
    "new_version_available" : false,
    "ssl_option" : false,
    "dedicated_resource_id" : null,
    "pay_model" : "0"
  } ]
}