云数据库 GAUSSDB-查询数据库实例列表:响应示例

时间:2024-05-20 09:57:52

响应示例

  • 实例列表:
    {
        "instances": [
            {
                "id": "b331ed66cc3249f78bc20737308c01f4in14",
                "status": "ACTIVE",
                "name": "gauss-9e88",
                "port": 8000,
                "type": "enterprise",
                "ha": {
                    "consistency": "strong",
                    "replication_mode": "sync"
                },
                "region": "aaa",
                "datastore": {
                    "type": "GaussDB",
                    "version": "1.4"
                },
                "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": "bbb"
                    },
                    {
                        "id": "0a87b8ecbfeb46aba1409cfc0f0d5c34no14",
                        "name": "gauss-9e88_gaussdbv5cn_0",
                        "role": "master",
                        "status": "ACTIVE",
                        "availability_zone": "bbb"
                    },
                    {
                        "id": "2d9fec1ab3834936b074d63acf48b1f2no14",
                        "name": "gauss-9e88_gaussdbv5dn3_2",
                        "role": "master",
                        "status": "ACTIVE",
                        "availability_zone": "bbb"
                    },
                    {
                        "id": "48bb08a2d635435891ac0caa1c0bf2e3no14",
                        "name": "gauss-9e88_gaussdbv5dn1_0",
                        "role": "master",
                        "status": "ACTIVE",
                        "availability_zone": "bbb"
                    },
                    {
                        "id": "5df830f652204827ada32f8bc28b107eno14",
                        "name": "gauss-9e88_gaussdbv5dn1_1",
                        "role": "slave",
                        "status": "ACTIVE",
                        "availability_zone": "bbb"
                    },
                    {
                        "id": "8a97a246cee841b38c5b47290d4c9c38no14",
                        "name": "gauss-9e88_gaussdbv5cn_1",
                        "role": "master",
                        "status": "ACTIVE",
                        "availability_zone": "bbb"
                    },
                    {
                        "id": "8c1a3f8eecca4d9e9974a868bb6dd942no14",
                        "name": "gauss-9e88_gaussdbv5dn2_0",
                        "role": "master",
                        "status": "ACTIVE",
                        "availability_zone": "bbb"
                    },
                    {
                        "id": "9bd0c80b8a684cc9bd7d99dd5adffb07no14",
                        "name": "gauss-9e88_gaussdbv5dn3_1",
                        "role": "slave",
                        "status": "ACTIVE",
                        "availability_zone": "bbb"
                    },
                    {
                        "id": "9e2a3cd541e249d4af5aa57c5d3a7f39no14",
                        "name": "gauss-9e88_gaussdbv5dn1_2",
                        "role": "slave",
                        "status": "ACTIVE",
                        "availability_zone": "bbb"
                    },
                    {
                        "id": "b046d28989ec4ae5a1a9ab20fe65f248no14",
                        "name": "gauss-9e88_gaussdbv5dn2_2",
                        "role": "slave",
                        "status": "ACTIVE",
                        "availability_zone": "bbb"
                    },
                    {
                        "id": "b614cc12fd3742dbb230245f88a7bf00no14",
                        "name": "gauss-9e88_gaussdbv5dn3_0",
                        "role": "slave",
                        "status": "ACTIVE",
                        "availability_zone": "bbb"
                    },
                    {
                        "id": "caba8e88c3c84ae58202f1f589490611no14",
                        "name": "gauss-9e88_gaussdbv5dn2_1",
                        "role": "slave",
                        "status": "ACTIVE",
                        "availability_zone": "bbb"
                    }
                ],
                "tags": [],
                "private_ips": [
                    "192.168.28.81 / 192.168.27.52 / 192.168.16.253"
                ],
                "public_ips": [],
                "replice_num": 3,
                "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",
                "related_instance": [],
                "disk_encryption_id": "24ae42b5-4009-4ea2-b66a-0b211e424dab",
                "enterprise_project_id": "6e76681b-a2f5-4c5f-97c5-ba4fd3c0dfb2",
                "time_zone": "UTC+08:00",
                "instance_mode":"enterprise",
                "order_id": "CS2101150917EUW8N"
            },
            {
                "id": "226b4afcfcc84c86bf1b9cb345d3b00fin14",
                "status": "ACTIVE",
                "name": "UTS-gauss-ad53-2C3D",
                "port": 8000,
                "type": "enterprise",
                "ha": {
                    "consistency": "strong",
                    "replication_mode": "sync"
                },
                "region": "aaa",
                "datastore": {
                    "type": "GaussDB",
                    "version": "1.4"
                },
                "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"
                    },
                    {
                        "id": "21f41baba1e2454f82331b7cb5aeabe5no14",
                        "name": "UTS-gauss-ad53-2C3D_gaussdbv5dn1_2",
                        "role": "master",
                        "status": "ACTIVE",
                        "availability_zone": "az2xahz"
                    },
                    {
                        "id": "2909771a3b3e4e3998f9388e77d22391no14",
                        "name": "UTS-gauss-ad53-2C3D_gaussdbv5dn1_0",
                        "role": "slave",
                        "status": "ACTIVE",
                        "availability_zone": "az2xahz"
                    },
                    {
                        "id": "2bd9a90a5da242a6b0743a7f597f6106no14",
                        "name": "UTS-gauss-ad53-2C3D_gaussdbv5dn2_2",
                        "role": "master",
                        "status": "ACTIVE",
                        "availability_zone": "az2xahz"
                    },
                    {
                        "id": "77092f1dadb74d3ea13d28269cdd3590no14",
                        "name": "UTS-gauss-ad53-2C3D_gaussdbv5dn3_2",
                        "role": "master",
                        "status": "ACTIVE",
                        "availability_zone": "az2xahz"
                    },
                    {
                        "id": "a46bfaa6d5a24355a60fce7432b964cano14",
                        "name": "UTS-gauss-ad53-2C3D_gaussdbv5dn3_0",
                        "role": "slave",
                        "status": "ACTIVE",
                        "availability_zone": "az2xahz"
                    },
                    {
                        "id": "aa5277736f3844e2a7adeb9de529e2b1no14",
                        "name": "UTS-gauss-ad53-2C3D_gaussdbv5dn2_1",
                        "role": "slave",
                        "status": "ACTIVE",
                        "availability_zone": "az2xahz"
                    },
                    {
                        "id": "b1d798e4ea7344dfa95032984bc6cfd7no14",
                        "name": "UTS-gauss-ad53-2C3D_gaussdbv5cn_1",
                        "role": "master",
                        "status": "ACTIVE",
                        "availability_zone": "az2xahz"
                    },
                    {
                        "id": "b9a46540186f4c0781eabaa2a79594cbno14",
                        "name": "UTS-gauss-ad53-2C3D_gaussdbv5dn1_1",
                        "role": "slave",
                        "status": "ACTIVE",
                        "availability_zone": "az2xahz"
                    },
                    {
                        "id": "d283813030364060ab64371d50294977no14",
                        "name": "UTS-gauss-ad53-2C3D_gaussdbv5dn2_0",
                        "role": "slave",
                        "status": "ACTIVE",
                        "availability_zone": "az2xahz"
                    },
                    {
                        "id": "eb7bce29b2284cd290405eaddc1b1a1eno14",
                        "name": "UTS-gauss-ad53-2C3D_gaussdbv5cn_0",
                        "role": "master",
                        "status": "FAILED",
                        "availability_zone": "az2xahz"
                    }
                ],
                "tags": [],
                "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",
                "related_instance": [],
                "enterprise_project_id": "0",
                "time_zone": "UTC+08:00",
                "instance_mode":"enterprise",
                "order_id": "CS21010817315KY81"
            },
            {
                "id": "706c65c3dd7d497ab16f5b3a113690abin14",
                "status": "ACTIVE",
                "name": "UTS-gauss-7362",
                "port": 8000,
                "type": "enterprise",
                "ha": {
                    "replication_mode": "sync"
                },
                "region": "cn-xianhz-1",
                "datastore": {
                    "type": "GaussDB",
                    "version": "1.2"
                },
                "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"
                    },
                    {
                        "id": "ad6f02f31744422fa8ce487e81c9e7afno14",
                        "name": "UTS-gauss-7362_gaussdbv5cn_0",
                        "role": "master",
                        "status": "ACTIVE",
                        "availability_zone": "az2xahz"
                    },
                    {
                        "id": "b30c56582bf44a548e3bb5b5af6c4773no14",
                        "name": "UTS-gauss-7362_gaussdbv5dn1_1",
                        "role": "slave",
                        "status": "ACTIVE",
                        "availability_zone": "az2xahz"
                    },
                    {
                        "id": "f79ea0600cba42b2888bd9bd67e52a79no14",
                        "name": "UTS-gauss-7362_gaussdbv5dn1_0",
                        "role": "slave",
                        "status": "ACTIVE",
                        "availability_zone": "az2xahz"
                    }
                ],
                "tags": [],
                "private_ips": [
                    "192.168.26.70"
                ],
                "public_ips": [],
                "replice_num": 3,
                "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",
                "related_instance": [],
                "enterprise_project_id": "0",
                "time_zone": "UTC+08:00",
                "instance_mode":"enterprise",
            },
            {
                "id": "4ad42d079a3948d88c28d6236211b21ein14",
                "status": "ACTIVE",
                "name": "UTS-gauss-4336",
                "port": 8000,
                "type": "enterprise",
                "ha": {
                    "replication_mode": "sync"
                },
                "region": "cn-xianhz-1",
                "datastore": {
                    "type": "GaussDB",
                    "version": "1.4"
                },
                "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"
                    },
                    {
                        "id": "6ad76d4db26443c2a93b280739a31558no14",
                        "name": "UTS-gauss-4336_gaussdbv5dn1_1",
                        "role": "slave",
                        "status": "ACTIVE",
                        "availability_zone": "az1xahz"
                    },
                    {
                        "id": "9fdebf821bdf444a8689b19c0ff588ceno14",
                        "name": "UTS-gauss-4336_gaussdbv5cn_0",
                        "role": "master",
                        "status": "FAILED",
                        "availability_zone": "az1xahz"
                    },
                    {
                        "id": "dd64bdbc02a542d88823b1582f772d25no14",
                        "name": "UTS-gauss-4336_gaussdbv5cn_1",
                        "role": "master",
                        "status": "ACTIVE",
                        "availability_zone": "az1xahz"
                    },
                    {
                        "id": "de3c41461045466faf6c2b96eb709540no14",
                        "name": "UTS-gauss-4336_gaussdbv5dn1_0",
                        "role": "slave",
                        "status": "ACTIVE",
                        "availability_zone": "az1xahz"
                    }
                ],
                "tags": [],
                "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",
                "related_instance": [],
                "enterprise_project_id": "0",
                "time_zone": "UTC+08:00",
                "instance_mode":"enterprise",
            }
        ],
        "total_count": 4
    }
  • 实例详情:
    {
        "instances": [
            {
                "id": "706c65c3dd7d497ab16f5b3a113690abin14",
                "status": "ACTIVE",
                "name": "UTS-gauss-7362",
                "port": 8000,
                "type": "enterprise",
                "ha": {
                    "replication_mode": "sync"
                },
                "region": "aaa",
                "datastore": {
                    "type": "GaussDB",
                    "version": "1.4"
                },
                "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": "bbb"
                    },
                    {
                        "id": "ad6f02f31744422fa8ce487e81c9e7afno14",
                        "name": "UTS-gauss-7362_gaussdbv5cn_0",
                        "role": "master",
                        "status": "ACTIVE",
                        "availability_zone": "bbb"
    ,
                    },
                    {
                        "id": "b30c56582bf44a548e3bb5b5af6c4773no14",
                        "name": "UTS-gauss-7362_gaussdbv5dn1_1",
                        "role": "slave",
                        "status": "ACTIVE",
                        "availability_zone": "bbb"
                    },
                    {
                        "id": "f79ea0600cba42b2888bd9bd67e52a79no14",
                        "name": "UTS-gauss-7362_gaussdbv5dn1_0",
                        "role": "slave",
                        "status": "ACTIVE",
                        "availability_zone": "bbb"
                    }
                ],
                "tags": [],
                "private_ips": [
                    "192.168.26.70 / 192.168.28.81"
                ],
                "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",
                "related_instance": [],
    
                "enterprise_project_id": "0",
                "time_zone": "UTC+08:00"
                "instance_mode":"enterprise",
            }
        ],
        "total_count": 1
    }
support.huaweicloud.com/api-gaussdb/gaussdb_api_146.html