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