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

时间:2024-07-01 18:35:51

响应示例

  • 实例列表:
    { 
      "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_328.html