Help us improve the AWS re:Post Knowledge Center by sharing your feedback in a brief survey. Your input can influence how we create and update our content to better support your AWS journey.
Aurora PostgreSQL write forwarding
Does Aurora Global with PostgreSQL support “Write forwarding” from secondary clusters ?
if not how are the customers suppose to achieve this.
To put it the other way, how can they direct their application to do writes to the aurora cluster in a different region ? What should they do at networking level to make the write endpoint visible
Any guidance would be much appreciated. Thanks
FYI..
Customer has got a Primary Aurora Postgres cluster in eu-west-2
They have created a secondary read replica cluster in us-east-2
They can connect to the read only endpoint in us-east-2 from a us-east-2 ec2 instance
But cannot connect to the primary eu-west-2 cluster from us-east-2 (They are running an EC2 instance just to test the networking)
- Language
- English
- Newest
- Most votes
- Most comments
With write forwarding, Global Database will have the data needed to know where to send writes from the various endpoints and there will be no proxy needed for this. Writes originating in remote (non-writer) regions, will be forwarded from and received by the regional endpoint. All you need to make sure is you are sending write request from us-east-2 ec2 instance to us-east-2 endpoint. Make sure write forwarding is enabled on the secondary. Aurora handles the cross-Region networking setup.
Not yet supported for Aurora PostgreSQL
Write forwarding feature with Aurora Global databases for PostgreSQL is supported as of Nov'2023 https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-global-database-write-forwarding-apg.html
Relevant content
- asked a year ago
- AWS OFFICIALUpdated 5 months ago
- AWS OFFICIALUpdated a year ago
It supported for Aurora PostgreSQL starting Nov'2023