#
# Anthony Vitale Jan 26, 2024
#  Changed ca_cert_identifier  from rds-ca-2019 to rds-ca-rsa2048-g1 for instance lsp-rds-pgdbspsme1-prod-global-instance-1
#
# Anthony Vitale Changed April 23 2025
#
# Anthony Vitale June 6, 2025 Changed Instance type of lsp-rds-pgdbspsme1-prod-global-instance-1 from db.r7g.4xlarge to db.r7g.8xlarge 
#
# Anthony Vitale Nov 13, 2025 Updated lsp-rds-pgdbspsme1-prod-global-instance-1 from V14 to V17
#
# Anthony Vitale Jan 21, 2026 
# Change Aurora Clusters auto_minor_version_upgrade to false to Correct Drift
#
#
# Anthony Vitale March 2 2026 
# Change Aurora Clusters auto_minor_version_upgrade to true to Correct Drift
# Change lsp-rds-pgdbspsme1-prod-global-instance-1 to V17.7 in next maint window
#

resource "aws_rds_cluster_instance" "lsp-rds-pgdbspsme1-prod-global-instance-1" {
  apply_immediately                     = null
  auto_minor_version_upgrade            = true
  availability_zone                     = "us-east-1b"
  ca_cert_identifier                    = "rds-ca-rsa2048-g1"
  cluster_identifier                    = aws_rds_cluster.lsp-rds-pgdbspsme1-prod-global-cluster-1.cluster_identifier
  copy_tags_to_snapshot                 = false
  db_parameter_group_name               = "default.aurora-postgresql17"
  db_subnet_group_name                  = "grps-p1-rds-sng"
  engine                                = "aurora-postgresql"
  engine_version                        = 17.7
  identifier                            = "lsp-rds-pgdbspsme1-prod-global-instance-1"
  identifier_prefix                     = null
  instance_class                        = "db.r7g.4xlarge"
  monitoring_interval                   = 5
  monitoring_role_arn                   = "arn:aws:iam::918817604416:role/rds-monitoring-role"
  performance_insights_enabled          = true
  performance_insights_kms_key_id       = "arn:aws:kms:us-east-1:918817604416:key/8aa5112c-73e0-4972-be1b-d189810cfce7"
  performance_insights_retention_period = 7
  preferred_backup_window               = "04:43-05:13"
  preferred_maintenance_window          = "sat:20:00-sat:20:30"
  promotion_tier                        = 1
  publicly_accessible                   = false
  tags = {
    Team-Name = "GRPS-RDX-RDXTRXMGR"
  }
  tags_all = {
    Team-Name = "GRPS-RDX-RDXTRXMGR"
  }
}