I have a database (~50GB in size) with content that is constantly changing, the challenge is that ideally, I need to have a copy of this live database in geographical local proximity; at a minimum in 3 primary zones, America, Europe, and Asia, but depending on the complexity, in further locations.
I know there's a number of ways to accomplish this with differing trade-offs, but wondering the thoughts of the community and how others might have met this challenge in the past? What methods were successful for you or how best would you tackle this problem?
In essence, the requirement is that data cannot be stale (e.g. updated in one location but not in the other) and transactions need to complete as quickly as they can.