SwitchingToMySQL

Overview

This is a follow-up to HelloWorld. Prepare that first and then come back here.

The example config ~/.tapper/tapper.cfg already comes with commented out configuration for using MySQL. Here we

1. prepare a MySQL database,

2. modify Tapper config to point to it, and

3. re-run tapper init to initialize the databases with tables

Prepare MySQL

Install MySQL

  $ sudo apt-get install mysql-server-5.6 mysql-client-5.6

Prepare MySQL for UTF-8 needs

Add these lines into your /etc/mysql/my.cnf under the [mysqld] group:

[mysqld]
innodb_large_prefix = on
innodb_file_per_table = on
innodb_file_format = Barracuda

and restart mysql, e.g., with:

  $ sudo /etc/init.d/mysql restart

Optional: drop existing Tapper database

Careful!

If you want to delete an existing database, then do that:

  $ mysql -u root -p
  $ mysql> drop database testrundb;
  $ mysql> drop database benchmarkanything;

Create Tapper database

  $ mysql -u root -p
  $ mysql> create database if not exists testrundb CHARACTER SET utf8 COLLATE utf8_general_ci;
    mysql> grant all on `testrundb`.* to `tapper`@localhost identified by 'verysecret';
    mysql> quit;

Create BenchmarkAnything database

  $ mysql -u root -p
  $ mysql> create database if not exists benchmarkanything CHARACTER SET utf8 COLLATE utf8_general_ci;
    mysql> grant all on `benchmarkanything`.* to `benchmarker`@localhost identified by 'secret';
    mysql> quit;

Reconfigure Tapper

Edit ~/.tapper/tapper.cfg in 2 places:

Part 1 - configure testrun database

Find this piece:

database:
  TestrunDB:
    dsn: dbi:SQLite:dbname=...
    #dsn: DBI:mysql:database=testrundb
    #user: tapper
    #password: verysecret

and modify it to look like this:

database:
  TestrunDB:
    #dsn: dbi:SQLite:dbname=...
    dsn: DBI:mysql:database=testrundb
    user: tapper
    password: verysecret

Part 2 - configure benchmark database

Find this piece:

benchmarkanything:
  backend: local
  backends:
    http:
      base_url: http://localhost:7359
  storage:
    backend:
      sql:
        # --- SQLite ---
        dsn: dbi:SQLite:/home/ss5/.tapper/benchmarkanything.sqlite
        # --- mysql (example) ---
        #dsn: DBI:mysql:database=benchmarkanything
        #user: benchmarker
        #password: secret

and modify it to look like this:

benchmarkanything:
  backend: local
  backends:
    http:
      base_url: http://localhost:7359
  storage:
    backend:
      sql:
        # --- SQLite ---
        #dsn: dbi:SQLite:/home/ss5/.tapper/benchmarkanything.sqlite
        # --- mysql (example) ---
        dsn: DBI:mysql:database=benchmarkanything
        user: benchmarker
        password: secret

Re-initialize Tapper with the new databases

Careful!

  $ tapper init --default
  [... many lines with "SKIP...already exists"]
  REALLY DROP AND RE-CREATE DATABASE TABLES [DBI:mysql:database=testrundb] (y/N)? y
  REALLY DROP AND RE-CREATE DATABASE TABLES [DBI:mysql:database=benchmarkanything] (y/N): y

Clean up

You can now either throw away the benchmarkanything.sqlite and testrundb.sqlite files in ~/.tapper/, or try to migrate their content - which is unfortunately a bit more complicated and not documented here.