resource "random_password" "mysql_root_password" {
  length = 16
}

resource "aws_db_parameter_group" "wordpress_db_parameters_group" {
  name   = "${local.name_prefix}-wordpress"
  family = "mysql5.7"
}

resource "aws_db_option_group" "wordpress_db_options_group" {
  name                 = "${local.name_prefix}-wordpress"
  engine_name          = "mysql"
  major_engine_version = "5.7"
}
/*
resource "aws_db_subnet_group" "wordpress_db_subnet_group" {
  subnet_ids = module.main_private_subnets.subnet_ids

  depends_on = [
    module.main_private_subnets
  ]
}

resource "aws_db_instance" "wordpress_db_instance" {
  storage_type               = "gp2"
  instance_class             = "db.t3.small"
  engine_version             = "8.0.34"
  identifier                 = "${local.name_prefix}-wordpress-db"
  final_snapshot_identifier  = "${local.name_prefix}-wordpress-db-final"
  parameter_group_name       = aws_db_parameter_group.wordpress_db_parameters_group.name
  option_group_name          = aws_db_option_group.wordpress_db_options_group.name
  db_subnet_group_name       = aws_db_subnet_group.wordpress_db_subnet_group.name
  vpc_security_group_ids     = [module.main_sg_map.mysql_rds_id]
  publicly_accessible        = false
  backup_retention_period    = 7
  maintenance_window         = "Sun:07:00-Sun:10:00"
  backup_window              = "04:00-07:00"
  multi_az                   = false
  deletion_protection        = true
  apply_immediately          = true
  copy_tags_to_snapshot      = true
  auto_minor_version_upgrade = true
  snapshot_identifier        = "arn:aws:rds:us-east-1:703740486246:snapshot:qa-prodhub-wordpress-db-encrypted"
  storage_encrypted          = true
  kms_key_id                 = data.aws_kms_alias.default_rds.target_key_arn

  lifecycle {
    ignore_changes = [
      password,
      engine_version,
    ]
  }

  tags = merge(
    local.common_tags,
    {
      project                  = "Wordpress",
      service                  = "RDS",
      plat_env_project_service = "${local.aggregated_tag}_WP_RDS"
    }
  )
}
*/