Cloud Databases FAQ
- Getting Started -
Can I provision Cloud Databases if I don’t have Cloud Servers, Cloud Load Balancers, or Cloud Sites on my account?
Yes, but instances are provisioned only with network interfaces on their data center’s internal service network (ServiceNet). Connecting to a Cloud Database instance remotely requires either a Cloud Server or Cloud Load Balancer to proxy the connection.
What kind of storage solution does Cloud Databases offer?
Each Cloud Database instance comes with an attached storage volume. Storage volumes are automatically provisioned on a shared Internet Small Computer System Interface (iSCSI) storage area network (SAN) that provides for increased performance, scalability, availability, and manageability. Applications with high I/O demands are performance-optimized and data is protected through both local and network RAID-10. Additionally, network RAID provides synchronous replication of volumes with automatic failover and load balancing across available storage clusters.
How is performance better than running a MySQL database on a Cloud Server?
Every Cloud Databases instance is optimized for performance. Cloud Databases uses container-based virtualization, which eliminates the performance bottlenecks of the traditional hardware virtualization and enables your database to run at near bare metal speeds. It also uses dedicated SAN storage and high speed networking to give you faster access to your data.
What is Cloud Databases?
Cloud Databases is a stand-alone, API-based, relational database service built on OpenStack® cloud that allows Rackspace customers to easily provision and manage multiple MySQL database instances. Instances are provisioned in a single-tenant, container-based environment per account and are accessible via the Rackspace internal ServiceNet network. Each database instance is optimized for performance. You can run a database instance with MySQL, Percona, or MariaDB as the database technology.
What are the benefits of using Cloud Databases?
Cloud Databases provides a complete solution for customers demanding a high-performance, purpose-built infrastructure designed for relational databases backed and supported by engineers who specialize in MySQL workloads. Cloud Databases is a fully managed service for customers who want to focus on developing their applications and not worry about the underlying infrastructure. The service offers on demand backups and restores, integrated monitoring, redundant storage, scalability to grow based on your application needs, and full control of your database.
What instance sizes do you currently support?
What types of Rackspace products / accounts can use Cloud Databases?
Any US or UK customer with a Cloud account will be able to provision multiple ServiceNet database instances, manage multiple databases and users (within resource limits). This service is also available to RackConnected Cloud Servers. Both First and Open Cloud Servers can connect to Cloud Databases, as well as any product with access to our internal ServiceNet network within the same regional datacenter.
Can Cloud Databases be used with Dedicated servers?
No, Cloud Databases are available only to customers with Cloud account credentials. Managed Operations Service Level or Dedicated customers with RackConnect (that is those customers who also have a Cloud account) have access, but can use the service only with their Rackspace Cloud product resources.
Is Cloud Databases available in the Control Panel?
Does Cloud Databases support SSL for communication between my application and my database instance?
Yes, Cloud Databases supports connecting to your instance using SSL. An SSL certificate is installed for each Cloud Databases instance that enables a secure connection between your application and the instance. When an SSL connection is established, any data transfer between the instance and application is encrypted.
Can I write to my database instance during a backup?
The behavior of your instance during a backup depends on the storage engine that you are using for tables. If you use only InnoDB, write access to your database instance is not suspended. Conversely, if you have MyISAM tables, those databases are write-locked during the backup process.
What storage engines do you support for database backups?
MySQL supports several types of table engines, also known as table types. The tables on a Cloud Databases instance can use a mix of different table engine types or they can all use the same type. Currently we support backups of databases that use InnoDB and MyISAM.
How much do you charge for database backups?
Backups are stored in your Cloud Files account, and you are charged for storage used. Standard rates for Cloud Files storage apply. For current costs, see the Cloud Files pricing page.
How do you perform database backups?
Backups are created by using Percona XtraBackup to perform a hot copy of all databases on an instance. The resulting database files are streamed directly to your Cloud Files account for storage.
Do you provide database backup and restore features?
Manual backup and restore operations are currently supported from within the Control Panel. For more information, please read the article Managing Backups for Cloud Databases. Alternately you can manage backup operationsvia the Cloud Databases API, or by using the Trove command line tool (CLI).
Although Cloud Databases provides built-in data replication, as a best practice, we encourage our Cloud customers to back up their data using MySQL tools like mysqldump. Managed Operations Service Level customers can request assistance with backups from their support team.
How long does a database backup take?
The duration of the backup will depend on the size of your databases and any network saturation during the backup.
How do I restore a database backup?
To restore a database backup, you must create a new database instance, specifying the backup that you want to restore during the create request. Your backup is loaded to the new instance, and you will receive a DNS endpoint for the new instance. After the restore operation is complete, you can update your application to use the new endpoint.
The original instance is not altered during a restore operation and may remain in use or be deleted through the API, CLI, or Control Panel.
How many database backups can I request?
There are no limits on how many database backups you can create. Note that you can run only one backup at a time; duplicate requests result in a 422 error.
When a Cloud Database is deleted how is the data removed?
Cloud databases run off of SAN storage using a mount point. Once an instance is deleted, the mount point is destroyed.
Are database backups deleted when a database is deleted?
Backups are not deleted when an instance is deleted. You must manually remove any stored backups.
Monitoring and Troubleshooting
What Cloud Databases operations are supported at different service levels?
Support coverage information for Managed Infrastructure and Managed Operations Service Level is available on the Cloud Databases support matrix page.
Where can I find the Cloud SLA?
The Cloud service level agreement (SLA) on the Rackspace website.
How can I monitor my resource use on Cloud Databases?
Monitoring is available for all Cloud Databases instances through pre-configured Cloud Monitoring checks, including load average, CPU, memory, disk storage, network, and a number of MySQL metrics. You can monitor your Cloud Databases instances using theCloud Control Panel, theCloud Monitoring API, or the Cloud Monitoring command-line tool.
You can also set up alarms to send you email alerts based on thresholds you define. An alert for disk space is set up by default for every instance. You can also use our Cloud Intelligence beta site to observe usage patterns or any unexpected changes in your environment.
Can I create a Cloud Databases support ticket?
Yes. A Cloud Databases support ticket category is available in the Cloud Control Panel.
What are the differences between InnoDB and MyISAM?
InnoDB is the default storage engine for Cloud Databases. InnoDB enforces ACID transactions allowing for commit, rollback, and crash recovery capabilities to protect user data.
During a backup, a hot copy process is used on all tables. InnoDB tables record all transactions during the copy in order to replay them during a restore operation.
MyISAM tables are write-locked during the copy process in order to create a consistent backup. While the instance is being backed up you cannot add or delete databases, add or delete users, or delete, stop, or reboot the instance.
For more information about these engine types, see the MySQL documentation:
How many connections does each database instance size support?
Details about maximum connections and access to my.cnf file settings per database size are listed in the following table:
|Size||Max connections||Max user connections|
What is the maximum scalable capacity of a Cloud Database instance?
Instances can be provisioned with up to 64GB of memory and up to 500GB of disk storage. You can increase storage up to the maximum using the Cloud Control Panel. Note that disk storage cannot be decreased on a running instance.
Can I set up a read-only MySQL user in Cloud Databases?
Yes, but by default all users created through the Control Panel, API, and command line interface (CLI) have full permissions.
To create read-only users, you first must enable the root user and use that user to generate and manage additional users with read-only privileges.
Can I enable a root (super) user?
Yes. Currently, the root user can only be enabled via the public API or command line interface (CLI). We do plan to integrate this feature into the Cloud Control Panel at a later date.
Once root is enabled, it cannot be disabled.
What versions of MySQL do you offer?
Cloud Databases supports MySQL 5.6, Percona 5.6 and MariaDB 10. For all newly created Cloud Database instances, MySQL 5.6 is the default. We will continue to support MySQL 5.1 for legacy instances, but we recommend our customers use the latest version of MySQL, Percona, or MariaDB because they offer significant performance improvements and newer features. For more information to help you choose the right database version for your application, see Choosing the right data store.
What bandwidth limitations are enforced on the ServiceNet network?
The following table shows bandwidth, in megabits per second (Mbps), based on instance size.
|512 MB||20 Mbps|
|1 GB||100 Mbps|
|2 GB||200 Mbps|
|4 GB||300 Mbps|
|8 GB||400 Mbps|
|16 GB||500 Mbps|
|32 GB||1000 Mbps|
|64 GB||2000 Mbps|
Where can I find the Cloud Databases documentation?
Release notes, API documentation, and a getting started guide for Cloud Databases are all available on the Rackspace API Documentation site.
Are there API or account limits for my Cloud Database instances?
Yes. All accounts, by default, have a preconfigured set of thresholds (or limits) to manage capacity and prevent abuse of the system. The system recognizes two kinds of limits: rate limits and absolute limits. Rate limits are thresholds that are reset after a certain amount of time passes. Absolute limits are fixed at the account level. For the most up-to-date information about rate and absolute limits (which include instance and volume limits), see the Limits section in the Rackspace Cloud Databases Developer Guide.
If my database instance is unavailable, what happens to my data?
If you cannot access your Cloud Databases instance, your data is still protected on a redundant SAN.
How can I access my database instance?
Cloud Databases provides several options for connecting to your database, giving you complete flexibility in how you access your database. For increased security, your database is available only on the Rackspace private network by default. However, you can connect to your database by using several methods described at the following links:
Additionally, you can use the Cloud Control Panel, API, or command line interface (CLI) to manage your database instance. Some of the features are not available in the Control Panel but can be accessed through API or through the CLI. More information about the API and CLI is located in the Cloud Databases API documentation, in both the API developers guide and the getting started guide.
How do I set the default time zone for MySQL?
You can set the default time zone for a Cloud Databases instance of MySQL by creating a configuration group that sets the default_time_zone parameter to the offset from UTC (for example, “-6:00” for CST).
For more information, see Setting the time zone for a Cloud Databases instance.
Do you support importing and exporting data into the database?
Do you support MySQL configuration (my.cnf) file modifications?
Yes. Configuration settings for Cloud Databases instances can be stored and applied using theCloud Control Panel and the Cloud Databases API. You can save your settings in configuration groups, and each configuration group can be applied to multiple instances. You can maintain multiple configuration groups to account for different workloads.
What level of access do I have to my database instance?
Access to MySQL is allowed only over port 3306; shell-level access is not available. Full MySQL access can be obtained by enabling the root user on the database instance.
What is the default database storage engine?
The default storage engine is InnoDB, but other storage engines included with MySQL 5.1, such as MyISAM, also work for certain use cases.
What is High Availability for Cloud Databases?
A Cloud Databases High Availability (HA) instance group includes a source database instance with one or two replicas. If the source database instance becomes unavailable, an automatic failover is initiated to one of the replicas. The automatic failover and promotion of the new instance is completed within a short downtime (approximately 10-30 seconds).
What flavors are supported for HA instance groups?
You can choose any flavor from 1 GB to 64 GB for provisioning an HA instance group.
Can I create a backup of the High Availability instances?
Currently backups, resizes, and custom configurations cannot be performed for instances that are part of the HA setup. Backups and incremental backups can be created for the HA group rather than an individual instance.
Can I resize the RAM for my HA instances?
Resizing is not currently supported for HA instances for Cloud Databases. Rackspace will start supporting resizing for HA instances in a future release.
What is the underlying technology for creating HA Cloud Databases instances?
Technical architecture details are provided in the High Availability for Cloud Databases article.
Do HA instances support automatic failover?
Yes. Rackspace ensures that if the source database instance becomes unavailable, an automatic failover is initiated to the replicas within 10-30 seconds of downtime.
What is the pricing for HA instances for Cloud Databases?
For the product introduction, Rackspace is charging the same price for HA instances as for single instances for a limited time. In the future, there will be an increase in the price of HA instances.
Which databases are supported for HA instances for Cloud Databases?
Rackspace currently supports MySQL 5.6, Percona 5.6, and MariaDB 10 for HA database instances.
How many replicas can I add to the HA group?
You can add a maximum of two replicas to the primary source database instance. So you can have a maximum of three instances in the HA group, one primary and two replicas. In the future, we will increase the number of replicas that can be added to the HA group.
Where can I find more technical details about High Availability (HA)?
See the article High Availability for Cloud Databases.
Can I monitor replication?
Yes. You can monitor replication using the monitoring agent installed on the instance. For more information, see Monitoring Read Replication in the API documentation.
Is replication supported between different versions of the database?
No. You can only add replica of the same database type and version as your source database instance.
Is replication supported between different regions?
No. You can only add a replica in the same region as your source database instance.
Does setting up replication require downtime?
When you add a replica to the source DB instance, the instance gets restarted. So your database will be unavailable until the instance restarts.
Is there a charge for replication?
Each read replica added is charged the same way as a new instance.
Does replication support auto failover?
Currently replication does not support auto failover. In case your database instance goes down and you would like to use replica instance for minimizing downtime, you will have to do a manual failover to the replica instances. For manual failover, you must detach the replica from the source instance and change the application endpoint to this new source database instance.
Is replication supported for all database types?
Replication is supported for MySQL 5.6, Percona 5.6, and MariaDB 10. We do not support replication for MySQL 5.1 as this is an older version of MySQL and there have been significant improvements for replication support in newer versions of MySQL. We highly recommend all users to upgrade from MySQL 5.1 to MySQL 5.6.
Do you support replication?
Yes we do support Master Slave Replication. You can add and manage replicas using Cloud Control Panel and Cloud Databases API. For more information about managing replication with API, see API docs for replication.
How much does Cloud Databases cost?
Pricing information is available at the Cloud Databases pricing page. Standard charges apply for any Cloud Servers, Cloud Load Balancers, or Cloud Sites that are used to access your Cloud Database instances.
©2016 Rackspace US, Inc.
Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License