How to use Rackspaces SQL Cloud Databases

and published
Rackspace SQL Cloud

Finally Rackspace are now offering customers the option to use a SQL database cloud, this is without a doubt exciting news for us speed freaks! What’s more since it is a scheme still in pilot it’s absolutely FREE.

So what are the major benefits of using an SQL on a cloud?

Here is just some of the very popular reason people make the switch from local SQL to remote SQL stored on the cloud:

  • Frees up resources on your vps by removing mysql-server
  • Redundant storage by default on all clouds
  • Clouds are monitored
  • Clouds are scalable with demand
  • Built for performance

Using Rackspace’s SQL Database Cloud Guide

This guide is split into 7 steps, if you have a questions or encounter any problems please don’t hesitate to use our comment system found at the bottom of this page.

  • Step 1 – Rackspace Server Backup
    • Before we proceed please ensure that you either have a backup of your server which is current either by a daily scheduled backup or an on-demand backup. Making a backup could not be any simpler on Rackspace, I’m sure you know already but if you forgot using the 1st generation control navigate click:

      Hosting > Cloud Servers

      Once on this screen click the server you want to backup, you will then see 4 Tabs (Note: it may be different on the US control panel, since I’m using the UK one I can’t say).

  • Step 2 – Finding the SQL Cloud Service
    • In order to see and use the SQL Database Cloud Service by Rackspace you must have digitally signed the terms and conditions of using a server cloud and have the option available to you, if you have only signed the agreement to use a file cloud then the chances are you won’t be able to use an SQL database.

      As mentioned before the SQL Cloud is currently free while it’s in Pilot, we have no idea how much this service is going to cost, though I have talked to the guys at Rackspace and they have meetings on going and its planned that the staff get told more information in August.

      Launch the SQL control panel in the 2nd Generation Control Panel, personally I prefer the old but hey!

  • Step 3 – Creating an SQL Instance
    • Just as you would expect with starting a server instance we need to do exactly the same but this time for an SQL instance. Proceed to creating an SQL instance, this service is no longer free.

      Tip: If you’re using some kind of common CMS such as WordPress, Joomla etc, then I recommend you use the username and password, as well as the database name in your Rackspace settings. By doing this you will only need to change a few lines rather than lots more. If your username and password are a little weak then you could use this chance to strengthen your security.

  • Step 4 – Dumping your current SQL database
    • You need to get a current dump of your current SQL database, doing this is simple if you have phpmyadmin and just using the export feature but I’d imagine not everyone has this installed.

      If you do not have phpmyadmin installed then login to your server using SSH or the console within your 1st Generation Control Panel within Rackspace. You should find this by navigating to:

      Hosting > Cloud Servers > Your Server Name > Console

      Once you have logged into the terminal using your username and password ensure that you are in your home directory or somewhere you want the SQL file to be made.

      To dump the SQL simply type this:


      It should prompt you for your password for that database, once you provided a valid password it’ll extract the SQL database and dump it into the file to be saved file name, confirm it’s saved by doing an ls within the terminal. If you see the file has been successful saved you can move onto the next step.

  • Step 5 – Importing your SQL file to Rackspace’s SQL Cloud
    • Sadly as of yet the SQL cloud on Rackspaces 2nd generation control panel does not have an import feature, I hope this is just something they haven’t got around to yet since not having it requires more work. To import your dump file were going to login to your MySQL which is running on their cloud setup.

      To do so you will need to find out the address it is operating for, for security reasons I’m not going to show a screenshot of the control panel of my setup but to find out the IP address you need to navigate to:

      Cloud Databases > Instance Name > Copy Hostname into the clipboard

      So you should have something like, once you have this saved into the clipboard or a text file we can import your SQL database to Rackspaces Data Cloud, this is pretty straight forward. You will need to know the username and password, as well as the database name you made on the cloud at Rackspace, so have this text document open if you copied it.

      In the terminal do:


      This will prompt you to enter password, and if you don’t get any errors it’s worked.

  • Step 6 — Use Rackspace’s Database Cloud for CMS
    • Using the Database Cloud for your CMS such as WordPress and Joomla etc, is pretty straight forward you just need to update your configuration file, change localhost to and enter new username and password in the event you reset these, you should not have to change the prefix.

      Simply load up your browser and see if your site is accessible, if it works then your site is reading SQL from the CLOUD! Congrats! And welcome to the fast SQL club. In the event it’s not then I guess something went wrong, feel free to add comments at the bottom and I’ll try and help when I can. If you want to free up resources on your VPS cloud then move onto the next step.

  • Step 7 – Freeing Up Resources by Removing MySQL-Server (Optional Step)
    • This step is completely option and I only recommend it if you’re not too worried about Rackspace’s pricing when it comes into effect. Since you now have your Database on the Cloud there’s little point in using MySQL-Server running on your VPS. This ultimately will free up resources and should make your VPS run faster.

      Removing MySQL-Server is easy on Ubuntu just use sudo apt-get remove mysql-server, do not remove mysql-common or php5-mysql as these are required to read databases period.

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>