rds.DatabaseCluster: Support SecondsUntilAutoPause setting in Aurora Serverless V2

[yukihato]

Describe the feature

Since ACU can now be set to 0 in the following PR, I would like the SecondsUntilAutoPause setting to be supported as well.

#32231

reference: create-db-cluster api
https://docs.aws.amazon.com/cli/latest/reference/rds/create-db-cluster.html

Use Case

Use to set SecondsUntilAutoPause to something other than the default of 5 minutes.

Proposed Solution

No response

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.171.0

Environment details (OS name and version, etc.)

Node 22

[ashishdhingra]

@yukihato Good morning. Thanks for opening the issue. Looking at documentation for AWS::RDS::DBCluster ScalingConfiguration, SecondsUntilAutoPause is supported for Aurora Serverless v1 DB cluster. Looking at corresponding property AWS::RDS::DBCluster ServerlessV2ScalingConfiguration for Aurora Serverless v2 DB cluster, it only supports MaxCapacity and MinCapacity properties. The PR #32231 adds support for scaling to zero capacity for Amazon Aurora Serverless v2. Please re-validate your feature request.

Thanks,
Ashish

[yukihato]

@ashishdhingra Thanks for confirming. The SecondsUntilAutoPause options appear to be supported by the API, as shown in the API documentation below. (Also, these are values that can be changed in the actual AWS console.)
As you point out, it doesn't seem to be supported in CloudFormation yet, so I guess we are waiting for that to be addressed.

https://docs.aws.amazon.com/cli/latest/reference/rds/create-db-cluster.html

[ashishdhingra]

@yukihato Thanks for pointing out. We should refer AWS CLI V2 documentation at https://awscli.amazonaws.com/v2/documentation/api/latest/reference/rds/create-db-cluster.html. The API documentation at ServerlessV2ScalingConfiguration also appears to mention support for SecondsUntilAutoPause property. This needs support from CloudFormation. Could you please open an issue at https://github.com/aws-cloudformation/cloudformation-coverage-roadmap for the CloudFormation team? This way you would get email notifications for any progress made.

Thanks,
Ashish

[yukihato]

@ashishdhingra Thank you. I already submitted my request yesterday.
(As far as I can tell from checking the CloudFormation code, it is possible that perhaps the documentation has just not been modified to support it.)

aws-cloudformation/cloudformation-coverage-roadmap#2202

[yvele]

As far as I can tell from checking the CloudFormation code, it is possible that perhaps the documentation has just not been modified to support it.

@yukihato I've just tried with great hope, but unfortunately:

Properties validation failed for resource RdsCluster with message: [#/ServerlessV2ScalingConfiguration: extraneous key [SecondsUntilAutoPause] is not permitted]

[yukihato]

@yvele Thanks for trying! I must have been mistaken, sorry. We'll just have to wait for CloudFormation to take care of this...