By using AWS re:Post, you agree to the Terms of Use
/Aurora PostgreSQL write forwarding/

Aurora PostgreSQL write forwarding

0

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)

asked 2 years ago29 views
1 Answers
0
Accepted Answer

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

EXPERT
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions