SpringBoot x EC2 x RDS
1.
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
๋ณต์ฌ