version: '3'

services:
  sonarqube:
    image: sonarqube:6.5
    container_name: sonarqube
    restart: always
    environment:
      - SONARQUBE_JDBC_URL=jdbc:mysql://db:3306/sonar?useSSL=true&useUnicode=true&characterEncoding=utf8
      - SONARQUBE_JDBC_USERNAME=sonar
      - SONARQUBE_JDBC_PASSWORD=sonar
    ports:
      - 9000:9000
      - 9002:9002
      - 9092:9092
    volumes:
      - ../../volumes/data/sonarqube/conf:/opt/sonarqube/conf
      - ../../volumes/data/sonarqube/data:/opt/sonarqube/data
      - ../../volumes/data/sonarqube/extensions:/opt/sonarqube/extensions
      - ../../volumes/data/sonarqube/lib/bundled-plugins:/opt/sonarqube/lib/bundled-plugins
    depends_on:
      - db

  grafana:
    container_name: grafana
    image: grafana/grafana
    ports:
      - 3000:3000
    volumes:
      - ../../volumes/data/grafana-storage:/var/lib/grafana
    restart: always
    depends_on:
      - db

  # mysql service for sonarqube & grafana
  db:
    image: mysql:5.7
    container_name: sonar-mysql
    restart: always
    environment:
      - MYSQL_DATABASE=sonar
      - MYSQL_USER=sonar
      - MYSQL_PASSWORD=sonar
      - MYSQL_ROOT_PASSWORD=Password1
      - MAX_ALLOWED_PACKET=13421772800
    volumes:
      - ../../volumes/data/mysql:/var/lib/mysql
    ports:
      - 3306:3306
    command: mysqld --max_allowed_packet=80M --federated --event_scheduler=1