search

Team5-be01-Final-Project / .github

https://github.com/beyond-sw-camp/beyond-sw-camp-be01_last-dance
3 stars 0 forks source link

[ 수업 ] - (AWS.2) AWS RDS DB #36

Closed dhkdtld37 closed 5 months ago

dhkdtld37 commented 6 months ago
  1. 로그인 이후 인스턴스는 Ubuntu, t3 nano, 키 페어 생성, 기존 보안그룹 default로 생성
  2. RDS DB 생성 image

image

image

image

image

  1. 인바운드 규칙 추가
  2. ubuntu docker 설치 
    
$ for pkg in docker.io docker-doc docker-compose docker-compose-v2 podman-docker containerd runc; do sudo apt-get remove pkg; done

Add Docker's official GPG key:

$ sudo apt-get update $ sudo apt-get install ca-certificates curl $ sudo install -m 0755 -d /etc/apt/keyrings $ sudo curl -fsSL https://download.docker.com/linux/ubuntu/gpg -o /etc/apt/keyrings/docker.asc $ sudo chmod a+r /etc/apt/keyrings/docker.asc

Add the repository to Apt sources:

$ echo \ "deb [arch=$(dpkg --print-architecture) signed-by=/etc/apt/keyrings/docker.asc] https://download.docker.com/linux/ubuntu \ $(. /etc/os-release && echo "$VERSION_CODENAME") stable" | \ sudo tee /etc/apt/sources.list.d/docker.list > /dev/null

$ sudo apt-get update

$ sudo apt-get install docker-ce docker-ce-cli containerd.io docker-buildx-plugin docker-compose-plugin

5. 도커 허브에서 마리아db 설치

```bash
$ docker run --detach --name some-mariadb --env MARIADB_USER=example-user --env MARIADB_PASSWORD=my_cool_secret --env MARIADB_DATABASE=exmple-database --env MARIADB_ROOT_PASSWORD=my-secret-pw  mariadb:latest

$ sudo docker run --detach --name some-mariadb --env MARIADB_USER=example-user --env MARIADB_PASSWORD=my_cool_secret --env MARIADB_DATABASE=exmple-database --env MARIADB_ROOT_PASSWORD=my-secret-pw -p 6033:3306  maria db:10.11.6
  1. 접속 가능 여부 확인
$ telnet 43.206.192.18 6033
Trying 43.206.192.18...
Connected to 43.206.192.18.
...

$ telnet database-1.cfk80gswwvwq.ap-northeast-1.rds.amazonaws.com 3306
Trying 52.194.13.140...
Connected to ec2-52-194-13-140.ap-northeast-1.compute.amazonaws.com.
...
dhkdtld37 commented 6 months ago

MariaDB에 로그인

$ sudo docker run --detach --name some-mariadb --env MARIADB_USER=아이디
 --env MARIADB_PASSWORD=비밀번호 --env MARIADB_DATABASE=exmple-database 
--env MARIADB_ROOT_PASSWORD=루트 비번 -p 포트  mariadb:10.11.6