Migrating sonarqube to docker container. (DB: mysql)

migrating-sonarqube.md

Back up database sonar

mysqldump -v -h 127.0.0.1 -P 3306 -u root -p --default-character-set=utf8 sonar > sonar_backup.sql

Database recovery

mysql -u username -p database_name < backup_name.sql

For PosgreSQL

• https://github.com/SonarSource/docker-sonarqube/blob/master/recipes.md

sonarqube-compose.yml

version: '3'

services:
  sonarqube:
    image: sonarqube:lts
    depends_on:
      - db
    # restart: always
    ports:
      - "9000:9000"
    networks: 
      - sonarnet
    environment:
      - SONARQUBE_JDBC_USERNAME=sonar
      - SONARQUBE_JDBC_PASSWORD=sonar
      - SONARQUBE_JDBC_URL=jdbc:mysql://db:3306/sonar?useUnicode=true&characterEncoding=utf8&useSSL=false&rewriteBatchedStatements=true&useConfigs=maxPerformance
    volumes:
      - sonarqube_conf:/opt/sonarqube/conf
      - sonarqube_data:/opt/sonarqube/data
      - sonarqube_extensions:/opt/sonarqube/extensions
      - sonarqube_bundled-plugins:/opt/sonarqube/lib/bundled-plugins
  
  db:
    image: mysql:5.6
    command: --default-authentication-plugin=mysql_native_password
    # restart: always
      # uncomment following line if you want to mapping the MySQL port to host
      # - "3306:3306"
    networks: 
      - sonarnet
    environment:
      - MYSQL_ROOT_PASSWORD=example
      - MYSQL_DATABASE=sonar
      - MYSQL_USER=sonar
      - MYSQL_PASSWORD=sonar
    # None of the env variables has any effect if you mount a data directory that is not empty, 
    # See https://github.com/mysql/mysql-docker#docker-environment-variables
    # volumes:
    #   - db_data:/var/lib/mysql


networks:
  sonarnet:
    driver: bridge

volumes:
  sonarqube_conf:
  sonarqube_data:
  sonarqube_extensions:
  sonarqube_bundled-plugins:
  db_data: