[Enhancement]: update `aws_rds_cluster` to allow auto_pause when aurora engine_mode is `provisioned`

[luisrx7]

Description

According to this AWS documentation, it is now possible to set up auto-pause for Aurora in provisioned mode. However, the provider's documentation contradicts this by stating that auto-pause can only be configured if the cluster is in serverless mode. Conversely, through the console, it is possible to configure auto-pause for a cluster in provisioned mode.

Affected Resource(s) and/or Data Source(s)

aws_rds_cluster

Potential Terraform Configuration

serverlessv2_scaling_configuration {
    max_capacity = 256.0
    min_capacity = 0
    auto_pause               = true
    seconds_until_auto_pause = 300
  }

References

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless-v2-auto-pause.html#auto-pause-enabling-disabling

Would you like to implement a fix?

No

[github-actions[bot]]

Community Note

Voting for Prioritization

• Please vote on this issue by adding a 👍 reaction to the original post to help the community and maintainers prioritize this request.
• Please see our prioritization guide for information on how we prioritize.
• Please do not leave "+1" or other comments that do not add relevant new information or questions, they generate extra noise for issue followers and do not help prioritize the request.

Volunteering to Work on This Issue

• If you are interested in working on this issue, please leave a comment.
• If this would be your first contribution, please review the contribution guide.

[fatbasstard]

Yes, want to enable autoscaling back to 0 with a specific SecondsUntilAutoPause. Need this