Post

[AWS] SpringBoot, MariaDB 연결하기

Posted Updated
By Keem
1 min read

[AWS] SpringBoot, MariaDB 연결하기

1. 패키지 설치

1. 설치 가능한 mariadb 패키지 검색

1

sudo yum search mariadb

2. Mariadb 설치

1

sudo yum install mariadb105-server.x86_64 -y

3. Mariadb 실행

1

sudo systemctl start mariadb

4. Mariadb root 비밀번호 설정

1

sudo mysql_secure_installation

5. 로그인 확인

1

sudo mysql -u root -p

2. 그외 설정

1. Docker 이미지 다운로드

1

docker pull mariadb

2. DB 생성 및 사용자 설정

1

sudo mysql -u root -p

1
2
3

create user 'tester'@'%' identified by 't1234';
grant all privileges on *.* to 'tester'@'%';
flush privileges;

3. SpringBoot 프로젝트 설정

1. build.gradle 의존성 추가

1
2
3

dependencies {
    implementation 'org.mariadb.jdbc:mariadb-java-client:3.1.0'
}

2. application.yml, application-local.yml 파일 생성

1. src/main/resources/application.yml

1
2
3
4
5
6
7
8
9

server:
  address: 0.0.0.0
  port: 8080

spring:
  application:
    name: springboot_ex
  profiles:
    active: local

2. src/main/resources/application-local.yml

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

spring:
  datasource:
    url: jdbc:mariadb://localhost:3306/test
    username: tester
    password: t1234
    driver-class-name: org.mariadb.jdbc.Driver

  jpa:
    hibernate:
      ddl-auto: update
    show-sql: true
    properties:
      hibernate:
        format_sql: true
        show_sql: true
      dialect: org.hibernate.dialect.MariaDBDialect

2. docker-compose.yml 수정

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33

version: '3.1'
services:
  mariadb:
    container_name: mariadb_container
    image: mariadb:latest
    restart: always
    ports:
      - "3306:3306"
    volumes:
      - "./mariadb/conf.d:/etc/mysql/conf.d"
      - "./mariadb/data:/var/lib/mysql"
    environment:
      MARIADB_DATABASE: test
      MARIADB_USER: tester
      MARIADB_PASSWORD: t1234
      MARIADB_ROOT_PASSWORD: "1234"

  application:
    container_name: backend_container
    build:
      context: ./
      dockerfile: Dockerfile
    ports:
      - "8080:8080"
    environment:
      SPRING_DATASOURCE_URL: jdbc:mariadb://mariadb:3306/test
      SPRING_DATASOURCE_USERNAME: "tester"
      SPRING_DATASOURCE_PASSWORD: "t1234"
    depends_on:
      - mariadb
    volumes:
      - ./src/main/resources/application.yml:/app/config/application.yml
    command: [ "java", "-jar", "app.jar", "--spring.config.location=file:/app/config/application.yml" ]

image 2

🔥 dbeaver 접속 성공

AWS, Deployment
aws
This post is licensed under CC BY 4.0 by the author.