By using AWS re:Post, you agree to the Terms of Use

Can i create a cross-region read-write replica with Amazon RDS?

0

I am in the process of setting up two VPCs in America and Europe. Both will contain a database that needs to continuously synchronize with the other.

I know that one can create a read-replica from an existing RDS database that can also be cross region. But this replica also needs to handle write queries. I've read that such a replica can easily be turned into a regular database by turning off the read-only option. But if i do that, will the database still synchronize with the master database it was replicated from? And will the master database update when i write something to the replicated database?

I know that there are better options for creating such a setup, like Amazon aurora Multi-master. But the problem with aurora multi-master is that it does not work cross region. There is also aurora global database, but that basically works with one read-write master instance and multiple read-only instances as well.

I need all my cross-region instances to be both synchronized and writable. Can i achieve this using only Amazon RDS?

Thank you

2 Answers
1

Dear Customer-> I'd request you to kindly check out write forwarding feature in Aurora - this may help in your poroject

[] Using write forwarding in an Amazon Aurora global database - https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-global-database-write-forwarding.html

Thanks

answered 14 days ago
  • Is write forwarding also available for an RDS read replica?

0

Hello - no it is only in Aurora thanks

answered 14 days 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