Local On-Premise docker-compose

 

AWS ECR에 인증하기

Bash
# AWS ECR에 인증하기
aws ecr get-login-password --region ap-northeast-2 | docker login --username AWS --password-stdin 557571393534.dkr.ecr.ap-northeast-2.amazonaws.com
 
 

Docker compose 파일 만들기

 
vi docker-compose.yml
YAML
version: '3'
services:
  work-mysql:
    container_name: work-mysql_db
    restart: unless-stopped
    image: mysql
    environment:
      MYSQL_DATABASE: work-on-premise
      MYSQL_ROOT_HOST: '%'
      MYSQL_ROOT_PASSWORD: 1234
    ports:
      - "3306:3306"
    command:
      - "mysqld"
      - "--character-set-server=utf8mb4"
      - "--collation-server=utf8mb4_unicode_ci"
    networks:
      - my-network

  picking-mysql:
    container_name: picking-mysql_db
    restart: unless-stopped
    image: mysql
    environment:
      MYSQL_DATABASE: picking-on-premise
      MYSQL_ROOT_HOST: '%'
      MYSQL_ROOT_PASSWORD: 1234
    ports:
      - "3307:3306"
    command:
      - "mysqld"
      - "--character-set-server=utf8mb4"
      - "--collation-server=utf8mb4_unicode_ci"
    networks:
      - my-network

  tos-mysql:
    container_name: tos-mysql_db
    restart: unless-stopped
    image: mysql
    environment:
      MYSQL_DATABASE: tos-on-premise
      MYSQL_ROOT_HOST: '%'
      MYSQL_ROOT_PASSWORD: 1234
    ports:
      - "3308:3306"
    command:
      - "mysqld"
      - "--character-set-server=utf8mb4"
      - "--collation-server=utf8mb4_unicode_ci"
    networks:
      - my-network

  kafka:
    ports:
      - '9092:9092'
      - '9093:9093'
      - '9094:9094'
    image: 'bitnami/kafka:latest'
    environment:
      - KAFKA_CFG_NODE_ID=0
      - KAFKA_CFG_PROCESS_ROLES=controller,broker
      - KAFKA_CFG_LISTENERS=PLAINTEXT://:9092,CONTROLLER://:9093,EXTERNAL://:9094
      - KAFKA_CFG_LISTENER_SECURITY_PROTOCOL_MAP=CONTROLLER:PLAINTEXT,PLAINTEXT:PLAINTEXT,EXTERNAL:PLAINTEXT
      - KAFKA_CFG_CONTROLLER_QUORUM_VOTERS=0@kafka:9093
      - KAFKA_CFG_CONTROLLER_LISTENER_NAMES=CONTROLLER
      - KAFKA_CFG_AUTO_CREATE_TOPICS_ENABLE=true
      - KAFKA_CFG_SOCKET_REQUEST_MAX_BYTES=500000000
      - KAFKA_CFG_ADVERTISED_LISTENERS=PLAINTEXT://192.168.0.101:9092,EXTERNAL://192.168.0.101:9094
      - KAFKA_HEAP_OPTS=-Xmx2G -Xms2G
    networks:
      - my-network

  work-on-premise:
    container_name: work-on-premise
    restart: on-failure
    ports:
      - "8080:8080"
    image: '557571393534.dkr.ecr.ap-northeast-2.amazonaws.com/local-on-premise:work-stable'
    pull_policy: always
    environment:
      SPRING_DATASOURCE_URL: jdbc:mysql://work-mysql:3306/work-on-premise?collation=utf8mb4_bin
      SPRING_DATASOURCE_USERNAME: admin
      SPRING_DATASOURCE_PASSWORD: floaticionic1!
      SPRING_KAFKA_CONSUMER_BOOTSTRAP_SERVERS: kafka:9092
      SPRING_KAFKA_PRODUCER_BOOTSTRAP_SERVERS: kafka:9092
      SPRING_KAFKA_PRODUCER_KEY_SERIALIZER: org.apache.kafka.common.serialization.StringSerializer
      SPRING_KAFKA_PRODUCER_VALUE_SERIALIZER: org.springframework.kafka.support.serializer.JsonSerializer
      SPRING_KAFKA_PRODUCER_ACKS: all
      SPRING_KAFKA_PRODUCER_RETRIES: 3
      SPRING_JPA_HIBERNATE_DDL_AUTO: update
      SPRING_JPA_SHOW_SQL: true
      SPRING_CONFIG_ACTIVATE_ON-PROFILE: local-on-premise
      MSA_WORK_SERVICE_URL: http://192.168.0.101:8080
      MSA_PICKING_SERVICE_URL: http://192.168.0.101:8081
      MSA_WAVE_SERVICE_URL: http://192.168.0.101:8082
      KAFKA_PREFIX: prod
      JWT_SIGNING_KEY: 99e91969cfa42ba35e09f9103573386c9e528078c685b112c596e7e74309e01b5bde32f62df82891b87ea37db45f94e7e29b2da68e02a84d1979cc7aff459e12
    depends_on:
      - work-mysql
      - kafka
    networks:
      - my-network

  picking-on-premise:
    container_name: picking-on-premise
    restart: on-failure
    ports:
      - "8081:8080"
    image: '557571393534.dkr.ecr.ap-northeast-2.amazonaws.com/local-on-premise:picking-stable'
    pull_policy: always
    environment:
      SPRING_DATASOURCE_URL: jdbc:mysql://picking-mysql:3306/picking-on-premise?collation=utf8mb4_bin
      SPRING_DATASOURCE_USERNAME: admin
      SPRING_DATASOURCE_PASSWORD: floaticionic1!
      SPRING_KAFKA_CONSUMER_BOOTSTRAP_SERVERS: kafka:9092
      SPRING_KAFKA_PRODUCER_BOOTSTRAP_SERVERS: kafka:9092
      SPRING_KAFKA_PRODUCER_KEY_SERIALIZER: org.apache.kafka.common.serialization.StringSerializer
      SPRING_KAFKA_PRODUCER_VALUE_SERIALIZER: org.springframework.kafka.support.serializer.JsonSerializer
      SPRING_KAFKA_PRODUCER_ACKS: all
      SPRING_KAFKA_PRODUCER_RETRIES: 3
      SPRING_JPA_HIBERNATE_DDL_AUTO: update
      SPRING_JPA_SHOW_SQL: true
      SPRING_CONFIG_ACTIVATE_ON-PROFILE: local-on-premise
      MSA_WORK_SERVICE_URL: http://192.168.0.101:8080
      MSA_PICKING_SERVICE_URL: http://192.168.0.101:8081
      MSA_WAVE_SERVICE_URL: http://192.168.0.101:8082
      MSA_UNLOADING_SERVICE_URL: http://192.168.0.101:8080
      MSA_ROBOT_SERVICE_URL: http://192.168.0.101:8080
      MSA_UNLOADING_SERVICE_TOKEN: eyJhbGciOiJIUzUxMiJ9.eyJ0eXBlIjoiYWNjZXNzVG9rZW4iLCJhY2NvdW50VWlkIjoiUGpsajVFeDAiLCJlbWFpbCI6InAtcGlja2luZ0BmbG9hdGljLmlvIiwiZW50aXR5IjoiUF9QSUNLSU5HIiwiZXhwIjozMjYyMDYyOTYwfQ.WdfCRXcMfprisjxzxngS-VH_JpPeL0NccjMc9uXM2VY9n1iXKobOxCdNbtE_HJX6-DFruKeGjPoQSJuFMD16Nw
      MSA_ROBOT_SERVICE_TOKEN: eyJhbGciOiJIUzUxMiJ9.eyJ0eXBlIjoiYWNjZXNzVG9rZW4iLCJhY2NvdW50VWlkIjoiUGpsajVFeDAiLCJlbWFpbCI6InAtcGlja2luZ0BmbG9hdGljLmlvIiwiZW50aXR5IjoiUF9QSUNLSU5HIiwiZXhwIjozMjYyMDYyOTYwfQ.WdfCRXcMfprisjxzxngS-VH_JpPeL0NccjMc9uXM2VY9n1iXKobOxCdNbtE_HJX6-DFruKeGjPoQSJuFMD16Nw
      KAFKA_PREFIX: prod
      JWT_SIGNING_KEY: 99e91969cfa42ba35e09f9103573386c9e528078c685b112c596e7e74309e01b5bde32f62df82891b87ea37db45f94e7e29b2da68e02a84d1979cc7aff459e12
    depends_on:
      - picking-mysql
      - kafka
    networks:
      - my-network

  tos-on-premise:
    container_name: tos-on-premise
    restart: on-failure
    ports:
      - "8082:8080"
    image: '557571393534.dkr.ecr.ap-northeast-2.amazonaws.com/local-on-premise:tos-stable'
    pull_policy: always
    environment:
      SPRING_DATASOURCE_URL: jdbc:mysql://tos-mysql:3306/tos-on-premise?collation=utf8mb4_bin
      SPRING_DATASOURCE_USERNAME: admin
      SPRING_DATASOURCE_PASSWORD: floaticionic1!
      SPRING_JPA_HIBERNATE_DDL_AUTO: update
      SPRING_JPA_SHOW_SQL: true
      SPRING_CONFIG_ACTIVATE_ON-PROFILE: local-on-premise
      MSA_WORK_SERVICE_URL: http://192.168.0.101:8080
      MSA_PICKING_SERVICE_URL: http://192.168.0.101:8081
      MSA_WAVE_SERVICE_URL: http://192.168.0.101:8082
      JWT_SIGNING_KEY: 99e91969cfa42ba35e09f9103573386c9e528078c685b112c596e7e74309e01b5bde32f62df82891b87ea37db45f94e7e29b2da68e02a84d1979cc7aff459e12
    depends_on:
      - tos-mysql
    networks:
      - my-network

  rtm-on-premise:
    container_name: rtm-on-premise
    restart: on-failure
    ports:
      - "6397:6397"
    image: '557571393534.dkr.ecr.ap-northeast-2.amazonaws.com/local-on-premise:rtm-stable'
    pull_policy: always
    networks:
      - my-network

  centos:
    container_name: centos
    image: centos
    command: [ "sleep", "infinity" ]
    tty: true
    networks:
      - my-network

networks:
  my-network:
    driver: bridge
 
 

데이터베이스 계정 생성, 권한 부여, 테이블 생성

Bash
mysqlsh
(password) 1234
(save password question) n

\sql
CREATE USER IF NOT EXISTS 'admin'@'%' IDENTIFIED BY 'floaticionic1!';
# 서비스명 유의!
GRANT ALL PRIVILEGES ON `work-on-premise`.* TO 'admin'@'%';   
FLUSH PRIVILEGES;
  • 참고 이미지
    • notion image