2 RDS databases, replicated in active-active way, in different/same AZ

Question

Related question was https://repost.aws/questions/QUw6WLcMU1TPKZOC-OZ_h9Iw/2-rds-writable-databases-in-different-regions-synchronized-between-each-other , about the same problem, but about having databases replicated in active-active way, while databases being in different regions, as i have understood, without using something custom (non AWS provided) or using NoSQL databases, it is not really possible for multi regional solution.

The question is, if it is possible to have 2 RDS databases replicated in active-active way, while those databases being located in same AZ (but, it still should be ran on different hardware) or in different AZ. If it is possible, where i can find instructions on how to implement it in our setup?

Accepted Answer

Hi Joann Babak,
what you're asking for could in principle be fulfilled by [Aurora Multi-Master](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-multi-master.html).
**BUT**:

If you look at the documentation you'll see that it runs on Amazon Aurora MySQL-Compatible Edition v1 for which and [End-of-Life](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.MySQL56.EOL.html) announcement is out. I'm not aware of any Multi-Master successor.

With that in mind, a future-proof solution comes back to the answer already given in your related question: Use third-party replication between two instances.

**By the way**: Since recently there is a [Golden Gate Free Edition](https://blogs.oracle.com/post/oracle-goldengate-free) for databases up to 20 GB in size. If cost for the additional software license is your concern and your database(s) are within this limit, maybe this helps.

That aside: what are you trying to achieve that really, *really* requires a Multi-Master setup? Feel free to discuss below (also feel free to mark my answer as "helpful" ;-) )

Kind regards, Uwe

2 RDS databases, replicated in active-active way, in different/same AZ

Contenido relevante