docker-compose-multi-db.yml

version: '3.7'

networks:
  internal:
    ipam:
      config:
        - subnet: 172.30.0.0/24

x-mariadb-defaults: &mariadb-defaults
  # pin to 10.4 for compatibility
  image: mariadb:10.4
  restart: always
  labels:
    - com.centurylinklabs.watchtower.enable=true
  environment:
    MYSQL_ROOT_PASSWORD: CHANGEME

x-openenventory-defaults: &open_enventory-defaults
  restart: always
  build:
    context: .
    dockerfile: docker/openenventory
  volumes:
    - ./customization/:/var/www/html/customization/

services:
  # first instance
  database_1:
    <<: *mariadb-defaults
    networks:
      internal:
        ipv4_address: 172.30.0.21
    ports:
      - 127.0.0.1:33301:3306
    # keep in mind to check volume for /var/lib/mysql
    #volumes:
    #  - ./mariadb/database_1:/var/lib/mysql:rw

  openenventory_1:
    <<: *open_enventory-defaults
    environment:
      # make the name of the database server available via environment
      # variable
      DB_SERVER: database_1
      # hide the database name input field from the user
      SINGLE_DB: 1
    ports:
      - 127.0.0.1:8888:80
    # pin the IP of the container to
    # retain MySQL Grants which are based on the containers IP
    networks:
      internal:
        ipv4_address: 172.30.0.22
    depends_on:
      - database_1

  # another instance
  database_2:
    <<: *mariadb-defaults
    networks:
      internal:
        ipv4_address: 172.30.0.31
    ports:
      - 127.0.0.2:33302:3306
    # keep in mind to check volume for /var/lib/mysql
    #volumes:
    #  - ./mariadb/database_2:/var/lib/mysql:rw
  openenventory_2:
    <<: *open_enventory-defaults
    environment:
      # make the name of the database server available via environment
      # variable
      DB_SERVER: database_2
      # hide the database name input field from the user
      SINGLE_DB: 1
    ports:
      - 127.0.0.1:8889:80
    # pin the IP of the container to
    # retain MySQL Grants which are based on the containers IP
    networks:
      internal:
        ipv4_address: 172.30.0.32
    depends_on:
      - database_2