Support for RDS Blue Green Deployments

[aarongundel]

Name of the resource

AWS::RDS::DBInstance

Resource name

No response

Description

A new feature announced at re:invent was the ability to do blue-green deployments in RDS. This sounds very useful; but appears to be unsupported in cloudformation at this time based off the documentation (see link). Are there any plans to include it?

Other Details

Overview of Amazon RDS Blue/Green Deployments

[khebul]

Unfortunately, there are currently no plans to support Blue-Green Deployments in CFN.

[ckpuneeth]

+1

[damnhandy]

Unfortunately, there are currently no plans to support Blue-Green Deployments in CFN.

Is there a reason for that? ECS didn't support this for years, and the only way to do blue/green was via Code Deploy. Now you can do it via CloudFormation. It would be great to do something along the similar lines.

[honeyfordd]

I'm just looking at upgrading from MySQL 5.7 to 8.0 and would have been great to use Blue-Green deployments however our RDS instance is managed by CloudFormation. Any news on this feature being added?

[jalvarezferr]

+1

[bdekonin]

+1

[icorbett]

+1

[im-parris]

+1

[CompuGlobalHyperMegaNet-VP]

+1

[blimmer]

This is showing up as "Shipped", but I don't think that's accurate, right? I don't see support in the docs.

[meymeynard]

any news?

[yavor-atanasov]

Just to chime in - we manage all our infrastructure in CloudFormation and any feature (like the RDS Blue/Green in this case) that's not supported in CloudFormation is a non-starter. I wish all teams/products in AWS actively contribute to or even maintain CloudFormation as a first class citizen API for their services (instead of having a separate CloudFormation team on the side always playing catchup). I get it's not easy organisationally, but this way CloudFormation is effectively a gatekeeper to new features on AWS.

[victor-upmeet]

+1 for this feature

Is there any workaround to create a B/G deployment outside CF, and then sync somehow the stack managing the RDS cluster/instances? The goal would be to apply updates to the engine version.

[minhio]

+1 for this feature

Is there any workaround to create a B/G deployment outside CF, and then sync somehow the stack managing the RDS cluster/instances? The goal would be to apply updates to the engine version.

@victor-upmeet , i'm going through the same exercise, here are some resources i've found that may help

• https://ruempler.eu/2023/10/08/zero-downtime-upgrade-aws-aurora-mysql5-7-8-0-with-blue-green/
• https://medium.com/@kilian.cm.94/upgrade-aurora-postgresql-engine-version-by-using-blue-green-deployments-with-cdk-and-aws-cli-62d3b2097608

in a nutshell

• deploy your rds stack via cdk
• create/switch blue/green using aws cli (this will cause a drift)
• fix the drift

the examples are in cdk, but you can probably do the same via cloudformation