@Gargron cockroachdb is made for this use case, but that only solves the data layer problem.

You’d still need smart front end proxies to redirect based on client location, or even better use anycast DNS but that’s a pretty non-trivial setup.