(rds): `DatabaseCluster` is missing the ability to specify `SecondsUntilAutoPause` on `ServerlessV2ScalingConfiguration`

[neilferreira]

Describe the feature

Serverless V2 provides the ability to set the minimum and maximum capacity of a Serverless V2 DB cluster. Alongside these properties, are the ability to dictate the number of seconds of inactivity that must be reached for the database to be auto paused.

The ability to specify SecondsUntilAutoPause is missing from CDK.

Use Case

To be able to automatically pause my database after a period of inactivity, with the default of 5 minutes being too low.

Proposed Solution

Update

aws-cdk/packages/aws-cdk-lib/aws-rds/lib/cluster.ts

Lines 867 to 877 in e9b5026

	serverlessV2ScalingConfiguration: Lazy.any({
	produce: () => {
	if (this.hasServerlessInstance) {
	return {
	minCapacity: this.serverlessV2MinCapacity,
	maxCapacity: this.serverlessV2MaxCapacity,
	};
	}
	return undefined;
	},
	}),

to include SecondsUntilAutoPause as per https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-rds-dbcluster-serverlessv2scalingconfiguration.html

Other Information

No response

Acknowledgements

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

CDK version used

v2.173.2

Environment details (OS name and version, etc.)

Any

[khushail]

Hi @neilferreira , thanks for requesting this.

On checking the cloudfrormation docs, here are my findings -

1. Cloudformation PR for adding this secondsUntilPause property merged just 15 hrs ago -feat(sources): update cfn-schema cdklabs/awscdk-service-spec#1502

├[~] service aws-rds
│ └ resources
│    └[~] resource AWS::RDS::DBCluster
│      └ types
│         └[~] type ServerlessV2ScalingConfiguration
│           └ properties
│              └[+] SecondsUntilAutoPause: integer

2. The Cloudformation document mentioning the L1 construct is still pending this update -https://docs.aws.amazon.com/cdk/api/v2/docs/aws-cdk-lib.aws_rds.CfnDBCluster.ServerlessV2ScalingConfigurationProperty.html
3. Cloudformation resource specification doc is also missing the update -https://d1uauaxba7bl26.cloudfront.net/latest/gzip/CloudFormationResourceSpecification.json

So I would request you to wait for sometime before it becomes available at L1 construct. Once that is done, pls feel free to submit a PR for the CDK L2 construct support.

Hope that would be helpful.
Thanks.

[mazyu36]

FYI: L1 is available now. #32582

[khushail]

@neilferreira , pls feel free to contribute L2 construct. Looking forward to your PR!