Search

SpringBoot x EC2 x RDS

SpringBoot x EC2 x RDS

1.
์‚ฌ์ „ ์ž‘์—… - AWS EC2 X RDS ์—ฐ๋™
2.
SpringBoot ์ƒ˜ํ”Œ ํ”„๋กœ์ ํŠธ ์ƒ์„ฑ
3.
๋ฐ์ดํ„ฐ ์†Œ์Šค ์„ค์ •
a.
RDS ์—”๋“œํฌ์ธํŠธ๋กœ ์„ค์ •
4.
ํ”„๋กœ์ ํŠธ ๋กœ์ปฌ ํ…Œ์ŠคํŠธ
5.
ํ”„๋กœ์ ํŠธ ๋ฐฐํฌ
6.
์„œ๋ฒ„ ํ…Œ์ŠคํŠธ

์‚ฌ์ „ ์ž‘์—…

EC2 X RDS ์—ฐ๋™ ์ž‘์—… ๋จผ์ € ํ•˜๊ณ  ์˜ค์„ธ์š”!

SpringBoot ์ƒ˜ํ”Œ ํ”„๋กœ์ ํŠธ ์ƒ์„ฑ

๋ฐ์ดํ„ฐ ์†Œ์Šค ์„ค์ •

โ€ข
๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค : MySQL
โ€ข
URL : RDS ์—”๋“œํฌ์ธํŠธ (aloha-aws-db.xxxxxxxx.com:3306)
โ€ข
username : admin
โ€ข
password : xxxxxx

RDS ์—”๋“œํฌ์ธํŠธ๋กœ ์„ค์ •

# ๐Ÿ’ป server spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver spring.datasource.url=jdbc:mysql://aloha-aws-db.xxxxxxxx.com:3306/aloha?serverTimezone=Asia/Seoul&allowPublicKeyRetrieval=true&useSSL=false&autoReconnection=true&autoReconnection=true spring.datasource.username=admin spring.datasource.password=xxxxxx
Java
๋ณต์‚ฌ

application.properties

spring.application.name=check spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver # ๐Ÿ‘ฉโ€๐Ÿ’ป local spring.datasource.url=jdbc:mysql://127.0.0.1:3306/aloha?serverTimezone=Asia/Seoul&allowPublicKeyRetrieval=true&useSSL=false&autoReconnection=true&autoReconnection=true spring.datasource.username=aloha spring.datasource.password=123456 # ๐Ÿ’ป server # spring.datasource.url=jdbc:mysql://aloha-qr-db.ctm4c4acm90g.ap-northeast-2.rds.amazonaws.com:3306/aloha?serverTimezone=Asia/Seoul&allowPublicKeyRetrieval=true&useSSL=false&autoReconnection=true&autoReconnection=true # spring.datasource.username=admin # spring.datasource.password=xxxxxx mybatis.configuration.map-underscore-to-camel-case=true mybatis.type-aliases-package=com.aloha.check.dto mybatis.mapper-locations=classpath:mybatis/mapper/**/**.xml
Java
๋ณต์‚ฌ

RDS ์—”๋“œํฌ์ธํŠธ

ํ”„๋กœ์ ํŠธ ๋กœ์ปฌ ํ…Œ์ŠคํŠธ

http://localhost:8080/checks
HTML
๋ณต์‚ฌ

ํ”„๋กœ์ ํŠธ ๋ฐฐํฌ

์„œ๋ฒ„ ํ…Œ์ŠคํŠธ

http://ec2-XXX-XXX-XXX-XXX.ap-northeast-2.compute.amazonaws.com:8080/checks
HTML
๋ณต์‚ฌ