Querying Database Specifications

Function

This API is used to query the database specifications of a specified DB engine version. Before calling this API:

URI

GET /v3/{project_id}/flavors/{database_name}?availability_zone_mode={availability_zone_mode}

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.

database_name

Yes

String

DB engine.

Table 2 Query parameters

Parameter

Mandatory

Type

Description

version_name

No

String

DB version number. To obtain this value, see Querying Version Information About a DB Engine.

Currently, only MySQL 8.0 is supported.

availability_zone_mode

Yes

String

AZ mode. Its value can be single or multi and is case-insensitive.

spec_code

No

String

Specification code.

Request Parameters

Table 3 Request header parameters

Parameter

Mandatory

Type

Description

X-Auth-Token

Yes

String

User token.

X-Language

No

String

Language.

Response Parameters

Status code: 200

Table 4 Response body parameters

Parameter

Type

Description

flavors

Array of MysqlFlavorsInfo objects

DB instance specifications.

Table 5 MysqlFlavorsInfo

Parameter

Type

Description

vcpus

String

Number of vCPUs. For example, the value 1 indicates 1 vCPU.

ram

String

Memory size in GB.

type

String

Specification type. The value can be arm.

id

String

Specification ID. The value must be unique.

spec_code

String

Resource specification code. Its value is same as the value of flavor_ref. For example: gaussdb.mysql.xlarge.arm.8

version_name

String

DB version number.

instance_mode

String

DB instance type. Currently, its value can only be Cluster.

az_status

Map<String,String>

Status of the AZ to which the DB instance specifications belong. Its value can be any of the following:

  • normal: on sale

  • unsupported: not supported

  • sellout: sold out

Status code: 400

Table 6 Response body parameters

Parameter

Type

Description

error_code

String

Error code.

error_msg

String

Error message.

Status code: 500

Table 7 Response body parameters

Parameter

Type

Description

error_code

String

Error code.

error_msg

String

Error message.

Example Request

GET https://gaussdb-mysql.eu-de.otc.t-systems.com/v3/0483b6b16e954cb88930a360d2c4e663/flavors/gaussdb-mysql?version_name=8.0&spec_code=gaussdb.mysql.xlarge.arm.8&availability_zone_mode=single

Example Response

Status code: 200

Success.

{
  "flavors" : [ {
    "vcpus" : "4",
    "ram" : "32",
    "type" : "arm",
    "id" : "3169caaf-6c2f-41d5-aadd-c8fc3d83597e",
    "spec_code" : "gaussdb.mysql.xlarge.arm.8",
    "instance_mode" : "Cluster",
    "version_name" : "8.0",
    "az_status" : {
      "az1" : "normal",
      "az2" : "unsupported"
    }
  } ]
}

Status Code

For details, see Status Codes.

Error Code

For details, see Error Codes.