Getting Started – Amazon EC2

In this guide we’ll explain how to get started using the Amazon Web Services OffScale AMI.
We’ve created this AMI as a simple way for users to try our OffScale DataGrove and experience the benefits Database Version Control in a quick and simple way – no download required.

What’s inside the AMI?

The AMI comes preinstalled with -
  • Ubuntu 11.04
  • OffScale DataGrove
  • MySQL 5.1
  • The “world” database (click here to read more about this)
We’ve already created two versions of the DB, so you can just get started -
  • mysql_clean - a clean install of MySQL 5.1, with no data
  • mysql_world - MySQL 5.1 populated with the world database’s data

Getting started

  1. Launch an EC2 instance
    The AMI ID for the demo is – ami-ec5d8185. (currently only available on US-East/ Virginia)
    You can instantly launch an instance by clicking this link.
  2. Connect to the instance
    By using AWS’s key-pairs -
    $ ssh -i <key-pair file>.pem ubuntu@<server address>
  3. Show the list of existing versions
    $ sudo datagrove list
  4. Loading the empty MySQL DB
    When you load a version in DataGrove you don’t need to worry about MySQL. The DB will be started automatically with the correct data.
    Loading a DB version is simple -
    $ sudo datagrove load -n=mysql_clean
  5. Unloading the current version
    When you unload the current version in DataGrove you don’t need to worry about MySQL. The DB will be stopped automatically to ensure data consistency.
    $ sudo datagrove unload
  6. Loading a populated DB
    We’ve pre-created a version in which the DB is populated with the world database.
    $ sudo datagrove load -n=mysql_world
    You can see the new DB by connecting to MySQL and listing the available DBs.
    $ mysql -uroot -proot
    $ mysql> SHOW DATABASES;
  7. Tagging a version
    Just like when loading an existing version, tagging a version is super simple. DataGrove makes sure the DB is in a consistent state. This only takes a few seconds!
    $ sudo datagrove tag -n=<version_name>
A few general notes -
  • MySQL
    • User – root
    • Password – root
  • Linux
    • User – ubuntu
  • Storage
    • Currently the data and changes you make are stored locally on the EBS volume of the instance (the AMI is EBS backed). This means that if you want to save the work you’ve done you need to make an AMI that you can load later (read more here). We’ll support storing data on a dedicated EBS volume and S3 soon.
Be Sociable, Share!