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 Respostas
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
ESPECIALISTA
respondido há 2 anos
  • Is write forwarding also available for an RDS read replica?

0

Hello - no it is only in Aurora thanks

AWS
ESPECIALISTA
respondido há 2 anos
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
respondido há 10 meses

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas