Databases


Databases

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,...
0 Comments
Filed in: Cloud Databases
What is Redis?
Redis is an open source, BSD licensed, advanced key-value store. It is often referred to as a data structure server since keys can contain strings, hashes, lists, sets and sorted sets. Redis is much more than a key...
0 Comments
Relational Databases
When we think of a database, what we traditionally envision is a relational database. This is a repository of structured data organized by schemas, tables, columns, and rows. Data is stored persistently, and...
0 Comments
Filed in: Cloud Databases
You can save and manage the settings for Cloud Databases instances in configuration groups by using the Cloud Databases API or the python-troveclient command-line interface for the API.
This article describes the commands that...
0 Comments
Filed in: Cloud Databases
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...
0 Comments
Filed in: Cloud Databases
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 operations via the...
0 Comments
Filed in: Cloud Databases
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
512 MB
50
40
4 GB
410
400
1 GB
110
100
2 GB
210
200
8 GB
810
800...
0 Comments
Filed in: Cloud Databases
Instances can be provisioned with up to 64GB of memory and up to 300GB of disk storage. You can request additional storage by submitting a support ticket via the Cloud Control Panel.
 
0 Comments
Filed 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...
0 Comments
Filed in: Cloud Databases
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...
0 Comments
Filed in: Cloud Databases
CUSTOMER’S BUSINESS: ObjectRocket offers a developer-friendly database as a service based on the MongoDB platform.
CHALLENGES: ObjectRocket needed to deliver its customers the highest performance and availability possible....
0 Comments
Filed in: Cloud Hosting, Filed in: Cloud Databases
Yes, RackConnected cloud servers can be used to connect to Cloud Databases, but dedicated servers in a RackConnect configuration will not be able to connect to Cloud Databases.
0 Comments
Filed in: RackConnect
What is ObjectRocket?
ObjectRocket is a Database as a Service based on the popular MongoDB database. The ObjectRocket infrastructure has been designed for MongoDB.
Learn more by reading the ObjectRocket API Overview and Concepts ...
0 Comments
Filed in: Cloud Servers
The following permissions matrix displays specific permissions for the roles in Cloud Databases. The matrix displays the method names, their corresponding RESTful API commands, and the roles that are supported.
API Documentation...
0 Comments
Filed in: Cloud Hosting
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 now. But we recommend our customers to use latest...
0 Comments
Filed in: Cloud Databases
The following table shows bandwidth, in megabits per second (Mbps), based on instance size.

Instance Size

Bandwidth
512 MM
20 Mbps
1 GB
1000 Mbps
2 GB
200 Mbps
4 GB
300 Mbps
8 GB
400 Mbps
16 GB
500 Mbps
32GB
1000 Mbps
64GB
2000...
0 Comments
Filed in: Cloud Databases
Note: To complete this process, you will need both a cloud server and a cloud database.
Use the following steps to connect to Cloud Databases by using MySQL Workbench.
Go to http://www.mysql.com/products/workbench/ and install...
0 Comments
Filed in: Cloud Databases
Cloud Databases is the latest relational database service offering from Rackspace. We've recently made it available in the new Cloud Control Panel. One of the advantages of Cloud Databases is that it makes it really easy to...
0 Comments
Filed in: Cloud Sites
Release notes, API documentation, and a getting started guide for Cloud Databases are all available on the Rackspace API Documentation site.
0 Comments
Filed in: Cloud Databases
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...
0 Comments
Filed in: Cloud Databases
If you cannot access your Cloud Databases instance, your data is still protected on a redundant SAN.
0 Comments
Filed in: Cloud Databases
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...
0 Comments
Filed in: Cloud Databases
You can use standard MySQL client tools to import data into and export data from your instance.  Knowledge Center articles that detail the processes of importing or exporting data are available.
0 Comments
Filed in: Cloud Databases
Not at this time. We plan to support master/slave replication in a future release.
0 Comments
Filed in: Cloud Databases
Yes.  Configuration settings for Cloud Databases instances can be stored and applied using the Cloud Databases API or the python-troveclient command-line tool.  You can save your settings in configuration groups, and each...
0 Comments
Filed in: Cloud Databases
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.
0 Comments
Filed in: Cloud Databases
The default storage engine is InnoDB, but other storage engines included with MySQL 5.1, such as MyISAM, also work for certain use cases.
0 Comments
Filed in: Cloud Databases
You can perform the following user management operations for Cloud Databases:
Create Users with Host Parameters
Modify User Accounts
Manage Database Access for Users
Set Access-Level Permissions for Individual Users
 
Create...
14 Comments
Filed in: Cloud Databases

Caching

Relational Databases
When we think of a database, what we traditionally envision is a relational database. This is a repository of structured data organized by schemas, tables, columns, and rows. Data is stored persistently, and...
0 Comments
Filed in: Cloud Databases

Backups

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 operations via the...
0 Comments
Filed in: Cloud Databases