Linux Quick Setup

OtterTune is comprised of two components: client side and server side. OtterTune's server receives tuning tasks from clients, and uses ML models to recommend new configurations to clients. OtterTune's client-side component is to collect information from your target DBMS, send tuning tasks to the server, receive recommended configurations from the server, and install the configuration in the target DBMS.

Linux Quick Setup

• Platform: Ubuntu Linux 16.04+ (64-bit)
• Python3: OtterTune requires Python 3.6+

Clone OtterTune repo

git clone https://github.com/cmu-db/ottertune.git

Client-side Setup

• Install ant, git and pip

sudo apt-get update
sudo apt-get install ant git python3-pip python3-dev python3-tk libssl-dev
sudo pip3 install --upgrade setuptools

• Clone OltpBench Repo

git clone https://github.com/oltpbenchmark/oltpbench.git

• Install fabric

sudo pip3 install fabric3

• Install Java 8

sudo add-apt-repository ppa:webupd8team/java
sudo apt-get update
sudo apt-get install oracle-java8-installer

• Install gradle

sudo apt install gradle

• Install target DBMS

The target DBMS is the database you want to tune. Here is an example of installing Postgres 9.3.

Update Apt Repo: https://www.postgresql.org/download/linux/ubuntu/

sudo apt-get install postgresql-9.3

Server-side Setup

sudo apt-get update
sudo apt-get install git python3-pip python3-dev python-mysqldb python3-tk rabbitmq-server libmysqlclient-dev libssl-dev mysql-server
sudo pip3 install --upgrade setuptools
sudo pip3 install -r ottertune/server/website/requirements.txt