Querying the Storage Type of a Database

Function

This API is used to query the storage type of a specified DB engine version.

URI

  • URI format

    GET https://{Endpoint}/v3/{project_id}/storage-type/{database_name}?version_name={version_name}&ha_mode={ha_mode}

  • Parameter description

    Table 1 Parameter description

    Name

    Mandatory

    Description

    project_id

    Yes

    Specifies the project ID of a tenant in a region.

    For details about how to obtain the project ID, see Obtaining a Project ID.

    database_name

    Yes

    Specifies the DB engine name. Its value can be any of the following and is case-insensitive:

    • MySQL

    • PostgreSQL

    • SQLServer

    version_name

    Yes

    Specifies the database version. For details about how to obtain the database version, see section Querying Version Information About a DB Engine.

    • MySQL databases support 5.7 and 8.0.

    • PostgreSQL databases support 12, 13, 14, 15 and 16.

    • Microsoft SQL Server databases only support 2017_SE, 2017_EE, 2019_SE, 2019_EE, 2022_SE and 2022_EE.

    ha_mode

    No

    Specifies the HA mode. The value options are as follows:

    • single

    • ha

    • replica

Request

Response

  • Normal response

    Table 2 Parameter description

    Name

    Type

    Description

    storage_type

    Array of objects

    Indicates the DB instance specifications information list.

    For details, see Table 3.

    Table 3 storage_type field data structure description

    Name

    Type

    Description

    name

    String

    Indicates the storage type. Its value can be any of the following:

    • COMMON: SATA storage.

    • ULTRAHIGH: ultra-high I/O storage.

    • CLOUDSSD: cloud SSD storage.

    • ESSD: extreme SSD storage.

    az_status

    Map<String, String>

    Indicates the specification status in an AZ. Its value can be any of the following:

    • normal: indicates that the specifications in the AZ are available.

    • unsupported: indicates that the specifications are not supported by the AZ.

    • sellout: indicates that the specifications in the AZ are sold out.

    support_compute_group_type

    List<String>

    Indicates the performance specifications. Its value can be any of the following:

    • normal: general-enhanced

    • general: general-purpose

    • dedicated:

      • For the MySQL DB engine: dedicated

      • For PostgreSQL and SQL Server DB engines: dedicated, which is only supported for cloud SSDs

  • Example normal response

    {
        "storage_type": [{
                "name": "COMMON",
                "az_status": {
                    "az1": "normal",
                    "az2": "normal",
                },
                            "support_compute_group_type": [
                                    "normal",
                                    "general",
                                    "dedicated"
                            ]
            },
            {
                "name": "ULTRAHIGH",
                "az_status": {
                    "az1": "normal",
                    "az2": "normal"
                },
                            "support_compute_group_type": [
                                    "normal",
                                    "general",
                                    "dedicated"
                            ]
            }
        ]
    }
    
  • Abnormal response

    For details, see Abnormal Request Results.

Status Code

Error Code

For details, see Error Codes.