resource “aws_db_instance” “dbrole” {
name = var.dbnames
engine = “mysql”
engine_version = “”
instance_class = “db_t3_micro”
storage_type = “gp2”
allocated_storage = 30
allow_major_version_upgrade = false
auto_minor_version_upgrade = false
publicly_accessible = false
db_subnet_group_name = aws_db_subnet_group.mygrp.id
multi_az = true
apply_immediately = true
port = var.ports[3]
maintenance_window = “Fri:20:00-Fri:23:00”
skip_final_snapshot = true
deletion_protection = true
delete_automated_backups = true
username = file("./users.txt")
password = file("./pass.txt")
backup_retention_period = 7
backup_window = “10:00-11:00”
vpc_security_group_ids = [aws_security_group.secure3role.id]
}
resource “aws_db_subnet_group” “mygrp” {
subnet_ids = [aws_subnet.sbnt3[0].id, aws_subnet.sbnt3[1].id, aws_subnet.sbnt3[2].id]
}
for read repilca in diffirent availability in us-east-1c
resource “aws_db_instance” “dbroleread” {
name = “east1dbread”
engine = “mysql”
engine_version = “”
instance_class = “db_t3_micro”
storage_type = “gp2”
allocated_storage = 30
allow_major_version_upgrade = false
auto_minor_version_upgrade = false
publicly_accessible = false
db_subnet_group_name = aws_db_subnet_group.mygrp.id
multi_az = false
apply_immediately = true
port = var.ports[3]
maintenance_window = “Fri:20:00-Fri:23:00”
skip_final_snapshot = true
deletion_protection = true
delete_automated_backups = true
username = file("./users.txt")
password = file("./pass.txt")
backup_retention_period = 7
backup_window = “10:00-11:00”
vpc_security_group_ids = [aws_security_group.secure3role.id]
replicate_source_db = aws_db_instance.dbrole.id
availability_zone = var.zones[2]
}