resource "aws_rds_cluster_instance" "msrv_rds_prod_01" {
  apply_immediately                     = true
  auto_minor_version_upgrade            = true
  availability_zone                     = "us-east-1b"
  ca_cert_identifier                    = "rds-ca-rsa2048-g1"
  cluster_identifier                    = "msrv-rds-prod-01"
  copy_tags_to_snapshot                 = false
  db_parameter_group_name               = "msrv-rds-prod-db-pg-80"
  db_subnet_group_name                  = "msrv-p-rds"
  engine                                = "aurora-mysql"
  engine_version                        = "8.0.mysql_aurora.3.08.2"
  identifier                            = "msrv-rds-prod-01"
  instance_class                        = "db.r6g.large"
  monitoring_interval                   = 60
  monitoring_role_arn                   = "arn:aws:iam::361463692799:role/rds-monitoring-role"
  performance_insights_enabled          = true
  performance_insights_kms_key_id       = "arn:aws:kms:us-east-1:361463692799:key/46219473-a94b-4e07-996a-6785ac63f844"
  performance_insights_retention_period = 7
  preferred_backup_window               = "03:00-03:30"
  preferred_maintenance_window          = "sat:06:49-sat:07:19"
  promotion_tier                        = 1
  publicly_accessible                   = false
  tags                                  = {}
  tags_all                              = {}
}

resource "aws_rds_cluster_instance" "msrv_rds_prod_01_ro" {
  #checkov:skip=CKV_AWS_226: Ensure DB instance gets all minor upgrades automatically
  apply_immediately                     = true
  auto_minor_version_upgrade            = false
  availability_zone                     = "us-east-1a"
  ca_cert_identifier                    = "rds-ca-rsa2048-g1"
  cluster_identifier                    = "msrv-rds-prod-01"
  copy_tags_to_snapshot                 = false
  db_parameter_group_name               = "msrv-rds-prod-db-pg-80"
  db_subnet_group_name                  = "msrv-p-rds"
  engine                                = "aurora-mysql"
  engine_version                        = "8.0.mysql_aurora.3.08.2"
  identifier                            = "msrv-rds-prod-01-ro"
  instance_class                        = "db.r6g.large"
  monitoring_interval                   = 60
  monitoring_role_arn                   = "arn:aws:iam::361463692799:role/rds-monitoring-role"
  performance_insights_enabled          = true
  performance_insights_kms_key_id       = "arn:aws:kms:us-east-1:361463692799:key/090411cd-356d-4f2b-afb7-5ac3862fa479"
  performance_insights_retention_period = 7
  preferred_backup_window               = "03:00-03:30"
  preferred_maintenance_window          = "sat:06:49-sat:07:19"
  promotion_tier                        = 1
  publicly_accessible                   = false
  tags                                  = {}
  tags_all                              = {}
}