Forums/Knowledge Base/DataCloud on CityCloud

Getting Started

Veemal Gungadin
posted this on November 17, 2011 23:57

The Severalnines DataCloud is a Database-as-a-Service that allows you to create highly available MySQL database instances on demand. 

We have launched this service in partnership with CityCloud.

Here's how to get started: 

 

Setting up a Database Instance

Once you login to your CityCloud admin console account, you will see a new tab "CityCloud DB Service":

datacloud_citycloud_home-2.png

 

Upon clicking on it, you will be shown with a list of database instances that you own. At the beginning it's going to be empty. So, click on the "Create Database Instance" button to get started:

datacloud_createdb.png

 

Once you click on the button, you will simply be asked to provide the following basic information:

datacloud_createdbfrm.png

 

We currently support the following database instance sizes:

  • Small (1 CPU, 2GB RAM)
  • Medium (4 CPUs, 8GB RAM)
  • Large (6 CPUs, 16GB RAM)

All instance sizes come with 20GB disk space. You may choose to select any additional disk space if this is not sufficient for you. 

Your data can be scheduled to automatically backup on DataCloud. During the setup you can specify the backup retention period - ie, how long you want to keep the backup for. 

Once you're ready, press on the Create Database button, wait for a while (up to 5 minutes), and your optimized database instance will be up and running! 
It'll then show up on your dashboard:

datacloud_instances.png 

 

Manage your Database Instance

Once your database instance is provisioned, you will be able to use DataCloud to:

  • Monitor the database load
  • Monitor database nodes
  • Manage database schema
  • Analyze queries
  • Perform backups
  • View MySQL Stats
  • And more...
Here are some screenshots of what you can expect:
datacloud_screen_overview.png datacloud_screen_query.png 
datacloud_screen_node.png datacloud_screen_mysql.png 


Scaling - Adding Read Copies

Your database instance is created on 1 node only by default. To scale up, you can create additional read copies (slaves) on demand.  On the nodes page of your database instance, you'll find a Add Read Copy button. You can add as many read copies as you like at the click of the button:

datacloud_readcopy.png