온프레미스데이터 RDS로 이전하기 (MariaDB)

                                    // 전체 백업 명령어
// in mysqldump.exe 프로그램 경로
  "[mysqldump.exe path]" \
    -u root -p1234 \
    --single-transaction \
    --databases marketing marketing-follow marketing-image \
    marketing-like marketing-noti marketing-timeline marketing-user-profile \
    > "[dump saving path]\marketing_all_backup.sql"

                                    # ------------------------------------------------------------
# 1. AWS CLI 및 자격증명 확인
# ------------------------------------------------------------

aws --version
aws sts get-caller-identity

# 리전 확인
aws configure get region

# ------------------------------------------------------------
# 2. VPC / 네트워크 구성 확인
# ------------------------------------------------------------

# VPC 목록 확인
aws ec2 describe-vpcs \
  --query "Vpcs[*].[VpcId,Tags[?Key=='Name'].Value|[0],CidrBlock,IsDefault]" \
  --output table

# NACL 확인
aws ec2 describe-network-acls \
  --filters "Name=vpc-id,Values=[you_vpc_id]" \
  --query "NetworkAcls[*].[NetworkAclId,IsDefault,Entries]" \
  --output json

# Internet Gateway 확인
aws ec2 describe-internet-gateways \
  --filters "Name=attachment.vpc-id,Values=[you_vpc_id]" \
  --query "InternetGateways[*].[InternetGatewayId,Attachments[0].State]" \
  --output table

# ------------------------------------------------------------
# 3. Security Group 생성
# ------------------------------------------------------------

# 보안 그룹 생성
aws ec2 create-security-group \
  --group-name marketing-rds-sg \
  --description "Security group for Marketing RDS" \
  --vpc-id [you_vpc_id]

# 인바운드 규칙 추가 (3306 포트)
aws ec2 authorize-security-group-ingress \
  --group-id [your_sg_group_id] \
  --protocol tcp \
  --port 3306 \
  --cidr 0.0.0.0/0

# ------------------------------------------------------------
# 4. RDS 생성
# ------------------------------------------------------------

# RDS MariaDB 인스턴스 생성
aws rds create-db-instance \
  --db-instance-identifier marketing-db \
  --db-instance-class db.t3.micro \
  --engine mariadb \
  --engine-version 10.11 \
  --master-username [you_user_name] \
  --master-user-password [your_pw] \
  --allocated-storage 20 \
  --vpc-security-group-ids [your_security_group] \
  --publicly-accessible \
  --backup-retention-period 7 \
  --no-multi-az

# RDS 상태 확인
aws rds describe-db-instances \
  --db-instance-identifier marketing-db \
  --query "DBInstances[0].[DBInstanceStatus,Endpoint.Address,Endpoint.Port]" \
  --output text

# ------------------------------------------------------------
# 5. RDS 접속 및 데이터 복원
# ------------------------------------------------------------

# RDS 접속 테스트
"C:\Program Files\MariaDB 11.5\bin\mysql.exe" \
  -h [your-rds-endpoint] \
  -u [rds-user] \
  -p[rds-pw] \
  --ssl-verify-server-cert=false \
  -e "SELECT VERSION(); SHOW DATABASES;"

# 백업 데이터 복원
"C:\Program Files\MariaDB 11.5\bin\mysql.exe" \
  -h [your-rds-endpoint] \
  -u [rds-user] \
  -p[rds-pw] \
  --ssl-verify-server-cert=false \
  < "[mysqldummp-file-path]"