aws_cdk.aws_rds DatabaseCluster: Add seconds_until_auto_pause parameter to DatabaseCluster (python specifically)

[NikitaChekalinski]

Describe the feature

Currently, there are two parameters in DatabaseCluster for configuring auto-scaling: serverless_v2_min_capacity and serverless_v2_max_capacity. However, there is no way to set the idle duration before pausing in this high-level API. It would be great to have this option without having to use CfnDBCluster.

Use Case

We need it to stay with the high-level DatabaseCluster while being able to set this duration in CDK without migrating to the low-level CfnDBCluster. It also seems like a very common setting that many people need.

Proposed Solution

rds.DatabaseCluster(
    self, "Database",
    ...
    serverless_v2_min_capacity=0,
    seconds_until_auto_pause=300,
)

Other Information

No response

Acknowledgements

• I may be able to implement this feature request
• This feature might incur a breaking change

CDK version used

2.177.0

Environment details (OS name and version, etc.)

Python 3.12, macOS

[ashishdhingra]

L1 level CfnDBCluster.ServerlessV2ScalingConfigurationProperty does support optional secondsUntilAutoPause property. However, there is no such property in L2 DatabaseCluster construct to support lower level L1 secondsUntilAutoPause property.

This is also evident here.

There is a similar issue #32280, which was initially waiting for support from CloudFormation. CloudFormation had added support and L1 construct was also updated. User then contributed PR #32787 to add support to L2 construct. PR is pending review.

@NikitaChekalinski Please review if the related open issue #32280 and PR #32787 are same as your scenario. If yes, please close this issue as duplicate. I will bring this to team's attention to expedite PR review.

[NikitaChekalinski]

Thank you @ashishdhingra, it's related. I'll close this issue.

[github-actions]

Comments on closed issues and PRs are hard for our team to see.
If you need help, please open a new issue that references this one.