Database
DBaaS API Product (1.34.1)
DBaaS API Product.
List available engines.
Returns a list of available engines.
Authorizations:
query Parameters
_offset | integer >= 0 Default: 0 The number of items to skip before starting to collect the result set. |
_limit | integer [ 1 .. 50 ] Default: 10 The maximum number of items per page. |
status | string (EngineStatus) Enum: "ACTIVE" "DEPRECATED" Value referring to engine status. |
Responses
Response samples
- 200
- 400
- 401
- 403
- 422
- 500
{- "meta": {
- "filters": [
- {
- "field": "string",
- "value": "string"
}
], - "page": {
- "offset": 0,
- "limit": 0,
- "count": 0,
- "total": 0,
- "max_limit": 0
}
}, - "results": [
- {
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "engine": "mysql",
- "name": "mysql",
- "version": "5.7",
- "status": "ACTIVE"
}
]
}
Engine detail.
Returns a engine detail.
Authorizations:
path Parameters
engine_id required | string <uuid> (Datastore Id (Deprecated)) Example: 7a11cfc5-f9f8-4fa2-a418-94a423f6a51f Value referring to datastore Id. |
Responses
Response samples
- 200
- 400
- 401
- 403
- 404
- 422
- 500
{- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "engine": "mysql",
- "name": "mysql",
- "version": "5.7",
- "status": "ACTIVE"
}
List available instance types.
Returns a list of available instance types. An instance type is a hardware template that defines the size of RAM and vCPU.
Authorizations:
query Parameters
_offset | integer >= 0 Default: 0 The number of items to skip before starting to collect the result set. |
_limit | integer [ 1 .. 50 ] Default: 10 The maximum number of items per page. |
status | string (Instance Type Status) Default: "ACTIVE" Enum: "ACTIVE" "DEPRECATED" An enumeration. |
engine_id | string <uuid> (Engine Id) Engine Id unique identifier |
Responses
Response samples
- 200
- 400
- 401
- 403
- 422
- 500
{- "meta": {
- "filters": [
- {
- "field": "string",
- "value": "string"
}
], - "page": {
- "offset": 0,
- "limit": 0,
- "count": 0,
- "total": 0,
- "max_limit": 0
}
}, - "results": [
- {
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "name": "i0-c1-r4-d10",
- "label": "cloud-dbaas-bs1.small",
- "vcpu": "1",
- "ram": "4 GB",
- "family_description": "Basic",
- "family_slug": "bs1",
- "size": "Small",
- "sku_source": "BRNE10600101sm",
- "sku_replica": "BRNE10610101sm"
}
]
}
Instance Type detail.
Returns an instance type detail.
Authorizations:
path Parameters
instance_type_id required | string <uuid> (Instance Type Id) Instance Type Unique Id. |
Responses
Response samples
- 200
- 400
- 401
- 403
- 404
- 422
- 500
{- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "name": "i0-c1-r4-d10",
- "label": "cloud-dbaas-bs1.small",
- "vcpu": "1",
- "ram": "4 GB",
- "family_description": "Basic",
- "family_slug": "bs1",
- "size": "Small",
- "sku_source": "BRNE10600101sm",
- "sku_replica": "BRNE10610101sm"
}
List all database instances.
Returns a list of database instances for a x-tenant-id.
Authorizations:
query Parameters
_offset | integer >= 0 Default: 0 The number of items to skip before starting to collect the result set. |
_limit | integer [ 1 .. 25 ] Default: 10 The maximum number of items per page. |
status | string (Instance Status) Enum: "CREATING" "ERROR" "STOPPED" "REBOOT" "PENDING" "RESIZING" "DELETED" "ACTIVE" "STARTING" "STOPPING" "BACKING_UP" "DELETING" "RESTORING" "ERROR_DELETING" "MAINTENANCE" "MAINTENANCE_ERROR" Example: status=ACTIVE Value referring to instance status. |
_expand | string (Instance Expand) Value: "replicas" Instance extra attributes or relations to show with the main query. When available, more than one value can be informed using commas. e.g: |
engine_id | string <uuid> (Engine Id) Value referring to engine Id. |
volume.size | integer (Volume.Size) Value referring to volume size. |
volume.size__gt | integer (Volume.Size Gt) Value referring to volume size greater than. |
volume.size__gte | integer (Volume.Size Gte) Value referring to volume size greater than or equal to. |
volume.size__lt | integer (Volume.Size Lt) Value referring to volume size less than. |
volume.size__lte | integer (Volume.Size Lte) Value referring to volume size less than or equal to. |
Responses
Response samples
- 200
- 400
- 401
- 403
- 422
- 500
{- "meta": {
- "filters": [
- {
- "field": "string",
- "value": "string"
}
], - "page": {
- "offset": 0,
- "limit": 0,
- "count": 0,
- "total": 0,
- "max_limit": 0
}
}, - "results": [
- {
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "name": "mydbinstance",
- "engine_id": "b1d2d00a-6e57-4e4b-9c8e-447d4c2457d0",
- "datastore_id": "1c9da258-8b16-420b-b1ca-dda81ec7ed87",
- "flavor_id": "fa3e89aa-6829-47f5-8bf4-76d57211a9f1",
- "instance_type_id": "b67afca2-5b6f-43dd-b5de-7627dae240c8",
- "volume": {
- "size": 30,
- "type": "CLOUD_NVME"
}, - "addresses": [
- {
- "access": "PRIVATE",
- "type": "IPv4",
- "address": "172.53.10.82"
}
], - "status": "ACTIVE",
- "generation": "G1B",
- "parameters": [
- {
- "name": "LOWER_CASE_TABLE_NAMES",
- "value": 0
}
], - "backup_retention_days": 7,
- "backup_start_at": "04:00:00",
- "created_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z",
- "started_at": "2019-08-24T14:15:22Z",
- "finished_at": "2019-08-24T14:15:22Z",
- "maintenance_scheduled_at": "2019-08-24T14:15:22Z",
- "replicas": [
- {
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "source_id": "ae50a35c-df42-4eff-ba26-f8bc28d2af81",
- "name": "string",
- "engine_id": "b1d2d00a-6e57-4e4b-9c8e-447d4c2457d0",
- "datastore_id": "1c9da258-8b16-420b-b1ca-dda81ec7ed87",
- "instance_type_id": "b67afca2-5b6f-43dd-b5de-7627dae240c8",
- "flavor_id": "fa3e89aa-6829-47f5-8bf4-76d57211a9f1",
- "volume": {
- "size": 30,
- "type": "CLOUD_NVME"
}, - "addresses": [
- {
- "access": "PRIVATE",
- "type": "IPv4",
- "address": "string"
}
], - "status": "ACTIVE",
- "generation": "G1B",
- "parameters": [
- {
- "name": "LOWER_CASE_TABLE_NAMES",
- "value": 0
}
], - "created_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z",
- "started_at": "2019-08-24T14:15:22Z",
- "finished_at": "2019-08-24T14:15:22Z",
- "maintenance_scheduled_at": "2019-08-24T14:15:22Z"
}
]
}
]
}
Creates a new database instance.
Creates a new database instance asynchronously for a tenant.
Authorizations:
Request Body schema: application/jsonrequired
name required | string (Name) <= 100 characters |
engine_id | string <uuid> (Engine Id) |
datastore_id | string <uuid> (Datastore Id (Deprecated)) Deprecated Deprecated: This property is being deprecated in favor of |
flavor_id | string <uuid> (Flavor Id (Deprecated)) Deprecated Deprecated: This property is being deprecated in favor of |
instance_type_id | string <uuid> (Instance Type Id) |
user required | string (User) <= 25 characters |
password required | string (Password) <= 50 characters |
required | object (Instance Volume Request) |
Array of objects (InstanceParametersRequest) Default: [] | |
backup_retention_days | integer (Backup Retention Days) Default: 7 The number of days that a particular backup is kept until its deletion. |
backup_start_at | string <time> (Backup Start At) Default: "04:00:00" Start time (UTC timezone) which is allowed to start the automated backup process. |
Responses
Request samples
- Payload
{- "name": "string",
- "engine_id": "b1d2d00a-6e57-4e4b-9c8e-447d4c2457d0",
- "datastore_id": "1c9da258-8b16-420b-b1ca-dda81ec7ed87",
- "flavor_id": "fa3e89aa-6829-47f5-8bf4-76d57211a9f1",
- "instance_type_id": "b67afca2-5b6f-43dd-b5de-7627dae240c8",
- "user": "string",
- "password": "string",
- "volume": {
- "size": 30,
- "type": "CLOUD_NVME_15K"
}, - "parameters": [ ],
- "backup_retention_days": 7,
- "backup_start_at": "04:00:00"
}
Response samples
- 202
- 400
- 401
- 403
- 422
- 500
{- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08"
}
Database instance details.
Returns a database instance detail.
Authorizations:
path Parameters
instance_id required | string <uuid> (Instance Id) Example: f21999cb-302f-48f7-b584-6a84748e112c Value referring to instance Id. |
query Parameters
_expand | string (Instance Expand) Value: "replicas" Instance extra attributes or relations to show with the main query. When available, more than one value can be informed using commas. e.g: |
Responses
Response samples
- 200
- 400
- 401
- 403
- 404
- 422
- 500
{- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "name": "mydbinstance",
- "engine_id": "b1d2d00a-6e57-4e4b-9c8e-447d4c2457d0",
- "datastore_id": "1c9da258-8b16-420b-b1ca-dda81ec7ed87",
- "flavor_id": "fa3e89aa-6829-47f5-8bf4-76d57211a9f1",
- "instance_type_id": "b67afca2-5b6f-43dd-b5de-7627dae240c8",
- "volume": {
- "size": 30,
- "type": "CLOUD_NVME"
}, - "addresses": [
- {
- "access": "PRIVATE",
- "type": "IPv4",
- "address": "172.53.10.82"
}
], - "status": "ACTIVE",
- "generation": "G1B",
- "parameters": [
- {
- "name": "LOWER_CASE_TABLE_NAMES",
- "value": 0
}
], - "backup_retention_days": 7,
- "backup_start_at": "04:00:00",
- "created_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z",
- "started_at": "2019-08-24T14:15:22Z",
- "finished_at": "2019-08-24T14:15:22Z",
- "maintenance_scheduled_at": "2019-08-24T14:15:22Z",
- "replicas": [
- {
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "source_id": "ae50a35c-df42-4eff-ba26-f8bc28d2af81",
- "name": "string",
- "engine_id": "b1d2d00a-6e57-4e4b-9c8e-447d4c2457d0",
- "datastore_id": "1c9da258-8b16-420b-b1ca-dda81ec7ed87",
- "instance_type_id": "b67afca2-5b6f-43dd-b5de-7627dae240c8",
- "flavor_id": "fa3e89aa-6829-47f5-8bf4-76d57211a9f1",
- "volume": {
- "size": 30,
- "type": "CLOUD_NVME"
}, - "addresses": [
- {
- "access": "PRIVATE",
- "type": "IPv4",
- "address": "string"
}
], - "status": "ACTIVE",
- "generation": "G1B",
- "parameters": [
- {
- "name": "LOWER_CASE_TABLE_NAMES",
- "value": 0
}
], - "created_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z",
- "started_at": "2019-08-24T14:15:22Z",
- "finished_at": "2019-08-24T14:15:22Z",
- "maintenance_scheduled_at": "2019-08-24T14:15:22Z"
}
]
}
Database instance update.
Updates a database instance.
Authorizations:
path Parameters
instance_id required | string <uuid> (Instance Id) Example: f21999cb-302f-48f7-b584-6a84748e112c Value referring to instance Id. |
Request Body schema: application/jsonrequired
status | string (Instance Status Update) Enum: "ACTIVE" "STOPPED" |
backup_retention_days | integer (Backup Retention Days) The number of days that a particular backup is kept until its deletion. |
backup_start_at | string <time> (Backup Start At) Start time (UTC timezone) which is allowed to start the automated backup process. |
Responses
Request samples
- Payload
{- "status": "ACTIVE",
- "backup_retention_days": 7,
- "backup_start_at": "04:00:00"
}
Response samples
- 200
- 400
- 401
- 403
- 404
- 422
- 500
{- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "name": "mydbinstance",
- "engine_id": "b1d2d00a-6e57-4e4b-9c8e-447d4c2457d0",
- "datastore_id": "1c9da258-8b16-420b-b1ca-dda81ec7ed87",
- "flavor_id": "fa3e89aa-6829-47f5-8bf4-76d57211a9f1",
- "instance_type_id": "b67afca2-5b6f-43dd-b5de-7627dae240c8",
- "volume": {
- "size": 30,
- "type": "CLOUD_NVME"
}, - "addresses": [
- {
- "access": "PRIVATE",
- "type": "IPv4",
- "address": "172.53.10.82"
}
], - "status": "ACTIVE",
- "generation": "G1B",
- "parameters": [
- {
- "name": "LOWER_CASE_TABLE_NAMES",
- "value": 0
}
], - "backup_retention_days": 7,
- "backup_start_at": "04:00:00",
- "created_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z",
- "started_at": "2019-08-24T14:15:22Z",
- "finished_at": "2019-08-24T14:15:22Z",
- "maintenance_scheduled_at": "2019-08-24T14:15:22Z",
- "replicas": [
- {
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "source_id": "ae50a35c-df42-4eff-ba26-f8bc28d2af81",
- "name": "string",
- "engine_id": "b1d2d00a-6e57-4e4b-9c8e-447d4c2457d0",
- "datastore_id": "1c9da258-8b16-420b-b1ca-dda81ec7ed87",
- "instance_type_id": "b67afca2-5b6f-43dd-b5de-7627dae240c8",
- "flavor_id": "fa3e89aa-6829-47f5-8bf4-76d57211a9f1",
- "volume": {
- "size": 30,
- "type": "CLOUD_NVME"
}, - "addresses": [
- {
- "access": "PRIVATE",
- "type": "IPv4",
- "address": "string"
}
], - "status": "ACTIVE",
- "generation": "G1B",
- "parameters": [
- {
- "name": "LOWER_CASE_TABLE_NAMES",
- "value": 0
}
], - "created_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z",
- "started_at": "2019-08-24T14:15:22Z",
- "finished_at": "2019-08-24T14:15:22Z",
- "maintenance_scheduled_at": "2019-08-24T14:15:22Z"
}
]
}
Deletes a database instance.
Deletes a database instance.
Authorizations:
path Parameters
instance_id required | string <uuid> (Instance Id) Example: f21999cb-302f-48f7-b584-6a84748e112c Value referring to instance Id. |
Responses
Response samples
- 202
- 400
- 401
- 403
- 404
- 422
- 500
null
Resizes a database instance.
Resizes a database instance.
Authorizations:
path Parameters
instance_id required | string <uuid> (Instance Id) Example: f21999cb-302f-48f7-b584-6a84748e112c Value referring to instance Id. |
Request Body schema: application/jsonrequired
instance_type_id | string <uuid> (Instance Type Id) |
flavor_id | string <uuid> (Flavor Id (Deprecated)) Deprecated Deprecated: This property is being deprecated in favor of |
object (Instance Volume Request) |
Responses
Request samples
- Payload
{- "instance_type_id": "b67afca2-5b6f-43dd-b5de-7627dae240c8",
- "flavor_id": "fa3e89aa-6829-47f5-8bf4-76d57211a9f1",
- "volume": {
- "size": 30,
- "type": "CLOUD_NVME_15K"
}
}
Response samples
- 200
- 400
- 401
- 403
- 404
- 422
- 500
{- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "name": "mydbinstance",
- "engine_id": "b1d2d00a-6e57-4e4b-9c8e-447d4c2457d0",
- "datastore_id": "1c9da258-8b16-420b-b1ca-dda81ec7ed87",
- "flavor_id": "fa3e89aa-6829-47f5-8bf4-76d57211a9f1",
- "instance_type_id": "b67afca2-5b6f-43dd-b5de-7627dae240c8",
- "volume": {
- "size": 30,
- "type": "CLOUD_NVME"
}, - "addresses": [
- {
- "access": "PRIVATE",
- "type": "IPv4",
- "address": "172.53.10.82"
}
], - "status": "ACTIVE",
- "generation": "G1B",
- "parameters": [
- {
- "name": "LOWER_CASE_TABLE_NAMES",
- "value": 0
}
], - "backup_retention_days": 7,
- "backup_start_at": "04:00:00",
- "created_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z",
- "started_at": "2019-08-24T14:15:22Z",
- "finished_at": "2019-08-24T14:15:22Z",
- "maintenance_scheduled_at": "2019-08-24T14:15:22Z",
- "replicas": [
- {
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "source_id": "ae50a35c-df42-4eff-ba26-f8bc28d2af81",
- "name": "string",
- "engine_id": "b1d2d00a-6e57-4e4b-9c8e-447d4c2457d0",
- "datastore_id": "1c9da258-8b16-420b-b1ca-dda81ec7ed87",
- "instance_type_id": "b67afca2-5b6f-43dd-b5de-7627dae240c8",
- "flavor_id": "fa3e89aa-6829-47f5-8bf4-76d57211a9f1",
- "volume": {
- "size": 30,
- "type": "CLOUD_NVME"
}, - "addresses": [
- {
- "access": "PRIVATE",
- "type": "IPv4",
- "address": "string"
}
], - "status": "ACTIVE",
- "generation": "G1B",
- "parameters": [
- {
- "name": "LOWER_CASE_TABLE_NAMES",
- "value": 0
}
], - "created_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z",
- "started_at": "2019-08-24T14:15:22Z",
- "finished_at": "2019-08-24T14:15:22Z",
- "maintenance_scheduled_at": "2019-08-24T14:15:22Z"
}
]
}
Starts a database instance.
Starts a database instance.
Authorizations:
path Parameters
instance_id required | string <uuid> (Instance Id) Example: f21999cb-302f-48f7-b584-6a84748e112c Value referring to instance Id. |
Responses
Response samples
- 200
- 400
- 401
- 403
- 404
- 422
- 500
{- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "name": "mydbinstance",
- "engine_id": "b1d2d00a-6e57-4e4b-9c8e-447d4c2457d0",
- "datastore_id": "1c9da258-8b16-420b-b1ca-dda81ec7ed87",
- "flavor_id": "fa3e89aa-6829-47f5-8bf4-76d57211a9f1",
- "instance_type_id": "b67afca2-5b6f-43dd-b5de-7627dae240c8",
- "volume": {
- "size": 30,
- "type": "CLOUD_NVME"
}, - "addresses": [
- {
- "access": "PRIVATE",
- "type": "IPv4",
- "address": "172.53.10.82"
}
], - "status": "ACTIVE",
- "generation": "G1B",
- "parameters": [
- {
- "name": "LOWER_CASE_TABLE_NAMES",
- "value": 0
}
], - "backup_retention_days": 7,
- "backup_start_at": "04:00:00",
- "created_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z",
- "started_at": "2019-08-24T14:15:22Z",
- "finished_at": "2019-08-24T14:15:22Z",
- "maintenance_scheduled_at": "2019-08-24T14:15:22Z",
- "replicas": [
- {
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "source_id": "ae50a35c-df42-4eff-ba26-f8bc28d2af81",
- "name": "string",
- "engine_id": "b1d2d00a-6e57-4e4b-9c8e-447d4c2457d0",
- "datastore_id": "1c9da258-8b16-420b-b1ca-dda81ec7ed87",
- "instance_type_id": "b67afca2-5b6f-43dd-b5de-7627dae240c8",
- "flavor_id": "fa3e89aa-6829-47f5-8bf4-76d57211a9f1",
- "volume": {
- "size": 30,
- "type": "CLOUD_NVME"
}, - "addresses": [
- {
- "access": "PRIVATE",
- "type": "IPv4",
- "address": "string"
}
], - "status": "ACTIVE",
- "generation": "G1B",
- "parameters": [
- {
- "name": "LOWER_CASE_TABLE_NAMES",
- "value": 0
}
], - "created_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z",
- "started_at": "2019-08-24T14:15:22Z",
- "finished_at": "2019-08-24T14:15:22Z",
- "maintenance_scheduled_at": "2019-08-24T14:15:22Z"
}
]
}
Stops a database instance.
Stops a database instance.
Authorizations:
path Parameters
instance_id required | string <uuid> (Instance Id) Example: f21999cb-302f-48f7-b584-6a84748e112c Value referring to instance Id. |
Responses
Response samples
- 200
- 400
- 401
- 403
- 404
- 422
- 500
{- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "name": "mydbinstance",
- "engine_id": "b1d2d00a-6e57-4e4b-9c8e-447d4c2457d0",
- "datastore_id": "1c9da258-8b16-420b-b1ca-dda81ec7ed87",
- "flavor_id": "fa3e89aa-6829-47f5-8bf4-76d57211a9f1",
- "instance_type_id": "b67afca2-5b6f-43dd-b5de-7627dae240c8",
- "volume": {
- "size": 30,
- "type": "CLOUD_NVME"
}, - "addresses": [
- {
- "access": "PRIVATE",
- "type": "IPv4",
- "address": "172.53.10.82"
}
], - "status": "ACTIVE",
- "generation": "G1B",
- "parameters": [
- {
- "name": "LOWER_CASE_TABLE_NAMES",
- "value": 0
}
], - "backup_retention_days": 7,
- "backup_start_at": "04:00:00",
- "created_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z",
- "started_at": "2019-08-24T14:15:22Z",
- "finished_at": "2019-08-24T14:15:22Z",
- "maintenance_scheduled_at": "2019-08-24T14:15:22Z",
- "replicas": [
- {
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "source_id": "ae50a35c-df42-4eff-ba26-f8bc28d2af81",
- "name": "string",
- "engine_id": "b1d2d00a-6e57-4e4b-9c8e-447d4c2457d0",
- "datastore_id": "1c9da258-8b16-420b-b1ca-dda81ec7ed87",
- "instance_type_id": "b67afca2-5b6f-43dd-b5de-7627dae240c8",
- "flavor_id": "fa3e89aa-6829-47f5-8bf4-76d57211a9f1",
- "volume": {
- "size": 30,
- "type": "CLOUD_NVME"
}, - "addresses": [
- {
- "access": "PRIVATE",
- "type": "IPv4",
- "address": "string"
}
], - "status": "ACTIVE",
- "generation": "G1B",
- "parameters": [
- {
- "name": "LOWER_CASE_TABLE_NAMES",
- "value": 0
}
], - "created_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z",
- "started_at": "2019-08-24T14:15:22Z",
- "finished_at": "2019-08-24T14:15:22Z",
- "maintenance_scheduled_at": "2019-08-24T14:15:22Z"
}
]
}
Backups List.
List all backups.
Authorizations:
path Parameters
instance_id required | string <uuid> (Instance Id) Example: f21999cb-302f-48f7-b584-6a84748e112c Value referring to instance Id. |
query Parameters
_offset | integer >= 0 Default: 0 The number of items to skip before starting to collect the result set. |
_limit | integer [ 1 .. 50 ] Default: 10 The maximum number of items per page. |
type | string (Backup Type) Enum: "ON_DEMAND" "AUTOMATED" Value referring to backup type. |
mode | string (Backup Mode) Enum: "FULL" "INCREMENTAL" Value referring to backup mode. |
status | string (Backup Status) Enum: "PENDING" "CREATING" "CREATED" "ERROR" "DELETING" "DELETED" "ERROR_DELETING" Value referring to backup status. |
Responses
Response samples
- 200
- 400
- 401
- 403
- 422
- 500
{- "meta": {
- "filters": [
- {
- "field": "string",
- "value": "string"
}
], - "page": {
- "offset": 0,
- "limit": 0,
- "count": 0,
- "total": 0,
- "max_limit": 0
}
}, - "results": [
- {
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "instance_id": "06587974-2dbe-4e10-8bf9-38cce0f5a366",
- "instance": {
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "name": "mydbinstance"
}, - "name": "string",
- "location": "string",
- "type": "ON_DEMAND",
- "status": "PENDING",
- "mode": "FULL",
- "db_size": 0,
- "size": 0,
- "started_at": "2019-08-24T14:15:22Z",
- "finished_at": "2019-08-24T14:15:22Z",
- "created_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z",
- "engine_id": "b1d2d00a-6e57-4e4b-9c8e-447d4c2457d0"
}
]
}
Backup Create.
Creates a new backup asynchronously.
Authorizations:
path Parameters
instance_id required | string <uuid> (Instance Id) Example: f21999cb-302f-48f7-b584-6a84748e112c Value referring to instance Id. |
Request Body schema: application/jsonrequired
mode required | string (Backup Mode Request) Value: "FULL" An enumeration. |
Responses
Request samples
- Payload
{- "mode": "FULL"
}
Response samples
- 202
- 400
- 401
- 403
- 404
- 422
- 500
{- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08"
}
Backup Detail.
Get a backup detail.
Authorizations:
path Parameters
instance_id required | string <uuid> (Instance Id) Example: f21999cb-302f-48f7-b584-6a84748e112c Value referring to instance Id. |
backup_id required | string <uuid> (Backup Id) Example: 1b65c0e4-94a1-4385-aedb-c1b34f6e8935 Value referring to backup Id. |
Responses
Response samples
- 200
- 400
- 401
- 403
- 404
- 422
- 500
{- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "instance_id": "06587974-2dbe-4e10-8bf9-38cce0f5a366",
- "instance": {
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "name": "mydbinstance"
}, - "name": "string",
- "location": "string",
- "type": "ON_DEMAND",
- "status": "PENDING",
- "mode": "FULL",
- "db_size": 0,
- "size": 0,
- "started_at": "2019-08-24T14:15:22Z",
- "finished_at": "2019-08-24T14:15:22Z",
- "created_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z",
- "engine_id": "b1d2d00a-6e57-4e4b-9c8e-447d4c2457d0"
}
Delete Backup.
Deletes a database backup.
Authorizations:
path Parameters
instance_id required | string <uuid> (Instance Id) Example: f21999cb-302f-48f7-b584-6a84748e112c Value referring to instance Id. |
backup_id required | string <uuid> (Backup Id) Example: 1b65c0e4-94a1-4385-aedb-c1b34f6e8935 Value referring to backup Id. |
Responses
Response samples
- 202
- 400
- 401
- 403
- 404
- 422
- 500
null
Backup restore.
Restores a backup for an instance asynchronously.
Authorizations:
path Parameters
instance_id required | string <uuid> (Instance Id) Example: f21999cb-302f-48f7-b584-6a84748e112c Value referring to instance Id. |
Request Body schema: application/jsonrequired
backup_id required | string <uuid> (Backup Id) |
Responses
Request samples
- Payload
{- "backup_id": "dc6df094-e377-4015-b87b-a5d80b7a0935"
}
Response samples
- 202
- 400
- 401
- 403
- 404
- 422
- 500
{- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08"
}
Snapshots List.
List all snapshots.
Authorizations:
path Parameters
instance_id required | string <uuid> (Instance Id) Example: f21999cb-302f-48f7-b584-6a84748e112c Value referring to instance Id. |
query Parameters
_offset | integer >= 0 Default: 0 The number of items to skip before starting to collect the result set. |
_limit | integer [ 1 .. 50 ] Default: 10 The maximum number of items per page. |
type | string (Backup Type) Enum: "ON_DEMAND" "AUTOMATED" Value referring to snapshot type. |
status | string (Snapshot Status) Enum: "PENDING" "CREATING" "AVAILABLE" "RESTORING" "ERROR" "DELETING" "DELETED" Value referring to snapshot status. |
Responses
Response samples
- 200
- 400
- 401
- 403
- 422
- 500
{- "meta": {
- "filters": [
- {
- "field": "string",
- "value": "string"
}
], - "page": {
- "offset": 0,
- "limit": 0,
- "count": 0,
- "total": 0,
- "max_limit": 0
}
}, - "results": [
- {
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "instance": {
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "name": "mydbinstance"
}, - "name": "string",
- "description": "string",
- "type": "ON_DEMAND",
- "status": "PENDING",
- "allocated_size": 0,
- "created_at": "2019-08-24T14:15:22Z",
- "started_at": "2019-08-24T14:15:22Z",
- "finished_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z"
}
]
}
Snapshot Create.
Creates a new snapshot asynchronously.
Authorizations:
path Parameters
instance_id required | string <uuid> (Instance Id) Example: f21999cb-302f-48f7-b584-6a84748e112c Value referring to instance Id. |
Request Body schema: application/jsonrequired
name required | string (Name) <= 100 characters Snapshot unique name. |
description required | string (Description) <= 255 characters Snapshot description. |
Responses
Request samples
- Payload
{- "name": "mysnapshot",
- "description": "mydescription"
}
Response samples
- 202
- 400
- 401
- 403
- 404
- 422
- 500
{- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08"
}
Snapshot Detail.
Get a snapshot detail.
Authorizations:
path Parameters
instance_id required | string <uuid> (Instance Id) Example: f21999cb-302f-48f7-b584-6a84748e112c Value referring to instance Id. |
snapshot_id required | string <uuid> (Snapshot Id) Example: c1b34f6e-94a1-4385-aedb-1b65c0e48935 Value referring to snapshot Id. |
Responses
Response samples
- 200
- 400
- 401
- 403
- 404
- 422
- 500
{- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "instance": {
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "name": "mydbinstance"
}, - "name": "string",
- "description": "string",
- "type": "ON_DEMAND",
- "status": "PENDING",
- "allocated_size": 0,
- "created_at": "2019-08-24T14:15:22Z",
- "started_at": "2019-08-24T14:15:22Z",
- "finished_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z"
}
Snapshot Update.
Updates a snapshot.
Authorizations:
path Parameters
instance_id required | string <uuid> (Instance Id) Example: f21999cb-302f-48f7-b584-6a84748e112c Value referring to instance Id. |
snapshot_id required | string <uuid> (Snapshot Id) Example: c1b34f6e-94a1-4385-aedb-1b65c0e48935 Value referring to snapshot Id. |
Request Body schema: application/jsonrequired
name | string (Name) <= 100 characters Snapshot unique name. |
description | string (Description) <= 255 characters Snapshot description. |
Responses
Request samples
- Payload
{- "name": "mysnapshotupdated",
- "description": "mydescriptionupdated"
}
Response samples
- 200
- 400
- 401
- 403
- 404
- 422
- 500
{- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "instance": {
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "name": "mydbinstance"
}, - "name": "string",
- "description": "string",
- "type": "ON_DEMAND",
- "status": "PENDING",
- "allocated_size": 0,
- "created_at": "2019-08-24T14:15:22Z",
- "started_at": "2019-08-24T14:15:22Z",
- "finished_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z"
}
Delete Snapshot.
Deletes a database snapshot.
Authorizations:
path Parameters
instance_id required | string <uuid> (Instance Id) Example: f21999cb-302f-48f7-b584-6a84748e112c Value referring to instance Id. |
snapshot_id required | string <uuid> (Snapshot Id) Example: c1b34f6e-94a1-4385-aedb-1b65c0e48935 Value referring to snapshot Id. |
Responses
Response samples
- 202
- 400
- 401
- 403
- 404
- 422
- 500
null
Backups List.
List all backups.
Authorizations:
query Parameters
_offset | integer >= 0 Default: 0 The number of items to skip before starting to collect the result set. |
_limit | integer [ 1 .. 50 ] Default: 10 The maximum number of items per page. |
type | string (Backup Type) Enum: "ON_DEMAND" "AUTOMATED" Value referring to backup type. |
mode | string (Backup Mode) Enum: "FULL" "INCREMENTAL" Value referring to backup mode. |
status | string (Backup Status) Enum: "PENDING" "CREATING" "CREATED" "ERROR" "DELETING" "DELETED" "ERROR_DELETING" Value referring to backup status. |
instance_id | string <uuid> (Instance Id) Example: instance_id=f21999cb-302f-48f7-b584-6a84748e112c Value referring to instance Id. |
Responses
Response samples
- 200
- 400
- 401
- 403
- 422
- 500
{- "meta": {
- "filters": [
- {
- "field": "string",
- "value": "string"
}
], - "page": {
- "offset": 0,
- "limit": 0,
- "count": 0,
- "total": 0,
- "max_limit": 0
}
}, - "results": [
- {
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "instance_id": "06587974-2dbe-4e10-8bf9-38cce0f5a366",
- "instance": {
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "name": "mydbinstance"
}, - "name": "string",
- "location": "string",
- "type": "ON_DEMAND",
- "status": "PENDING",
- "mode": "FULL",
- "db_size": 0,
- "size": 0,
- "started_at": "2019-08-24T14:15:22Z",
- "finished_at": "2019-08-24T14:15:22Z",
- "created_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z",
- "engine_id": "b1d2d00a-6e57-4e4b-9c8e-447d4c2457d0"
}
]
}
Backup Detail.
Get a backup detail.
Authorizations:
path Parameters
backup_id required | string <uuid> (Backup Id) Example: 1b65c0e4-94a1-4385-aedb-c1b34f6e8935 Value referring to backup Id. |
Responses
Response samples
- 200
- 400
- 401
- 403
- 404
- 422
- 500
{- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "instance_id": "06587974-2dbe-4e10-8bf9-38cce0f5a366",
- "instance": {
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "name": "mydbinstance"
}, - "name": "string",
- "location": "string",
- "type": "ON_DEMAND",
- "status": "PENDING",
- "mode": "FULL",
- "db_size": 0,
- "size": 0,
- "started_at": "2019-08-24T14:15:22Z",
- "finished_at": "2019-08-24T14:15:22Z",
- "created_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z",
- "engine_id": "b1d2d00a-6e57-4e4b-9c8e-447d4c2457d0"
}
Replicas List.
List all replicas for a given instance.
Authorizations:
query Parameters
source_id | string <uuid> (Source Id) Example: source_id=9959ee7a-0710-4faa-9f10-6845819e8ac0 Value referring to source Id. |
_offset | integer >= 0 Default: 0 The number of items to skip before starting to collect the result set. |
_limit | integer [ 1 .. 50 ] Default: 10 The maximum number of items per page. |
Responses
Response samples
- 200
- 400
- 401
- 403
- 404
- 422
- 500
{- "meta": {
- "filters": [
- {
- "field": "string",
- "value": "string"
}
], - "page": {
- "offset": 0,
- "limit": 0,
- "count": 0,
- "total": 0,
- "max_limit": 0
}
}, - "results": [
- {
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "source_id": "ae50a35c-df42-4eff-ba26-f8bc28d2af81",
- "name": "string",
- "engine_id": "b1d2d00a-6e57-4e4b-9c8e-447d4c2457d0",
- "datastore_id": "1c9da258-8b16-420b-b1ca-dda81ec7ed87",
- "instance_type_id": "b67afca2-5b6f-43dd-b5de-7627dae240c8",
- "flavor_id": "fa3e89aa-6829-47f5-8bf4-76d57211a9f1",
- "volume": {
- "size": 30,
- "type": "CLOUD_NVME"
}, - "addresses": [
- {
- "access": "PRIVATE",
- "type": "IPv4",
- "address": "string"
}
], - "status": "ACTIVE",
- "generation": "G1B",
- "parameters": [
- {
- "name": "LOWER_CASE_TABLE_NAMES",
- "value": 0
}
], - "created_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z",
- "started_at": "2019-08-24T14:15:22Z",
- "finished_at": "2019-08-24T14:15:22Z",
- "maintenance_scheduled_at": "2019-08-24T14:15:22Z"
}
]
}
Replica Create.
Creates a new replica for an instance asynchronously.
Authorizations:
Request Body schema: application/jsonrequired
source_id required | string <uuid> (Source Id) |
name required | string (Name) <= 255 characters |
flavor_id | string <uuid> Deprecated Flavor Id (Deprecated).
Deprecated: This property is being deprecated in favor of |
instance_type_id | string <uuid> (Instance Type Id) |
Responses
Request samples
- Payload
{- "source_id": "ae50a35c-df42-4eff-ba26-f8bc28d2af81",
- "name": "string",
- "flavor_id": "fa3e89aa-6829-47f5-8bf4-76d57211a9f1",
- "instance_type_id": "b67afca2-5b6f-43dd-b5de-7627dae240c8"
}
Response samples
- 202
- 400
- 401
- 403
- 404
- 422
- 500
{- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08"
}
Replica Detail.
Get an instance replica detail.
Authorizations:
path Parameters
replica_id required | string <uuid> (Replica Id) Example: 2218ad95-6ba2-4fef-8302-a31cb1062412 Value referring to replica Id. |
Responses
Response samples
- 200
- 400
- 401
- 403
- 404
- 422
- 500
{- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "source_id": "ae50a35c-df42-4eff-ba26-f8bc28d2af81",
- "name": "string",
- "engine_id": "b1d2d00a-6e57-4e4b-9c8e-447d4c2457d0",
- "datastore_id": "1c9da258-8b16-420b-b1ca-dda81ec7ed87",
- "instance_type_id": "b67afca2-5b6f-43dd-b5de-7627dae240c8",
- "flavor_id": "fa3e89aa-6829-47f5-8bf4-76d57211a9f1",
- "volume": {
- "size": 30,
- "type": "CLOUD_NVME"
}, - "addresses": [
- {
- "access": "PRIVATE",
- "type": "IPv4",
- "address": "string"
}
], - "status": "ACTIVE",
- "generation": "G1B",
- "parameters": [
- {
- "name": "LOWER_CASE_TABLE_NAMES",
- "value": 0
}
], - "created_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z",
- "started_at": "2019-08-24T14:15:22Z",
- "finished_at": "2019-08-24T14:15:22Z",
- "maintenance_scheduled_at": "2019-08-24T14:15:22Z"
}
Deletes a replica instance.
Deletes a replica instance.
Authorizations:
path Parameters
replica_id required | string <uuid> (Database Replica Id) Database Replica Unique Id |
Responses
Response samples
- 400
- 401
- 403
- 404
- 422
- 500
{- "slug": "bad_request",
- "message": "Bad request"
}
Replica Resize.
Resize an instance replica.
Authorizations:
path Parameters
replica_id required | string <uuid> (Replica Id) Example: 2218ad95-6ba2-4fef-8302-a31cb1062412 Value referring to replica Id. |
Request Body schema: application/jsonrequired
instance_type_id | string <uuid> (Instance Type Id) |
flavor_id | string <uuid> (Flavor Id) Deprecated |
Responses
Request samples
- Payload
{- "instance_type_id": "b67afca2-5b6f-43dd-b5de-7627dae240c8",
- "flavor_id": "fa3e89aa-6829-47f5-8bf4-76d57211a9f1"
}
Response samples
- 200
- 400
- 401
- 403
- 404
- 422
- 500
{- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "source_id": "ae50a35c-df42-4eff-ba26-f8bc28d2af81",
- "name": "string",
- "engine_id": "b1d2d00a-6e57-4e4b-9c8e-447d4c2457d0",
- "datastore_id": "1c9da258-8b16-420b-b1ca-dda81ec7ed87",
- "instance_type_id": "b67afca2-5b6f-43dd-b5de-7627dae240c8",
- "flavor_id": "fa3e89aa-6829-47f5-8bf4-76d57211a9f1",
- "volume": {
- "size": 30,
- "type": "CLOUD_NVME"
}, - "addresses": [
- {
- "access": "PRIVATE",
- "type": "IPv4",
- "address": "string"
}
], - "status": "ACTIVE",
- "generation": "G1B",
- "parameters": [
- {
- "name": "LOWER_CASE_TABLE_NAMES",
- "value": 0
}
], - "created_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z",
- "started_at": "2019-08-24T14:15:22Z",
- "finished_at": "2019-08-24T14:15:22Z",
- "maintenance_scheduled_at": "2019-08-24T14:15:22Z"
}
Replica Start.
Start an instance replica.
Authorizations:
path Parameters
replica_id required | string <uuid> (Replica Id) Example: 2218ad95-6ba2-4fef-8302-a31cb1062412 Value referring to replica Id. |
Responses
Response samples
- 200
- 400
- 401
- 403
- 404
- 422
- 500
{- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "source_id": "ae50a35c-df42-4eff-ba26-f8bc28d2af81",
- "name": "string",
- "engine_id": "b1d2d00a-6e57-4e4b-9c8e-447d4c2457d0",
- "datastore_id": "1c9da258-8b16-420b-b1ca-dda81ec7ed87",
- "instance_type_id": "b67afca2-5b6f-43dd-b5de-7627dae240c8",
- "flavor_id": "fa3e89aa-6829-47f5-8bf4-76d57211a9f1",
- "volume": {
- "size": 30,
- "type": "CLOUD_NVME"
}, - "addresses": [
- {
- "access": "PRIVATE",
- "type": "IPv4",
- "address": "string"
}
], - "status": "ACTIVE",
- "generation": "G1B",
- "parameters": [
- {
- "name": "LOWER_CASE_TABLE_NAMES",
- "value": 0
}
], - "created_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z",
- "started_at": "2019-08-24T14:15:22Z",
- "finished_at": "2019-08-24T14:15:22Z",
- "maintenance_scheduled_at": "2019-08-24T14:15:22Z"
}
Replica Stop.
Stop an instance replica.
Authorizations:
path Parameters
replica_id required | string <uuid> (Replica Id) Example: 2218ad95-6ba2-4fef-8302-a31cb1062412 Value referring to replica Id. |
Responses
Response samples
- 200
- 400
- 401
- 403
- 404
- 422
- 500
{- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "source_id": "ae50a35c-df42-4eff-ba26-f8bc28d2af81",
- "name": "string",
- "engine_id": "b1d2d00a-6e57-4e4b-9c8e-447d4c2457d0",
- "datastore_id": "1c9da258-8b16-420b-b1ca-dda81ec7ed87",
- "instance_type_id": "b67afca2-5b6f-43dd-b5de-7627dae240c8",
- "flavor_id": "fa3e89aa-6829-47f5-8bf4-76d57211a9f1",
- "volume": {
- "size": 30,
- "type": "CLOUD_NVME"
}, - "addresses": [
- {
- "access": "PRIVATE",
- "type": "IPv4",
- "address": "string"
}
], - "status": "ACTIVE",
- "generation": "G1B",
- "parameters": [
- {
- "name": "LOWER_CASE_TABLE_NAMES",
- "value": 0
}
], - "created_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z",
- "started_at": "2019-08-24T14:15:22Z",
- "finished_at": "2019-08-24T14:15:22Z",
- "maintenance_scheduled_at": "2019-08-24T14:15:22Z"
}
Create a new instance from snapshot asynchronously.
Create a new instance from snapshot.
Authorizations:
path Parameters
snapshot_id required | string <uuid> (Snapshot Id) Example: c1b34f6e-94a1-4385-aedb-1b65c0e48935 Value referring to snapshot Id. |
Request Body schema: application/jsonrequired
name required | string (Name) <= 100 characters |
instance_type_id required | string <uuid> (Instance Type Id) |
object (Instance Volume Request) | |
backup_retention_days | integer (Backup Retention Days) Default: 7 The number of days that a particular backup is kept until its deletion. |
backup_start_at | string <time> (Backup Start At) Default: "04:00:00" Start time (UTC timezone) which is allowed to start the automated backup process. |
Responses
Request samples
- Payload
{- "name": "string",
- "instance_type_id": "b67afca2-5b6f-43dd-b5de-7627dae240c8",
- "volume": {
- "size": 30,
- "type": "CLOUD_NVME_15K"
}, - "backup_retention_days": 7,
- "backup_start_at": "04:00:00"
}
Response samples
- 202
- 400
- 401
- 403
- 422
- 500
{- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08"
}