云数据库 GaussDB-查询数据库实例列表(v3.2):响应示例

时间:2025-02-12 15:00:55

响应示例

  • 实例列表:
    {   "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" : "2.7",       "complete_version" : "2.7.2",       "target_version" : "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" : "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" : "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 }
  • 实例详情
    {   "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 }
support.huaweicloud.com/api-gaussdb/gaussdb_api_399.html