IaC - RDS DB

[starkmatt]

RDS DB Code

Within this code, I've made a few changes when compared to my first revision of the RDS Code. It contains 3 files.

• sg.tf
• rds.tf
• variables.tf

SG.tf

• Here I have placed the relevant Security groups that will connect the DB to the VPC and to the resources we have created. There will many many additions to this file as the solution evolves.

variables.tf

• Using the existing variables file, I've added a few entries with regards to the DB Cluster Creation.

RDS.tf

• So here, I've added additional resources to help with the DB creation under the guidance of Kiko. What added now are

• aws_rds_cluster

• aws_rds_cluster_instance

• aws_db_subnet_group

It will create in the following AZ's (ap-southeast-2a /b) Running Serverless engine version 5.7.12

To run this please clone the repo and run

terraform init terraform plan terraform apply

Unfortunately there is a bug upon creation. Terraform advised the following during the apply phase

Error: error creating RDS cluster: InvalidParameterValue: The engine mode serverless you requested is currently unavailable. status code: 400, request id: 8596d824-df61-4457-9338-33cf4c0752be

https://github.com/terraform-providers/terraform-provider-aws/issues/5593 Git Issue #5593 on Terraform repo advises that this issue may be with serverless requiring a specific engine when running.

As per Kiko's instruction located here https://github.com/devopsacademyau/2020-feb-project1-group2/issues/14

Adding Aurora (MySQL 5.7) 2.07.2 Doesn't seem to work either.

Please let me know your thoughts regarding this Team!

[starkmatt]

RDS DB Code v0.3

• Made changes to the RDS File.
• Added Output File for Password

Please test and advise

[kikobr82]

few comments not resolved yet. Also, you have a conflict in the variables file that needs to be solved.