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

3 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

AWS
EXPERT
answered 2 years ago
  • Is write forwarding also available for an RDS read replica?

0

Hello - no it is only in Aurora thanks

AWS
EXPERT
answered 2 years ago
0

Amazon RDS do provides option for cross region Read replica's across multiple engines keeping in consideration the License and version , though for exclusive master-master configuration you can follow certain unconventional methods like :-

  1. DMS replication across RDS instances - Certain considerations would be to handle collisions for Bi-directional replication & VPC peering.
  2. You can also try to configure the MySql_master-mysql_master replication in case of MySql provided RDS MySql supports Mysql_slave to another MySql instance likewise. http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/mysql_rds_set_external_master.html

Please feel free to connect if you like any further help.

AWS
SSaxena
answered 10 months 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