docker-compose.yml

version: "2.2"
services:
  mysql-m1:
    image: "percona:5.7-jessie"
    volumes:
      - /var/lib/mysql
    command: --server-id=1
      --log-bin=mysql-bin
      --binlog-format=ROW
      --sync-binlog=1
      --log-slave-updates=ON
      --gtid-mode=ON
      --enforce-gtid-consistency=ON
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_unicode_ci
      --max-connections=4096
    environment:
      MYSQL_ALLOW_EMPTY_PASSWORD: "yes"
    # cpus: 2
    ulimits:
      nproc: 4096
      nofile:
        soft: 20000
        hard: 40000
    ports:
      - "33061:3306"

  proxysql-1:
    image: "gcr.io/shopify-docker-images/apps/production/proxysql:latest"
    command: proxysql -f --idle-threads --initial
    volumes:
      - ./config/proxysql.cnf:/etc/proxysql.cnf
      - ./config/my.cnf:/root/.my.cnf
    ulimits:
      nproc: 1024
      nofile:
        soft: 20000
        hard: 40000
    # cpus: 2
    ports:
      - "33062:3306"

  proxysql-2:
    image: "gcr.io/shopify-docker-images/apps/production/proxysql:latest"
    command: proxysql -f --idle-threads --initial
    volumes:
    - ./config/proxysql.cnf:/etc/proxysql.cnf
    - ./config/my.cnf:/root/.my.cnf
    ulimits:
      nproc: 1024
      nofile:
        soft: 20000
        hard: 40000
    # cpus: 2
    ports:
      - "33063:3306"