aws-rds: Global database support for write forwarding?

[veho-mac]

Describe the feature

As of this issue, write forwarding is supported for MySQL Aurora global databases, but not for postgres. I think this feature is incredibly important for multi-region rds, as it simplifies the workflow immensely. As of a month ago there is support for active-active postgresql multi region using postgres extensions, and I was curious if there's a roadmap for this support natively through cdk

Use Case

Used to incredibly simplify architecture management on the dev side. It would make multi region rds way more usable.

Proposed Solution

No response

Other Information

No response

Acknowledgements

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

CDK version used

latest

Environment details (OS name and version, etc.)

Mac OS ventura 13.6

[khushail]

Hi @veho-mac , thanks for reaching out with this. This is on the cloudformation coverage roadmap as can be seen here.

[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.

[kcolemangt]

Amazon Aurora Global Database for PostgreSQL now supports write forwarding.

Enabling write forwarding in Aurora PostgreSQL.

[kcolemangt]

Hi @veho-mac , thanks for reaching out with this. This is on the cloudformation coverage roadmap as can be seen here.

@khushail, this can be implemented now that the CloudFormation coverage issue has been resolved.