docker-compose.yml

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-ps:
    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-ps:
    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
        "
  postgres:
    image: postgres
    environment:
     - POSTGRES_USER=postgres
     - POSTGRES_PASSWORD=secret
    ports:
     - "5432:5432"

  pmm-client-postgres:
    image: "perconalab/pmm-client:dev-latest"
    environment:
     - PMM_SERVER=pmm-server:443
     - PMM_USER=pmm
     - PMM_PASSWORD=pmm
     - DB_TYPE=postgresql
     - DB_HOST=postgres
     - DB_PORT=5432
     - DB_USER=postgres
     - DB_PASSWORD=secret
    depends_on:
     - "postgres"
     - "pmm-server"

  mongo:
    image: mongo
    environment:
     - MONGO_INITDB_ROOT_USERNAME=mongo
     - MONGO_INITDB_ROOT_PASSWORD=secret
    ports:
     - "27017:27017"

  pmm-client-mongo:
    image: "perconalab/pmm-client:dev-latest"
    environment:
     - PMM_SERVER=pmm-server:443
     - PMM_USER=pmm
     - PMM_PASSWORD=pmm
     - DB_TYPE=mongodb
     - DB_ARGS=--uri=mongodb://mongo:secret@mongo:27017
    depends_on:
     - "mongo"
     - "pmm-server"