I think this question is more fitting for the Database Specialty discussion, although since that does not exist at this time and Aurora is the flagship relational database AWS is pushing I thought I would drop my question here instead.
I see that Aurora supports Multi-Master where my cluster has multiple instances that I can use for read and write.
I see that Aurora supports Global Database when a cluster has to exist in multiple regions at once.
Although, I can’t find any documentation that describes using these features together. I did find Write Forwarding for Global Database, but only for mySQL and I need PostgreSQL.
What I’m really looking for is a rational database similar to that of Azure Cosmos DB with multiple regions working together with the ability to write to any region.
I know it’s possible in AWS if I employ other services like EC2, CloudWatch Events, Lambda, etc.
Does Aurora supports this out-of-the-box?
If so, is there a walk-through guide I can follow?
I don’t think AWS has anything like this yet for PostgreSQL. As you found, Aurora’s multi-master and global database are kind of the two parts that you need, but are separated now. This is a challenging thing for relational database given the ACID constraints and latency among regions.
CosmosDB is NoSQL which is more conducive to this. AWS’s DynamoDB can do this too using global tables.