terraform-aws-rds-instance

This module creates AWS RDS Database for mysql.

You can use below module in 2 different ways.

1. You can create your own .tf file, copy and paste this module in it and give values directly to variables as below:

module "db_mysql" {
  source = "github.com/janashj/terraform-aws-rds-instance"
  region = "us-east-2"
  subnet_ids = [
    "subnet-yoursubnetid",
    "subnet-yoursubnetid",
    "subnet-yoursubnetid"
  ]
  identifier          = "mydb"
  allocated_storage   = 20
  storage_type        = "gp2"
  engine              = "mysql"
  engine_version      = "5.7"
  instance_class      = "db.t2.micro"
  username            = "foo"
  password            = "foobarbaz"
  publicly_accessible = true

  db_access = [
    "50.194.68.230/32",
    "50.194.68.231/32",
    "0.0.0.0/0"
    ]
}

2. or, in this case you have to create 3 files, 1 module.tf, 1 region.tfvars, 1 variables.tf. Copy and paste below codes to those 3 files:

module.tf:

module "db_mysql" {
  source              = "github.com/janashj/terraform-aws-rds-instance"
  region              = var.region
  subnet_ids          = var.subnet_ids
  identifier          = var.cluster_identifier
  allocated_storage   = var.allocated_storage
  storage_type        = var.storage_type
  engine              = var.engine
  engine_version      = var.engine_version
  instance_class      = var.instance_class
  username            = var.username
  password            = var.password
  publicly_accessible = var.publicly_accessible
  db_access           = var.db_access
}

region.tfvars:

region = "us-east-2"
subnet_ids = [
  "subnet-yoursubnetid",
  "subnet-yoursubnetid",
  "subnet-yoursubnetid"
]
identifier          = "mydb"
allocated_storage   = 20
storage_type        = "gp2"
engine              = "mysql"
engine_version      = "5.7"
instance_class      = "db.t2.micro"
username            = "foo"
publicly_accessible = true

db_access = [
  "50.194.68.230/32",
  "50.194.68.231/32",
  "0.0.0.0/0"
]

variables.tf:

variable "region" {}
variable "subnet_ids" {
  type = list(any)
}
variable "db_access" {
  type = list(any)
}
variable "identifier" {}
variable "allocated_storage" {}
variable "engine" {}
variable "storage_type" {}
variable "engine_version" {}
variable "instance_class" {}
variable "username" {}
variable "password" {}
variable "publicly_accessible" {}

/* module cant pull the value of each resource, so if we want to use output, then output.tf file should be created first. Optionally, you can copy and paste below code inside your module.tf file for outputs.

Note: output.tf file is created in the repository, so no need to create here, go ahead with pasting this code if you need outputs.

*/

output "region" {
  value = module.db_mysql.region
}
output "subnet_list" {
  value = module.db_mysql.subnet_list
}
output "db_access" {
  value = module.db_mysql.db_access
}
output "DB_name" {
  value = module.db_mysql.DB_name
}
output "endpoint" {
  value = module.db_mysql.Endpoint
}

To run:

With 1st option you have to run:

terraform init

terraform apply

---

With 2nd option you have to run:

terraform init

terraform apply -var-file region.tfvars

---

Please note: password is saved in AWS SSM