/website

OLTP-Bench Web Site

Primary LanguagePythonApache License 2.0Apache-2.0

Website

OLTP-Bench Website is an intermediate between the client's database and OtterTune (DBMS Auto-tuning system)

Dependencies

  • Python +2.7
  • Tensorflow
  • Django == 1.9 (currently does not support Django 1.10)
  • django-debug-toolbar +1.5
  • celery +3.1.23
  • django-celery +3.1.17
  • rabbitmq-server
  • python packages: python-mysqldb, sklearn, poster, numpy

Quick Start

###1. Install Dependencies sudo apt-get install python-pip python-dev python-sklearn python-mysqldb rabbitmq-server sudo pip install django==1.9 numpy poster celery django-celery django-debug-toolbar ###2. Revise the setting.py file.

Set the BasePath of your website (line 8)

Set your database access (line 54) . (Name, User, Password ...)

###3. Migrate the models into the database

python manage.py  makemigrations website
python manage.py  migrate

###4.Preload the parameters python manage.py loaddata ./preload/*

###5.Run the rabbitmq and celery worker rabbitmq-server & python manage.py celery worker --loglevel=info ###6. Run the website server python manage.py runserver 0.0.0.0:8000