Skip to content

Latest commit

 

History

History

docker

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
README.md
README.md
 
 

README.md

ATAV Database Docker Percona

The instruction of Docker setup for ATAV database.

Requirement

  • docker-compose >= 3.0
  • percona-server 5.6.45 (docker image)
  • mysql client (optional)
  • disable THP:
    • access Docker VM
    docker run -it --privileged --pid=host debian nsenter -t 1 -m -u -n -i sh
    • Then run:
    echo never > /sys/kernel/mm/transparent_hugepage/enabled
echo never > /sys/kernel/mm/transparent_hugepage/defrag

Run

Download repo

git clone https://github.com/nickzren/atav-database

Delete and Create data volumn

docker volume rm atavdb_mysqldata
docker volume create atavdb_mysqldata

Initialize Docker Percona Server (TokuDB enabled)

docker run -d --name atavdb \
-v atavdb_mysqldata:/var/lib/mysql:rw \
-v $(pwd)/atav-database/data/:/var/lib/mysql-files:rw \
-p 3333:3306 \
-e MYSQL_ROOT_PASSWORD=root \
-e INIT_TOKUDB=1 \
percona/percona-server:5.6.45

Restore database schema

docker exec -i atavdb mysql -uroot -proot < atav-database/data/atavdb_schema.sql
docker exec -i atavdb mysql -uroot -proot < atav-database/data/externaldb_schema.sql

Load testing data

gunzip atav-database/data/atavdb_load_data/*
for file in atav-database/data/atavdb_load_data/*; do docker exec -i atavdb mysql -uroot -proot atavdb -e "load data infile '/var/lib/mysql-files/atavdb_load_data/${file##*/}' into table ${file##*/}" ; done

Setup for ATAV CLI and Data Browser

Add mysql user

# ATAV DB Load
docker exec -i atavdb mysql -uroot -proot -e "CREATE USER 'dbload'@'%' IDENTIFIED BY 'dbload'"
docker exec -i atavdb mysql -uroot -proot -e "GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, FILE, INDEX, ALTER, LOCK TABLES ON *.* TO 'dbload'@'%'"

# ATAV CLI
docker exec -i atavdb mysql -uroot -proot -e "CREATE USER 'atav'@'%' IDENTIFIED BY 'atav'"
docker exec -i atavdb mysql -uroot -proot -e "GRANT SELECT, INSERT, CREATE, CREATE TEMPORARY TABLES ON *.* TO 'atav'@'%'"

# ATAV Data Browser
docker exec -i atavdb mysql -uroot -proot -e "CREATE USER 'atavdb'@'%' IDENTIFIED BY 'atavdb'"
docker exec -i atavdb mysql -uroot -proot -e "GRANT SELECT ON *.* TO 'atavdb'@'%'"

Check

Check database records

docker exec -it atavdb mysql -uroot -proot atavdb -e "show table status"

# use this only when mysql client installed
mysql -h127.0.0.1 -uroot -proot atavdb -P 3333 -e "show table status"

Start a bash session

docker exec -it atavdb bash