Using Amazon Webservices

Within the workshop, you will need to have the following tools in addition to the the regular ssh access.

  • MySQL WorkBench

Additional details about accessing AWS will be provided during the first day.

ADACS-Training Docker Image

The container is based on Ubuntu 16.04. It contains the following software modules:

  • MySQL Server + Employees Sample Database
  • git
  • OpenMPI
  • Anaconda2 (4.2.0)
  • Emacs

Docker is a virtualization mechanism to package your application into a standardised unit. To install Docker on your machine follow these instructions. More details about Docker can be found on "Get started with Docker"

To start an ADACS-Training container, write the following command in your terminal : 

docker run -p 3306:3306 -p 8888:8888 -it caseresearch/adacs-training

This will download all the necessary software and start a new Docker for you. After this step, you have a fully functional Docker container with ports 3306 ( for MySQL) and port 8888 ( for ipython) exposed to your machine.

A nice docker cheat sheet can be found here.

Other Tools Required

Within the workshop, you will need to have the following tools in addition to the Docker container.

  • MySQL WorkBench
Please ensure that you have the latest pandas package by running 
conda update pandas

If you prefer to use your PC/laptop with no virtualization

If you decided not to use Docker, you should install the following software modules on your local machine.

  • git
  • MySQL Server
  • MySQL WorkBench
  • Python 2.7 or Anaconda (Python 2.7)
    Please ensure that you have the latest pandas package by running 
    conda update pandas
  • OpenMPI and MPI for Python 
    conda install --yes anaconda mpi4py
  • MySQL Sample Database 
    
git clone https://github.com/datacharmer/test_db.git .
mysql < employees.sql
  • MySQL WorkBench