Skip to main content

Amazon Web Services (AWS)

Launching a Brytlyt Instance

Launching a Brytlyt instance is quick and easy on AWS. You can search for the Brytlyt AMI in the AWS Marketplace or launch from the product home page. BrytlytDB is a PostgreSQL fork, so all the tools and utilities that work for PostgreSQL will work.

https://aws.amazon.com/marketplace/pp/B074JZNSWZ

Once the instance has launched you can connect to is via SSH directly from linux. Make sure you connect as the ubuntu user.

http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/EC2_GetStarted.html

ssh -i "MyKey.pem" ubuntu@34.204.18.189

You can also connect to the AWS instance using putty. Make sure to connect as the ubuntu user.

http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/putty.html

Using Spot Instances (AWS)

AWS spot instance price varies over time but often the spot instance is 90% cheaper than on-demand instances. There is a risk that your spot instance is terminated before you’ve finished using it. Great for trying things out, not so good for production environments.

Launching a Marketplace AMI on spot is slightly more involved because the AMI is not searchable from the standard Spot Requests launch console, so you need to find it first. To do this, go to the AWS Marketplace product home page. For Brytlyt that home can be found here.

https://aws.amazon.com/marketplace/pp/B074JZNSWZ

Next click on the “Continue” button on the top right. Then click on the “Manual Launch” tab, middle of the three options on the top left. Half down, in the Launch section, you will see a list with an AMI ID for each region. Copy the AMI ID for the region you would like to launch the spot instance in.

Now you have all you need to launch the instance using spot. Go to the EC2 console, select “Spot Requests” and click on the “Search for AMI” button. Past the AMI ID into the “Search by AMI ID or keyword” text box and hit enter. You should now see the AMI and click the blue “Select” button.
Remember to change the instance type to one of the p2 instances and increase the amount of disk storage if necessary by upping the size of each of the six disks that make up the RAID 0 storage array.

BrytLyt AMI Walkthrough

During AMI initialization SSH is blocked and for a couple of minutes connecting with the server will not be possible. Once it is finished BrytLytDB together with SpotLyt visualization tool should be up and running.

To connect to the database type:

psql -U brytlyt

You can find already defined tables with data samples loaded inside:

brytlyt=# \d+
List of relations
Schema | Name | Type | Owner | Size | Description 
--------+----------+---------------+---------+---------+-------------
public | lineitem | foreign table | brytlyt | 0 bytes | 
public | orders | foreign table | brytlyt | 0 bytes | 
public | taxi | foreign table | brytlyt | 0 bytes |

Inside home directory (/home/ubuntu) you can find scripts for stopping, starting and restarting database:

restart_db.sh  start_db.sh  stop_db.sh

/home/ubuntu/test_data contains samples of TPC-H and NY taxi data. In SQL subdirectory you can find a couple of example queries which may be called as simple as:

psql -U brytlyt -f /home/ubuntu/test_data/SQL/taxi_query_1.sql

 

To use SpotLyt enter server’s IP as browser address. Default login details are:

login: brytlyt@brytlyt
password: brytlyt

which may be changed by the user.

For more information please visit SpotLyt section.