Create MySQL RDS DB Instance

misterrvincent / acftsubmission

Technical write-up of how Zack and I created a web app to push fitness score submissions to an AWS database.

0 stars 0 forks source link

Open misterrvincent opened 1 year ago

misterrvincent commented 1 year ago

create instance
do not deploy HA, only single AZ to stay in free tier
enable encryption at rest using SSE-KMS customer key
assign allowed IP CIDR for private SUBNET of the VPC. Will attach IP's from within CIDR to the Lambda functions
CREATE TABLE acftscores
define columns, define input validation

misterrvincent commented 1 year ago

created MySQL db instance, set up scheduled start and stop at 0800 - 2200 Mon-Sun

misterrvincent commented 1 year ago

WHAT A PAIN to schedule stop and start. Created IAM policy, attached it to role and updated the trust relationship to reflect SSM access.