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

Question

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](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-multi-master.html). 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

NIRUPAM_d · Answer

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

NIRUPAM_d · Answer

Hello - no it is only in Aurora thanks

SSaxena · Answer

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.

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

Relevant content