Querying DB Instances

Function

This API is used to query DB instances and their details. Before calling this API:

Learn how to authenticate this API.
Obtain the required region and endpoint.

URI

GET /v3.3/{project_id}/instances?id={id}&name={name}&type={type}&datastore_type={datastore_type}&vpc_id={vpc_id}&subnet_id={subnet_id}&offset={offset}&limit={limit}

**Table 1** URI parameters
Parameter	Mandatory	Type	Description
project_id	Yes	String	Definition Project ID of a tenant in a region. To obtain the value, see Obtaining a Project ID. Constraints N/A Range The value can contain 32 characters. Only letters and digits are allowed. Default Value N/A

**Table 2** Query parameters
Parameter	Mandatory	Type	Description
id	No	String	Definition Instance ID. The asterisk () is reserved for the system. If the instance ID starts with , fuzzy match is performed based on the value following . Otherwise, the exact match is performed based on the instance ID. The value cannot only contain asterisks (). Constraints N/A Range N/A Default Value N/A
name	No	String	Definition Instance name. The asterisk () is reserved for the system. If the instance name starts with , fuzzy match is performed based on the value following . Otherwise, the exact match is performed based on the instance name. The value cannot only contain asterisks (). Constraints N/A Range N/A Default Value N/A
type	No	String	Definition Instance type. The value is case-sensitive. Constraints N/A Range Enterprise (case-sensitive): distributed instances (in the independent deployment) Centralization_standard (case-sensitive): centralized instances. Default Value N/A
datastore_type	No	String	Definition Database type. Its value is case-sensitive and can be GaussDB. Constraints N/A Range GaussDB: GaussDB database. Default Value GaussDB
vpc_id	No	String	Definition VPC ID. Method 1: Log in to the VPC console and query the VPC ID in the VPC details page. Method 2: Query the VPC ID through the VPC API. For details, see Querying VPCs. Method 2: See "Querying VPCs" in Virtual Private Cloud API Reference. Constraints N/A Range N/A Default Value N/A
subnet_id	No	String	Definition Network ID of the subnet. Method 1: Log in to the VPC console and click the target subnet on the Subnets page. You can view the network ID on the displayed page. Method 2: Query the VPC ID through the VPC API. For details, see Querying Subnets. Method 2: See "Querying Subnets" in Virtual Private Cloud API Reference. Constraints N/A Range N/A Default Value N/A
offset	No	Integer	Definition Index offset. If offset is set to N, the query starts from the N + 1 piece of data. If action is set to filter, offset is 0 by default, indicating that the query starts from the first piece of data. Constraints N/A Range 0–2147483647 Default Value 0
limit	No	Integer	Definition Number of records returned by a query. Constraints N/A Range 1–100 Default Value 100
tags	No	Array	Definition Tag key-value pairs of the instance. {key} indicates the tag key. It must be unique and cannot be empty. Each tag key can contain a maximum of 127 Unicode characters. key cannot be an empty string, a space, or left blank. Before using key, delete single-byte character (SBC) spaces before and after it. The value cannot contain the following special characters: +/?#&=,% {value} indicates the tag value, which can be empty. Each tag value can contain a maximum of 255 Unicode characters. Before using value, delete SBC spaces before and after it. The value cannot contain the following special characters: +/?#&=,% If the tag value is left blank, it indicates any_value (querying any value). To query instances with multiple tag key-value pairs, separate the pairs with commas (,). A maximum of 10 key-value pairs are supported. Constraints N/A Range N/A Default Value N/A
charge_mode	No	String	Definition Billing mode. Constraints N/A Range postPaid: pay-per-use billing. prePaid: yearly/monthly billing. Default Value N/A

Request Parameters

None

Response Parameters

**Table 3** Response parameters
Parameter	Type	Description
instances	Array of Table 4 objects	Definition Instance information.
total_count	Integer	Definition Total number of records. Range N/A

**Table 4** instances
Parameter	Type	Description
id	String	Definition Instance ID. Range N/A
name	String	Definition Instance name. Range N/A
status	String	Definition Instance status. Range BUILD: The instance is being created. BUILD_FAILED: The instance creation failed. ACTIVE: The instance is normal. FAILED: The instance is abnormal. FROZEN: The instance is frozen. MODIFYING: The storage is being scaled up or instance specifications are being changed. EXPANDING: Read replicas, CNs, or DN shards are being added to the instance. REBOOTING: The instance is being rebooted. REDUCING: Read replicas are being deleted. UPGRADING: The instance is being upgraded. RESTORING: The instance is being restored. SWITCHOVER: A primary/standby switchover is being performed. MIGRATING: The instance is being migrated. BACKING UP: The instance is being backed up. UPGRADE TO BE OBSERVED: The instance upgrade is in the observation period. MODIFYING DATABASE PORT: The database port is being changed. STORAGE FULL: The instance storage is full. REPAIRING: The instance is being repaired. SHUTDOWN: The instance is stopped.
private_ips	Array of strings	Definition Private IP address list. The value is an empty string until ECSs where CNs of distributed instances are deployed or ECSs where DNs of centralized instances are deployed are created.
public_ips	Array of strings	Definition EIPs bound to the instance. This parameter cannot be left blank after an EIP is bound.
port	Integer	Definition Database port number. Range The GaussDB database port ranges from 1024 to 39998 (excluding the following which are occupied by the system and cannot be used: 2378, 2379, 2380, 4999, 5000, 5999, 6000, 6001, 8097, 8098, 20049, 20050, 21731, and 21732). If this parameter is not specified, the default port number 8000 is used.
type	String	Definition Instance type. The value is case-sensitive. Range Enterprise: distributed instance (enterprise edition) centralization_standard: centralized instance Combined: distributed instance (combined deployment)
ha	Table 5 object	Definition This parameter is returned for distributed and centralized instances.
replica_num	Integer	Definition Number of replicas. Range N/A
region	String	Definition Region where the instance is deployed. Range N/A
datastore	Table 6 object	Definition Database information.
created	String	Definition Creation time in the yyyy-mm-dd hh:mm:ss timezone format. timezone indicates the time zone. When the instance is being created, the value is the time when the creation request is delivered. After the instance is created, the value is the time when the creation is complete, for example, 2024-07-02 08:32:07 UTC. Range N/A
updated	String	Definition Update time. The format is the same as that of the created field. The value is empty when the instance is being created. After the instance is created, the value is not empty. Range N/A
db_user_name	String	Definition Default username. Range N/A
vpc_id	String	Definition VPC ID. Range N/A
subnet_id	String	Definition Network ID of the subnet. Range N/A
security_group_id	String	Definition Security group ID. Range N/A
flavor_ref	String	Definition Specification code. To obtain its value, see the spec_code field in Querying Instance Specifications. Range N/A
flavor_info	Table 8 object	Definition Flavor information.
volume	Table 9 object	Definition Volume information.
switch_strategy	String	Definition Database failover priority. If you do not configure failover priority during instance creation, this parameter will not be displayed. The value can be Reliability or Availability, indicating that the reliability or availability is given priority during the failover, respectively. If no failover priority is selected during the creation, the failover priority is not displayed. Range N/A
backup_strategy	Table 10 object	Definition Backup policy.
maintenance_window	String	Definition Maintenance window, in the UTC format. Range N/A
nodes	Array of Table 11 objects	Definition Instance node information.
disk_encryption_id	String	Definition Disk encryption key ID. This parameter is displayed only when the instance disk is encrypted. Range N/A
enterprise_project_id	String	Definition Enterprise project tag ID. If an instance does not belong to any enterprise project, the default value is 0. Range N/A
instance_mode	String	Definition Instance mode. Range basic: basic edition enterprise: enterprise edition
disk_encryption_id	String	Definition Disk encryption key ID. This parameter is displayed only when the instance disk is encrypted. Range N/A
charge_info	Table 12 object	Definition Billing mode, which can be pay-per-use or yearly/monthly.
time_zone	String	Definition Time zone. Range N/A
tags	Array of Table 13 objects	Definition Tags. This parameter is not returned if there is no tag.
disk_usage	String	Definition Available disk usage of the instance. Range [0–1]. The value can contain four decimal places.
mysql_compatibility	Table 14 mysql_compatibility object	Definition M compatibility configuration of the instance.

**Table 5** ha
Parameter	Type	Description
consistency	String	Definition Database consistency type. It is only suitable for distributed instances. Range strong: strong consistency eventual: eventual consistency
replication_mode	String	Definition Replication mode for the standby instance. Range The value cannot be empty. It can be sync, indicating that data is synchronized in synchronous mode.

**Table 6** datastore
Parameter	Type	Description
type	String	Definition Database engine. Range N/A
version	String	Definition Major version of the database. Range N/A
complete_version	String	Definition Minor version of the database. Range N/A
target_version	String	Definition Target version that the database is being upgraded to. Range N/A
complete_kernel_version	String	Definition Database kernel version. Range N/A
hotfix_version_infos	Array of Table 7 objects	Definition Hot patch information.

**Table 7** hotfix_version_infos
Parameter	Type	Description
version	String	Definition Hot patch version. Range N/A
upgrade_finished_time	String	Definition List of time when the hot patch update is complete. The time when the hot patch update is complete is expressed in the "yyyy-mm-dd hh:mm:ss timezone" format. timezone indicates the time zone. Range N/A

**Table 8** flavor_info
Parameter	Type	Description
vcpu	Integer	Definition Number of vCPUs. Range N/A
mem	Integer	Definition Memory size. Range N/A

**Table 9** volume
Parameter	Type	Description
type	String	Definition Disk type. Range ULTRAHIGH (SSD storage) or ESSD (extreme SSD storage). The value is case-sensitive.
size	Integer	Definition Storage. Range N/A

**Table 10** backup_strategy
Parameter	Type	Description
start_time	String	Definition Backup time window. Automated backups will be created during the backup time window. The time is in the UTC format. Range N/A
keep_days	Integer	Definition Number of days to retain the generated backup files. Range 1–732.

**Table 11** nodes
Parameter	Type	Description
id	String	Definition Node ID. Range N/A
name	String	Definition Node name. Range N/A
role	String	Definition Node type. Range master: primary node slave: standby node secondary: log node readreplica: read replica.
status	String	Definition Node status. Range BUILD_FAILED: The node fails to be created.
availability_zone	String	Definition AZ. Range N/A
private_ip	String	Definition Private IP address of the node. For distributed instances, this parameter is valid only for CNs. For centralized instances, this parameter is valid for all nodes. The parameter value is returned after an ECS is created. Range N/A
public_ip	String	Definition EIP that has been bound. For distributed instances, this parameter is valid only for CNs. For centralized instances, this parameter is valid for all nodes. The parameter value is returned after an ECS is created and an EIP is bound to a DB instance. Range N/A
component_names	String	Definition Component information on the node (for example, component ID:distributed ID). Separate information of multiple components with semicolons (;). Range N/A

**Table 12** charge_info
Parameter	Type	Description
charge_mode	String	Definition Billing mode. Range postPaid: pay-per-use billing. prePaid: yearly/monthly billing.

**Table 13** tags
Parameter	Type	Description
key	String	Definition Tag key. Range N/A
value	String	Definition Tag value. Range N/A

**Table 14** mysql_compatibility
Parameter	Type	Description
port	String	Definition Port for M compatibility. Range N/A

Example Request

Querying instances based on search criteria

GET https://gaussdb-opengauss.ap-southeast-1.myhuaweicloud.com/v3.3/97b026aa9cc4417888c14c84a1ad9860/instances?id=ed7cc6166ec24360a5ed5c5c9c2ed726in14&name=hy&type=Enterprise&datastore_type=GaussDB&vpc_id=19e5d45d-70fd-4a91-87e9-b27e71c9891f&subnet_id=bd51fb45-2dcb-4296-8783-8623bfe89bb7&offset=0&limit=10

Querying all instances

GET https://gaussdb-opengauss.ap-southeast-1.myhuaweicloud.com/v3.3/97b026aa9cc4417888c14c84a1ad9860/instances

Example Response

Instances queried.

{ 
  "instances" : [ { 
    "id" : "b331ed66cc3249f78bc20737308c01f4in14", 
    "status" : "ACTIVE", 
    "name" : "gauss-9e88", 
    "port" : 8000, 
    "type" : "enterprise", 
    "ha" : { 
      "consistency" : "strong", 
      "replication_mode" : "sync" 
    }, 
    "region" : "cn-xianhz-1", 
    "datastore" : { 
      "type" : "GaussDB", 
      "version" : "V2.0-2.7", 
      "complete_version" : "V2.0-2.7.2", 
      "target_version" : "V2.0-3.208.0", 
      "complete_kernel_version" : "V500R002C10SPC610" 
    }, 
    "created" : "2021-01-15 01:46:40 UTC", 
    "updated" : "2021-01-15 02:05:03 UTC", 
    "volume" : { 
      "type" : "ULTRAHIGH", 
      "size" : 120 
    }, 
    "nodes" : [ { 
      "id" : "02ebf757aaf94074855f49cc6e0e4712no14", 
      "name" : "gauss-9e88_gaussdbv5cn_2", 
      "role" : "master", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "cn_5001:" 
    }, { 
      "id" : "0a87b8ecbfeb46aba1409cfc0f0d5c34no14", 
      "name" : "gauss-9e88_gaussdbv5cn_0", 
      "role" : "master", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "cn_5002:" 
    }, { 
      "id" : "2d9fec1ab3834936b074d63acf48b1f2no14", 
      "name" : "gauss-9e88_gaussdbv5dn3_2", 
      "role" : "master", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "dn_6003:60073" 
    }, { 
      "id" : "48bb08a2d635435891ac0caa1c0bf2e3no14", 
      "name" : "gauss-9e88_gaussdbv5dn1_0", 
      "role" : "master", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "dn_6001:60011" 
    }, { 
      "id" : "5df830f652204827ada32f8bc28b107eno14", 
      "name" : "gauss-9e88_gaussdbv5dn1_1", 
      "role" : "slave", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "dn_6002:60011" 
    }, { 
      "id" : "8a97a246cee841b38c5b47290d4c9c38no14", 
      "name" : "gauss-9e88_gaussdbv5cn_1", 
      "role" : "master", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "cn_5003:" 
    }, { 
      "id" : "8c1a3f8eecca4d9e9974a868bb6dd942no14", 
      "name" : "gauss-9e88_gaussdbv5dn2_0", 
      "role" : "master", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "dn_6004:60042" 
    }, { 
      "id" : "9bd0c80b8a684cc9bd7d99dd5adffb07no14", 
      "name" : "gauss-9e88_gaussdbv5dn3_1", 
      "role" : "slave", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "dn_6005:60073" 
    }, { 
      "id" : "9e2a3cd541e249d4af5aa57c5d3a7f39no14", 
      "name" : "gauss-9e88_gaussdbv5dn1_2", 
      "role" : "slave", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "dn_6006:60011" 
    }, { 
      "id" : "b046d28989ec4ae5a1a9ab20fe65f248no14", 
      "name" : "gauss-9e88_gaussdbv5dn2_2", 
      "role" : "slave", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "dn_6007:60042" 
    }, { 
      "id" : "b614cc12fd3742dbb230245f88a7bf00no14", 
      "name" : "gauss-9e88_gaussdbv5dn3_0", 
      "role" : "slave", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "dn_6008:60073" 
    }, { 
      "id" : "caba8e88c3c84ae58202f1f589490611no14", 
      "name" : "gauss-9e88_gaussdbv5dn2_1", 
      "role" : "slave", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "dn_6009:60042" 
    } ], 
    "private_ips" : [ "192.168.28.81 / 192.168.27.52 / 192.168.16.253" ], 
    "public_ips" : [ ], 
    "db_user_name" : "root", 
    "vpc_id" : "5f84a5c4-2f93-41de-8359-d7acedb585cc", 
    "subnet_id" : "300036af-a92f-4e9e-8e9f-7d20e7878b05", 
    "security_group_id" : "2dcfd40a-8f32-46b8-8a47-6cfab5eba163", 
    "flavor_ref" : "gaussdb.opengauss.ee.dn.m6.large.8.in", 
    "flavor_info" : { 
      "vcpu" : 2, 
      "mem" : 16 
    }, 
    "switch_strategy" : "Reliability", 
    "charge_info" : { 
      "charge_mode" : "prePaid" 
    }, 
    "backup_strategy" : { 
      "start_time" : "19:00-20:00", 
      "keep_days" : 7 
    }, 
    "maintenance_window" : "18:00-22:00", 
    "disk_encryption_id" : "24ae42b5-4009-4ea2-b66a-0b211e424dab", 
    "enterprise_project_id" : "6e76681b-a2f5-4c5f-97c5-ba4fd3c0dfb2", 
    "instance_mode" : "enterprise", 
    "time_zone" : "UTC+08:00", 
  
    "disk_usage" : "0.9890", 
    "mysql_compatibility" : { 
      "port" : 3306 
    } 
  }, { 
    "id" : "226b4afcfcc84c86bf1b9cb345d3b00fin14", 
    "status" : "ACTIVE", 
    "name" : "UTS-gauss-ad53-2C3D", 
    "port" : 8000, 
    "type" : "enterprise", 
    "ha" : { 
      "consistency" : "strong", 
      "replication_mode" : "sync" 
    }, 
    "region" : "cn-xianhz-1", 
    "datastore" : { 
      "type" : "GaussDB", 
      "version" : "V2.0-2.7", 
      "complete_version" : "V2.0-2.7.2", 
      "complete_kernel_version" : "V500R002C10SPC610", 
      "target_version" : "V2.0-3.208.0", 
      "hotfix_version_infos" : [ { 
        "version" : "V2.0-2.7.2.1", 
        "upgrade_finished_time" : "2020-12-23 03:21:41 UTC" 
      }, { 
        "version" : "V2.0-2.7.2.2", 
        "upgrade_finished_time" : "2020-12-23 03:22:41 UTC" 
      } ] 
    }, 
    "created" : "2021-01-08 09:18:27 UTC", 
    "updated" : "2021-01-14 13:25:03 UTC", 
    "volume" : { 
      "type" : "ULTRAHIGH", 
      "size" : 120 
    }, 
    "nodes" : [ { 
      "id" : "07538a1def584cee99e2a5685eeab36ano14", 
      "name" : "UTS-gauss-ad53-2C3D_gaussdbv5dn3_1", 
      "role" : "slave", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "dn_6009:60072" 
    }, { 
      "id" : "21f41baba1e2454f82331b7cb5aeabe5no14", 
      "name" : "UTS-gauss-ad53-2C3D_gaussdbv5dn1_2", 
      "role" : "master", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "dn_6008:60042" 
    }, { 
      "id" : "2909771a3b3e4e3998f9388e77d22391no14", 
      "name" : "UTS-gauss-ad53-2C3D_gaussdbv5dn1_0", 
      "role" : "slave", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "dn_6007:60011" 
    }, { 
      "id" : "2bd9a90a5da242a6b0743a7f597f6106no14", 
      "name" : "UTS-gauss-ad53-2C3D_gaussdbv5dn2_2", 
      "role" : "master", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "dn_6006:60042" 
    }, { 
      "id" : "77092f1dadb74d3ea13d28269cdd3590no14", 
      "name" : "UTS-gauss-ad53-2C3D_gaussdbv5dn3_2", 
      "role" : "master", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "dn_6005:60072" 
    }, { 
      "id" : "a46bfaa6d5a24355a60fce7432b964cano14", 
      "name" : "UTS-gauss-ad53-2C3D_gaussdbv5dn3_0", 
      "role" : "slave", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "dn_6004:60072" 
    }, { 
      "id" : "aa5277736f3844e2a7adeb9de529e2b1no14", 
      "name" : "UTS-gauss-ad53-2C3D_gaussdbv5dn2_1", 
      "role" : "slave", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "dn_6003:60042" 
    }, { 
      "id" : "b1d798e4ea7344dfa95032984bc6cfd7no14", 
      "name" : "UTS-gauss-ad53-2C3D_gaussdbv5cn_1", 
      "role" : "master", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "cn_5002:" 
    }, { 
      "id" : "b9a46540186f4c0781eabaa2a79594cbno14", 
      "name" : "UTS-gauss-ad53-2C3D_gaussdbv5dn1_1", 
      "role" : "slave", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "dn_6002:60011" 
    }, { 
      "id" : "d283813030364060ab64371d50294977no14", 
      "name" : "UTS-gauss-ad53-2C3D_gaussdbv5dn2_0", 
      "role" : "slave", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "dn_6001:60042" 
    }, { 
      "id" : "eb7bce29b2284cd290405eaddc1b1a1eno14", 
      "name" : "UTS-gauss-ad53-2C3D_gaussdbv5cn_0", 
      "role" : "master", 
      "status" : "FAILED", 
      "availability_zone" : "az2xahz", 
      "component_names" : "cn_5001:" 
    } ], 
    "private_ips" : [ "192.168.30.44 / 192.168.29.231" ], 
    "public_ips" : [ "10.154.217.248" ], 
    "db_user_name" : "root", 
    "vpc_id" : "5f84a5c4-2f93-41de-8359-d7acedb585cc", 
    "subnet_id" : "300036af-a92f-4e9e-8e9f-7d20e7878b05", 
    "security_group_id" : "2dcfd40a-8f32-46b8-8a47-6cfab5eba163", 
    "flavor_ref" : "gaussdb.opengauss.ee.dn.m6.large.8.in", 
    "flavor_info" : { 
      "vcpu" : 2, 
      "mem" : 16 
    }, 
    "switch_strategy" : "Reliability", 
    "charge_info" : { 
      "charge_mode" : "prePaid" 
    }, 
    "backup_strategy" : { 
      "start_time" : "18:00-19:00", 
      "keep_days" : 7 
    }, 
    "maintenance_window" : "18:00-22:00", 
    "enterprise_project_id" : "0", 
    "instance_mode" : "enterprise", 
    "time_zone" : "UTC+08:00", 
    "disk_usage" : "1.0000", 
    "mysql_compatibility" : { 
      "port" : 3306 
    } 
  }, { 
    "id" : "706c65c3dd7d497ab16f5b3a113690abin14", 
    "status" : "ACTIVE", 
    "name" : "UTS-gauss-7362", 
    "port" : 8000, 
    "type" : "enterprise", 
    "ha" : { 
      "replication_mode" : "sync" 
    }, 
    "region" : "cn-xianhz-1", 
    "datastore" : { 
      "type" : "GaussDB", 
      "version" : "2.7", 
      "complete_version" : "2.7.2", 
      "complete_kernel_version" : "V500R002C10SPC610", 
      "target_version" : "3.208.0", 
      "hotfix_version_infos" : [ { 
        "version" : "2.7.2.1", 
        "upgrade_finished_time" : "2020-12-23 03:21:41 UTC" 
      }, { 
        "version" : "2.7.2.2", 
        "upgrade_finished_time" : "2020-12-23 03:22:41 UTC" 
      } ] 
    }, 
    "created" : "2020-12-23 03:21:41 UTC", 
    "updated" : "2021-01-15 02:32:13 UTC", 
    "volume" : { 
      "type" : "ULTRAHIGH", 
      "size" : 80 
    }, 
    "nodes" : [ { 
      "id" : "25b7f16ee4084b7884d52f1bdfab4e68no14", 
      "name" : "UTS-gauss-7362_gaussdbv5dn1_2", 
      "role" : "master", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "dn_6003:60011" 
    }, { 
      "id" : "ad6f02f31744422fa8ce487e81c9e7afno14", 
      "name" : "UTS-gauss-7362_gaussdbv5cn_0", 
      "role" : "master", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "cn_5001:" 
    }, { 
      "id" : "b30c56582bf44a548e3bb5b5af6c4773no14", 
      "name" : "UTS-gauss-7362_gaussdbv5dn1_1", 
      "role" : "slave", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "dn_6002:60011" 
    }, { 
      "id" : "f79ea0600cba42b2888bd9bd67e52a79no14", 
      "name" : "UTS-gauss-7362_gaussdbv5dn1_0", 
      "role" : "slave", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "dn_6001:60011" 
    } ], 
    "private_ips" : [ "192.168.26.70" ], 
    "public_ips" : [ ], 
  
    "db_user_name" : "root", 
    "vpc_id" : "5f84a5c4-2f93-41de-8359-d7acedb585cc", 
    "subnet_id" : "300036af-a92f-4e9e-8e9f-7d20e7878b05", 
    "security_group_id" : "2dcfd40a-8f32-46b8-8a47-6cfab5eba163", 
    "flavor_ref" : "gaussdb.opengauss.ee.dn.m6.large.8.in", 
    "flavor_info" : { 
      "vcpu" : 2, 
      "mem" : 16 
    }, 
    "switch_strategy" : "Reliability", 
    "charge_info" : { 
      "charge_mode" : "postPaid" 
    }, 
    "backup_strategy" : { 
      "start_time" : "16:00-17:00", 
      "keep_days" : 7 
    }, 
    "maintenance_window" : "18:00-22:00", 
    "enterprise_project_id" : "0", 
    "instance_mode" : "enterprise", 
    "time_zone" : "UTC+08:00", 
    "disk_usage" : "0.9940", 
    "mysql_compatibility" : { 
      "port" : 3306 
    } 
  }, { 
    "id" : "4ad42d079a3948d88c28d6236211b21ein14", 
    "status" : "ACTIVE", 
    "name" : "UTS-gauss-4336", 
    "port" : 8000, 
    "type" : "enterprise", 
    "ha" : { 
      "replication_mode" : "sync" 
    }, 
    "region" : "cn-xianhz-1", 
    "datastore" : { 
      "type" : "GaussDB", 
      "version" : "2.7", 
      "complete_version" : "2.7.2", 
      "complete_kernel_version" : "V500R002C10SPC610", 
      "target_version" : "3.208.0", 
      "hotfix_version_infos" : [ { 
        "version" : "2.7.2.1", 
        "upgrade_finished_time" : "2020-12-23 03:21:41 UTC" 
      }, { 
        "version" : "2.7.2.2", 
        "upgrade_finished_time" : "2020-12-23 03:22:41 UTC" 
      } ] 
    }, 
    "created" : "2020-12-03 14:28:53 UTC", 
    "updated" : "2021-01-14 13:20:10 UTC", 
    "volume" : { 
      "type" : "ULTRAHIGH", 
      "size" : 40 
    }, 
    "nodes" : [ { 
      "id" : "254dbda6f03643519ad64b39481bd11cno14", 
      "name" : "UTS-gauss-4336_gaussdbv5dn1_2", 
      "role" : "master", 
      "status" : "ACTIVE", 
      "availability_zone" : "az1xahz", 
      "component_names" : "dn_6001:60011" 
    }, { 
      "id" : "6ad76d4db26443c2a93b280739a31558no14", 
      "name" : "UTS-gauss-4336_gaussdbv5dn1_1", 
      "role" : "slave", 
      "status" : "ACTIVE", 
      "availability_zone" : "az1xahz", 
      "component_names" : "dn_6002:60011" 
    }, { 
      "id" : "9fdebf821bdf444a8689b19c0ff588ceno14", 
      "name" : "UTS-gauss-4336_gaussdbv5cn_0", 
      "role" : "master", 
      "status" : "FAILED", 
      "availability_zone" : "az1xahz", 
      "component_names" : "cn_5001:" 
    }, { 
      "id" : "dd64bdbc02a542d88823b1582f772d25no14", 
      "name" : "UTS-gauss-4336_gaussdbv5cn_1", 
      "role" : "master", 
      "status" : "ACTIVE", 
      "availability_zone" : "az1xahz", 
      "component_names" : "cn_5002:" 
    }, { 
      "id" : "de3c41461045466faf6c2b96eb709540no14", 
      "name" : "UTS-gauss-4336_gaussdbv5dn1_0", 
      "role" : "slave", 
      "status" : "ACTIVE", 
      "availability_zone" : "az1xahz", 
      "component_names" : "dn_6001:60011" 
    } ], 
    "private_ips" : [ "192.168.30.93 / 192.168.29.232" ], 
    "public_ips" : [ ], 
    "db_user_name" : "root", 
    "vpc_id" : "5f84a5c4-2f93-41de-8359-d7acedb585cc", 
    "subnet_id" : "300036af-a92f-4e9e-8e9f-7d20e7878b05", 
    "security_group_id" : "2dcfd40a-8f32-46b8-8a47-6cfab5eba163", 
    "flavor_ref" : "gaussdb.opengauss.ee.dn.m6.large.8.in", 
    "flavor_info" : { 
      "vcpu" : 2, 
      "mem" : 16 
    }, 
    "switch_strategy" : "Reliability", 
    "charge_info" : { 
      "charge_mode" : "postPaid" 
    }, 
    "backup_strategy" : { 
      "start_time" : "18:00-19:00", 
      "keep_days" : 7 
    }, 
    "maintenance_window" : "18:00-22:00", 
    "enterprise_project_id" : "0", 
    "instance_mode" : "basic", 
    "time_zone" : "UTC+08:00", 
    "disk_usage" : "1.0000", 
    "mysql_compatibility" : { 
      "port" : 3306 
    } 
  } ], 
  "total_count" : 4 
}

Instance details queried.

{ 
  "instances" : [ { 
    "id" : "706c65c3dd7d497ab16f5b3a113690abin14", 
    "status" : "ACTIVE", 
    "name" : "UTS-gauss-7362", 
    "port" : 8000, 
    "type" : "enterprise", 
    "ha" : { 
      "replication_mode" : "sync" 
    }, 
    "region" : "cn-xianhz-1", 
    "datastore" : { 
      "type" : "GaussDB", 
      "version" : "2.7", 
      "complete_version" : "2.7.2", 
      "complete_kernel_version" : "V500R002C10SPC610", 
      "target_version" : "3.208.0", 
      "hotfix_version_infos" : [ { 
        "version" : "2.7.2.1", 
        "upgrade_finished_time" : "2020-12-23 03:21:41 UTC" 
      }, { 
        "version" : "2.7.2.2", 
        "upgrade_finished_time" : "2020-12-23 03:22:41 UTC" 
      } ] 
    }, 
    "created" : "2020-12-23 03:21:41 UTC", 
    "updated" : "2021-01-15 02:32:13 UTC", 
    "volume" : { 
      "type" : "ULTRAHIGH", 
      "size" : 80 
    }, 
    "nodes" : [ { 
      "id" : "25b7f16ee4084b7884d52f1bdfab4e68no14", 
      "name" : "UTS-gauss-7362_gaussdbv5dn1_2", 
      "role" : "master", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "dn_6003:60011" 
    }, { 
      "id" : "ad6f02f31744422fa8ce487e81c9e7afno14", 
      "name" : "UTS-gauss-7362_gaussdbv5cn_0", 
      "role" : "master", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "cn_6004:" 
    }, { 
      "id" : "b30c56582bf44a548e3bb5b5af6c4773no14", 
      "name" : "UTS-gauss-7362_gaussdbv5dn1_1", 
      "role" : "slave", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "dn_6002:60011" 
    }, { 
      "id" : "f79ea0600cba42b2888bd9bd67e52a79no14", 
      "name" : "UTS-gauss-7362_gaussdbv5dn1_0", 
      "role" : "slave", 
      "status" : "ACTIVE", 
      "availability_zone" : "az2xahz", 
      "component_names" : "dn_6001:60011" 
    } ], 
    "private_ips" : [ "192.168.26.70" ], 
    "public_ips" : [ ], 
    "db_user_name" : "root", 
    "vpc_id" : "5f84a5c4-2f93-41de-8359-d7acedb585cc", 
    "subnet_id" : "300036af-a92f-4e9e-8e9f-7d20e7878b05", 
    "security_group_id" : "2dcfd40a-8f32-46b8-8a47-6cfab5eba163", 
    "flavor_ref" : "gaussdb.opengauss.ee.dn.m6.large.8.in", 
    "flavor_info" : { 
      "vcpu" : 2, 
      "mem" : 16 
    }, 
    "switch_strategy" : "Reliability", 
    "charge_info" : { 
      "charge_mode" : "postPaid" 
    }, 
    "backup_strategy" : { 
      "start_time" : "16:00-17:00", 
      "keep_days" : 7 
    }, 
    "maintenance_window" : "18:00-22:00", 
    "disk_encryption_id" : "", 
    "enterprise_project_id" : "0", 
    "instance_mode" : "enterprise", 
    "time_zone" : "UTC+08:00", 
    "disk_usage" : "0.9670" 
  } ], 
  "total_count" : 1 
}