(RDS): Scheduling modifications on RDS Instance/Cluster bug

[dhruvdakoria]

Noticing inconsistent behavior when modifying RDS instance/cluster. Attribute like IAM Database Authentication gets applied on next scheduled maintenance window whereas all other changes like backup window modification, backup retention modification, instance size/settings update, maintenance window updates etc. get applied immediately.

The console provides with an option to apply this changes either immediately or during the next maintenance window. There is no such option when doing modifications/updates with CDK. Is this something that can be implemented as a property which will decide the modification time?

Environment

• CDK CLI Version : 1.76
• Framework Version:
• Node.js Version: v10.22
• OS : Linux
• Language (Version): TypeScript (3.8.3)

---

This is 🐛 Bug Report

[skinny85]

Hey @dhruvdakoria ,

thanks for opening the issue. I wonder if that level of control that you showed in the AWS Console is even available when using CloudFormation (which is the service that CDK uses to provision and update the databases).

I've checked the properties of the CloudFormation DBInstance resource, and I can't find anything that would allow setting those...

[github-actions]

This issue has not received a response in a while. If you want to keep this issue open, please leave a comment below and auto-close will be canceled.

[dhruvdakoria]

Hi Adam, yes you’re right. CFN doesn’t support that level of control yet. I’ll open a ticket with them. Thanks!

[github-actions]

⚠️COMMENT VISIBILITY WARNING⚠️

Comments on closed issues are hard for our team to see.
If you need more assistance, please either tag a team member or open a new issue that references this one.
If you wish to keep having a conversation with other community members under this issue feel free to do so.

[skinny85]

Thanks @dhruvdakoria . Feel free to link back here, and we can re-open the issue when CloudFormation support is available.

[sturdeac]

Are there any updates on this issue? I'm currently looking for a solution to make changes apply immediately with CDK.

[skinny85]

@dhruvdakoria any news?

[bates-sdx]

I wrote into AWS Support today about this and they said there is a feature request for this but no update. This seems to still be pending support from CloudFormation and nothing can be done from CDK side.