I'm hoping this isn't so open ended that it veers towards a "discussion" more than an "answerable" question.
I need to place an RDS Postgres instance in an AWS region that will act as the master DB for writes from all other regions. Those regions will include Australian and European regions, as well as North American.
My concern is latency on writes. I will use replicas for reads, so that is not so much a concern.
I will be using interregion VPC peering for all regions to be able to communicate with the RDS instance.
I'm thinking that placing the RDS server in
us-west-2 as it seems to be in the most "central" spot for all regions of concern.
I understand that the AWS "backbone" is very fast, and perhaps fast enough not for this to be a concern.
Has anyone dealt with this problem and have any metrics or other ways to quantify a decision on where to place this RDS instance?