Skip to content

Instantly share code, notes, and snippets.

@adivinho
Created September 26, 2018 12:28
Show Gist options
  • Select an option

  • Save adivinho/3f22a5a54d66890548766cdeface2a11 to your computer and use it in GitHub Desktop.

Select an option

Save adivinho/3f22a5a54d66890548766cdeface2a11 to your computer and use it in GitHub Desktop.
version: "3"
services:
pmm-server:
image: "perconalab/pmm-server:dev-latest"
ports:
- "443:443"
environment:
- SERVER_USER=pmm
- SERVER_PASSWORD=pmm
ps:
image: "percona/percona-server:latest"
environment:
- MYSQL_ROOT_PASSWORD=secret
ports:
- "3306:3306"
pmm-client:
image: "perconalab/pmm-client:dev-latest"
environment:
- PMM_SERVER=pmm-server:443
- PMM_USER=pmm
- PMM_PASSWORD=pmm
- DB_TYPE=mysql
- DB_HOST=ps
- DB_PORT=3306
- DB_USER=root
- DB_PASSWORD=secret
depends_on:
- "ps"
- "pmm-server"
sysbench:
image: "perconalab/sysbench"
depends_on:
- "ps"
command: >
bash -c "
set -o xtrace
sleep 20
mysql \
--host=ps \
--port=3306 \
--user=root \
--password=secret \
-e 'CREATE DATABASE IF NOT EXISTS sbtest'
sysbench \
--db-driver=mysql \
--mysql-host=ps \
--mysql-port=3306 \
--mysql-user=root \
--mysql-password=secret \
--mysql-db=sbtest \
--mysql-table-engine=innodb \
--oltp-table-size=1000000 \
/usr/share/sysbench/tests/include/oltp_legacy/oltp.lua \
prepare
sysbench \
--rate=200 \
--threads=64 \
--report-interval=10 \
--time=0 \
--events=0 \
--rand-type=pareto \
--db-driver=mysql \
--mysql-host=ps \
--mysql-port=3306 \
--mysql-user=root \
--mysql-password=secret \
--mysql-db=sbtest \
--mysql-table-engine=innodb \
--oltp-reconnect \
--oltp-table-size=1000000 \
/usr/share/sysbench/tests/include/oltp_legacy/select.lua \
run
"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment