Getting Started

Before initializing OtterTune's development website, make sure that you have followed the Quick Setup with Vagrant instructions and are connected to the running Vagrant machine over SSH.

1. From the home directory, navigate to the top-level website directory in the ottertune repo:

   cd ottertune/server/website

2. Initialize the OtterTune website and load the test_website fixture into the database:

   fab create_test_website

   WARNING: This will destroy the website's existing database and create a new one.

   This will create a fake user with existing applications and data already loaded.

3. Start the development server:

   fab start_debug_server

4. Now open up a browser on your host machine and navigate to http://localhost:8000. You should see OtterTune's login page being served from the VM that was setup by Vagrant.

5. Sign in as the fake user with the following credentials:

   • username: user
   • password: abcd123

6. Click on the link to the user's test_project. The user has two applications: (1) a basic application for uploading and visualizing the DBMS's internal runtime metrics for different knob configurations, and (2) a tuning application (session) where OtterTune recommend new DBMS knob configurations that to optimize a target objective specified by the user (in this example it's the throughput).

OtterTune chooses the next knob configuration for the user try next to try using information from the user's knob/metric data collected in the tuning session so far as well as the knob/metric data stored in its repository from previous tuning sessions. The basic application