Amazon Aurora Serverless v2 support

[pahud]

Description

Amazon Aurora Serverless v2 has been general available since April 2022 and this feature has become one of the most popular features from the community. This RFC aims to provide a developer-friendly design as an addition to the existing L2 constructs of aws-rds that allows users to easily add serverless v2 instances to a new or existing clusters.

Roles

Role	User
Proposed by	@pahud
Author(s)	@pahud
API Bar Raiser	@vinayak-kukreja
Stakeholders	@alias, @alias, @alias

See RFC Process for details

Workflow

• Tracking issue created (label: status/proposed)
• API bar raiser assigned (ping us at #aws-cdk-rfcs if needed)
• Kick off meeting
• RFC pull request submitted (label: status/review)
• Community reach out (via Slack and/or Twitter)
• API signed-off (label api-approved applied to pull request)
• Final comments period (label: status/final-comments-period)
• Approved and merged (label: status/approved)
• Execution plan submitted (label: status/planning)
• Plan approved and merged (label: status/implementing)
• Implementation complete (label: status/done)

---

Author is responsible to progress the RFC according to this checklist, and
apply the relevant labels to this issue so that the RFC table in README gets
updated.

[lielran]

Thanks all 😊