(rds): Support Point-in-Time Database Cluster Recovery via L2 DatabaseCluster construct

[blimmer]

Describe the feature

As of March 2023, the AWS::RDS::DBCluster CloudFormation resource supports the RestoreToTime property.

It would be great if there were an L2-construct (ala DatabaseClusterFromSnapshot) that made restoring a database to a point-in-time simpler.

Use Case

The DatabaseClusterFromSnapshot construct is great if you have a snapshot you want to restore from. However, a Point-In-Time Recovery (PITR) might be preferable in disaster recovery scenarios.

Proposed Solution

Two ideas:

1. A new DatabaseClusterFromPointInTime construct
2. Create a new RestoredDatabaseCluster construct that encapsulates restoring from a point in time or a snapshot.

Creating a new construct feels more in line with what we have today for snapshots.

However, the second option feels "cleaner" because the same principals of restoring from a snapshot apply to the PITR option (a new database is created, etc.)

RestoredDatabaseCluster might take something like this:

export interface RestoredDatabaseProps extends DatabaseClusterBaseProps {
    // provide one or the other
    readonly snapshotIdentifier?: string;
    readonly restoreToTime?: string;
}

Other Information

Alternatively, you can reach into the L1 construct to set the RestoreToTime property.

In the past, to keep my database managed by CloudFormation/CDK, I've created a temporary new Database cluster via PITR (via the console), taken a snapshot, then used DatabaseClusterFromSnapshot.

Acknowledgements

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

CDK version used

2.84.0

Environment details (OS name and version, etc.)

MacOS

[aros3rg3d]

I'd love to have this 👍