restorePoint
attribute, this call performs the Restore Backup operation, creating a new database instance to store the backup.Applies To | Name | Description | Required | ||
Instance | flavorRef |
|
Yes | ||
(volume) size | Specifies the volume size in gigabytes (GB). The value specified must be between 1 and 300. | Yes | |||
name | Name of the instance to create. The length of the name is limited to 255 characters and any characters are permitted. | No | |||
configuration | Identifier of the |
No | |||
(datastore) version / type | Name or uuid of the datastore version and type to associate with the instance. If the datastore is not specified, it defaults to mysql. | No | |||
Database | name | Specifies |
No | ||
character_set | Set of symbols and encodings. The default character set is utf8 . |
No | |||
collate | Set of rules for comparing characters in a character set. The default value for collate is utf8_general_ci . |
No | |||
User | name | Specifies user name for the database on instance creation. Refer to |
No | ||
password | Specifies password for those users on instance creation. Refer to |
No | |||
(database) name | Specifies names of databases that those users can access on instance creation. Refer to |
No | |||
host | Specifies the host from which a user is allowed to connect to the database. Possible values are a string containing an IPv4 address or "%" to allow connecting from any host.
Refer to host is not specified, it defaults to "%". |
No | |||
Restore | restorePoint |
restorePoint attribute. |
No |
self
link contains a bookmark
link provides a permanent link to a resource that is appropriate for long term storage.Name | Description | Required | ||
backupRef |
|
Yes |
replica_of
attribute.replica_of
attribute.
The service then provisions the replica with the requested flavor and sets up a volume of the specified size.restorePoint
attribute, this call performs the Restore Backup operation, creating a new database instance to store the backup.Applies To | Name | Description | Required | ||
Instance | flavorRef |
|
Yes | ||
(volume) size | Specifies the volume size in gigabytes (GB). The value specified must be between 1 and 300. | Yes | |||
name | Name of the instance to create. The length of the name is limited to 255 characters and any characters are permitted. | No | |||
replica_of | Identifier of the source instance to replicate. | Yes | |||
configuration | Identifier of the |
No | |||
(datastore) version / type | Name or uuid of the datastore version and type to associate with the instance. If the datastore is not specified, it defaults to mysql. | No | |||
Database | name | Specifies |
No | ||
character_set | Set of symbols and encodings. The default character set is utf8 . |
No | |||
collate | Set of rules for comparing characters in a character set. The default value for collate is utf8_general_ci . |
No | |||
User | name | Specifies user name for the database on instance creation. Refer to |
No | ||
password | Specifies password for those users on instance creation. Refer to |
No | |||
(database) name | Specifies names of databases that those users can access on instance creation. Refer to |
No | |||
host | Specifies the host from which a user is allowed to connect to the database. Possible values are a string containing an IPv4 address or "%" to allow connecting from any host.
Refer to host is not specified, it defaults to "%". |
No | |||
Restore | restorePoint |
restorePoint attribute. |
No |
self
link contains a bookmark
link provides a permanent link to a resource that is appropriate for long term storage.used
size of your volume will be
greater than 0. This is expected and due to the automatic creation of
non-empty transaction logs for database optimization. The used
attribute is BUILD
.ACTIVE
. Wait for
a couple of seconds for the process to
be complete. The best way to verify
whether the process is complete is to
check the slave metrics as described
in Applies To | Name | Description | Required | ||
Instance | replica_of | Identifier of the source instance to replicate. | Yes |
used
size of your volume will be
greater than 0. This is expected and due to the automatic creation of
non-empty transaction logs for database optimization. The used
attribute is used
size of your volume will be
greater than 0. This is expected and due to the automatic creation of
non-empty transaction logs for database optimization. The used
attribute is name
of the database is a required attribute.collate
and character_set
.Name | Description | Required | ||
name | Specifies the database name for creating the database. Refer to the request examples for the required json format. | Yes | ||
character_set | Set of symbols and encodings. The default character set is utf8 . |
No | ||
collate | Set of rules for comparing characters in a character set. The default value for collate is utf8_general_ci . |
No |
Character |
Letters (upper and lower cases allowed) |
Numbers |
'@', '?', '#', and spaces are allowed, but |
'_' is allowed anywhere in the database name |
Character |
Single quotes |
Double quotes |
Back quotes |
Semicolons |
Commas |
Backslashes |
Forwardslashes |
Restriction | Value |
Database-name maximum length | 64 |
Applies To | Name | Description | Required | ||
User | name | Name of the user for the database. | Yes | ||
password | User password for database access. | Yes | |||
(database) name |
|
No | |||
host | Specifies the host from which a user is allowed to connect to the database. Possible values are a string containing an IPv4 address or "%" to allow connecting from any host.
Refer to host is not specified, it defaults to "%". |
No |
Character |
Letters (upper and lower cases allowed) |
Numbers |
'@', '?', '#', and spaces are allowed, but |
'.' is allowed, but must be escaped by replacing it with "%2E" before URL encoding occurs if it occurs in GET, DELETE,
and PUT calls, where such a name is the last section of the request URL. Please refer to the Warning in |
"_" is allowed anywhere in the database name, user name, and password |
Character |
Single quotes |
Double quotes |
Back quotes |
Semicolons |
Commas |
Backslashes |
Forwardslashes |
Spaces at the front or end of the user name or password |
Restriction | Value |
Database name maximum length | 64 |
User name maximum length | 16 |
Password maximum length | unlimited (no restrictions) |
users?limit=2
):host
field.href
) to the next set of users in the list (users?marker=dbuser2%4010.0.0.1&limit=2
), so using that link for the request will return the next two users in the list after dbuser2%4010.0.0.1
.Name | Description |
name | Name of the user for the database. |
password | User password for database access. |
host | Specifies the host from which a user is allowed to connect to the database. Possible values are a string containing an IPv4 address or "%" to allow connecting from any host.
Refer to host is not specified, it defaults to "%".
|
Name | Description | Required | ||
name |
|
Yes | ||
instance |
|
Yes | ||
description |
|
No | ||
parent_id |
|
No |
Restriction | Value | ||
|
64 |
z_CLOUDDB_BACKUPS
and places all the files in it.
In order for the restore and deletion of backups to work properly, you should not move, rename, or delete any of the files from this container.
You will be charged the normal Cloud Files rate for storage of these files. For pricing details, refer to http://docs.rackspace.com/cdb/api/v1.0/cdb-devguide/content/Pricing_SLA-d1e1362.html
No additional Cloud Databases fee applies for creating backups.
You can delete old backups through the API. Refer to FAILED
,
there may be some files that were placed in the container.
You should use the API to delete the backup to remove any leftover files. Refer to name
and description
must
be a string composed of 1 to 255 alphanumeric characters. Both uppercase and lowercase alpha characters may be used.name
and description
must
be a string composed of 1 to 255 alphanumeric characters. Both uppercase and lowercase alpha characters may be used.