Select Database Instance
Select
SaaS
Customer Managed
This API returns list of instances for the selected cloud accoun
Query Parameters
- regionId integer
Id of the region, Use select region to get ID. Application for SaaS
- cloudAccountId integer required
Id of the cloud Account
- backupGateways string
Comma separated backupGateway Client IDs. Not needed for direct Cloud Backup
Responses
- 200
OK
- application/json
- Schema
- Example (from schema)
- Example 1
Schema
rdsDBInstances object[]
allocatedStorage integerdbName stringregionName stringreadReplicaSourceDBInstanceIdentifier stringavailabilityZone stringpreferredBackupWindow stringdbInstanceStatus stringsecondaryAvailabilityZone stringengine stringiops integerpubliclyAccessible booleanengineVersion stringmasterUsername stringisMultAZ booleandbInstanceIdentifier stringvpcSecurityGroup stringcharacterSetName stringinstanceCreateTime integerdBInstanceClass stringdbSecurityGroup stringendPoint stringport integerlicenseModel stringpreferredMaintenanceWindow stringbackupRetentionPeriod integerdbSubnetGroup stringautoMinorVersionUpgrade booleanlatestRestorableTime integer
{
"rdsDBInstances": [
{
"allocatedStorage": 0,
"dbName": "string",
"regionName": "string",
"readReplicaSourceDBInstanceIdentifier": "string",
"availabilityZone": "string",
"preferredBackupWindow": "string",
"dbInstanceStatus": "string",
"secondaryAvailabilityZone": "string",
"engine": "string",
"iops": 0,
"publiclyAccessible": true,
"engineVersion": "string",
"masterUsername": "string",
"isMultAZ": true,
"dbInstanceIdentifier": "string",
"vpcSecurityGroup": "string",
"characterSetName": "string",
"instanceCreateTime": 0,
"dBInstanceClass": "string",
"dbSecurityGroup": "string",
"endPoint": "string",
"port": 0,
"licenseModel": "string",
"preferredMaintenanceWindow": "string",
"backupRetentionPeriod": 0,
"dbSubnetGroup": "string",
"autoMinorVersionUpgrade": true,
"latestRestorableTime": 0
}
]
}
{
"rdsDBInstances": [
{
"allocatedStorage": 102400,
"dbName": "mysqltestserver",
"regionName": "eastus",
"readReplicaSourceDBInstanceIdentifier": "",
"availabilityZone": "eastus",
"preferredBackupWindow": "",
"dbInstanceStatus": "Ready",
"secondaryAvailabilityZone": "",
"engine": "mysql",
"iops": -132130768,
"publiclyAccessible": true,
"engineVersion": "8.0",
"masterUsername": "mytest",
"isMultAZ": true,
"dbInstanceIdentifier": "mysqltestserver",
"vpcSecurityGroup": "",
"characterSetName": "",
"instanceCreateTime": 2927956568,
"dBInstanceClass": "",
"dbSecurityGroup": "",
"endPoint": "mysqltestserver.##.###.azure.com",
"port": 3306,
"licenseModel": "",
"preferredMaintenanceWindow": "",
"backupRetentionPeriod": 7,
"dbSubnetGroup": "",
"autoMinorVersionUpgrade": true,
"latestRestorableTime": 3057545024
},
{
"allocatedStorage": 5120,
"dbName": "mysqlcloud1",
"regionName": "eastus",
"readReplicaSourceDBInstanceIdentifier": "",
"availabilityZone": "eastus",
"preferredBackupWindow": "",
"dbInstanceStatus": "Ready",
"secondaryAvailabilityZone": "",
"engine": "mysql",
"iops": -132130768,
"publiclyAccessible": true,
"engineVersion": "5.7",
"masterUsername": "testt",
"isMultAZ": true,
"dbInstanceIdentifier": "mysqlcloud1",
"vpcSecurityGroup": "",
"characterSetName": "",
"instanceCreateTime": 2927956568,
"dBInstanceClass": "",
"dbSecurityGroup": "",
"endPoint": "mysqlcloud1.###.###.azure.com",
"port": 3306,
"licenseModel": "",
"preferredMaintenanceWindow": "",
"backupRetentionPeriod": 7,
"dbSubnetGroup": "",
"autoMinorVersionUpgrade": true,
"latestRestorableTime": 3057545024
}
]
}
Loading...