# 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

```bash
#!/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=...
export DB_USER=...
export DB_PASSWORD=...
export DB_NAME=...
npm install pm2@latest -g
pm2 start app.js
```