# Creating-Using-Managed-SQL-Databases-with-RDS-EC2

https://www.youtube.com/watch?v=zFhjh0ZeRhQ

https://github.com/academind/aws-demos/blob/main/extra-files/userdata/userdata-with-rds-database.sh

https://github.com/academind/aws-demos

https://raw.githubusercontent.com/RodrigoMvs123/Creating-Using-Managed-SQL-Databases-with-RDS-EC2/main/README.md

https://github.com/RodrigoMvs123/Creating-Using-Managed-SQL-Databases-with-RDS-EC2/blame/main/README.md


#!/bin/bash

# Enable logs
exec > >(tee /var/log/user-data.log|logger -t user-data -s 2>/dev/console) 2>&1

# Install Git
echo "Installing Git"
yum update -y
yum install git -y

# Install NodeJS
echo "Installing NodeJS"
touch .bashrc
curl -o- https://raw.githubusercontent.com/nvm-sh/nvm/v0.34.0/install.sh | bash
. /.nvm/nvm.sh
nvm install --lts

# Clone website code
echo "Cloning website"
mkdir -p /demo-website
cd /demo-website
git clone https://github.com/academind/aws-demos.git .
cd dynamic-website-with-database

# Install dependencies
echo "Installing dependencies"
npm install

# Forward port 80 traffic to port 3000
echo "Forwarding 80 -> 3000"
iptables -t nat -A PREROUTING -p tcp --dport 80 -j REDIRECT --to-ports 3000

# Install & use pm2 to run Node app in background
echo "Installing & starting pm2"
# Note: You might want to use AWS Secrets Manager instead of using environment variables
export DB_HOST=database-1.c9e925ldgsi8.us-east-1.rds.amazonaws.com
export DB_USER=admin
export DB_PASSWORD=Testers!
export DB_NAME=demo1
npm install pm2@latest -g
pm2 start app.js