1 Answers
Hi Justin,
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.
–Scott
Thanks for your input. I love DynamoDB’s Global Tables, however, it’s just not an option for the projects I’m working on. I think we’re going to use Aurora Global Database as it’s closer to the multi-region support we need without the heavy lifting of a home-grown data replication process. The only option I can see is to suffer the increased latency from having the secondary region write to the primary cluster. Perhaps I can solve this by routing the writer users to the primary region instead of controlling routing solely on latency. Although, I’d have to keep fail-over in mind if the primary region flips after a disaster. Hope AWS expands upon these features in the future; even if we have to suffer eventual consistency to enable it.