[aws-rds] Supports defining variables for a CfnDBInstance in a DatabaseCluster

[hixi-hyi]

Add the following properties in DatabaseCluster.

autoMinorVersionUpgrade: boolean
allowMajorVersionUpgrade: boolean
deleteAutomatedBackups: boolean
enablePerformanceInsights: boolean

The most important one is autoMinorVersionUpgrade.

Use Case

autoMinorVersionUpgrade

When the database instance is automatically upgrade by AWS, drift is detected between cdk(cloudformation) and the actual resource, and the upgrade cannot be performed with cdk.
To work around this and deploy the cloudformation, you need to remove the RDS from the management target and re-include it. cdk does not support this.
We should be able to manage the migration in our own time.

Others (allowMajorVersionUpgrade, deleteAutomatedBackups, enablePerformanceInsights)

I'd like to set these parameters as well.

Proposed Solution

1. Define the properties below
   

   aws-cdk/packages/@aws-cdk/aws-rds/lib/props.ts

   Line 10 in 3c116f3

   export interface InstanceProps {

2. Pass properties to CfnDBInstance
   

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

   Line 590 in 3c116f3

   const instance = new CfnDBInstance(this, `Instance${instanceIndex}`, {

Other

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

---

This is a 🚀 Feature Request

[theo-beers]

To add to this: we received some mails from AWS where they actually advised to disable autoMinorVersionUpgrade to prevent stack drift.

[hixi-hyi]

The enablePerformanceInsights is implemented by #10092