multi-master over multi-region Aurora - possible?

Question

I am relatively experienced with many AWS services - but I do have a large gap around Aurora/RDS

I'm trying to create a multi-region multi-master (write replicas) setup

The purpose is to give low latency to users (if each read and write replica is in the user's region) and to give resilience (if there is a region outage, the users can have their requests routed to another region (the latency will be higher, but reduced service is better than no service))

I'm trying to learn about AWS Aurora and I've created a toy cluster to learn. It seems I can create a cluster that is served out of multiple regions (and Aurora replicates data between regions automatically). I've also read that it is possible to have a multi-master setup (in my toy cluster, it only had one write partition, I couldn't work out how to create another write partition in another region, which made me question if it's possible?)

Here is a diagram of what I'm thinking:

https://i.stack.imgur.com/bfigZ.jpg

Thank you in advance!

Answer 1

As others have said, with Amazon Aurora, you cannot deploy multi-Region and multi-master. However you can deploy multi-Region using Aurora Global Database. Then one writer endpoint would be in one Region, while reader endpoints would be available in all the other Regions. Then you can also use write forwarding (assuming you are using the MySQL flavor of Aurora) in the read-only Regions. I know latency is a concern for you, so note the write actually goes back to the primary Region, so writes will incur that extra latency.

Answer 2

As mentioned earlier it is not possible with Aurora.

However DynamoDB supports multi-active multi-region:

https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/GlobalTables.html

Answer 3

The purpose is to give low latency to users and to give resilience.

Then you can use Amazon Aurora Global Database. This solution provides replication from the Aurora storage layer across Regions. The reader endpoint in the secondary endpoint can be promoted in the event of a DR scenario to be the main database which takes on read/write responsibilities.

Answer 4

The purpose is to give low latency to users (if each read and write replica is in the user's region)

I couldn't work out how to create another write partition in another region, which made me question if it's possible?

That is not possible (at least not currently) because of multi-master Aurora limitations.

• all DB instances in a multi-master cluster must be in the same AWS Region.

and others such as

• you can have a maximum of two DB instances in a multi-master cluster
• You can't enable cross-Region replicas from multi-master clusters.

You can read more here

---

The best thing you can do in your scenario is to create single master and place read replicas into those additional regions (possibly with some caching in necessary).