[brudgers]

There's no generic solution to database problems.

They all depend on the specifics of the data and the specifics of access and the specifics of the use.

Then you make engineering tradeoffs per the CAP theorem.

Is the application launch-the-missiles critical?

Is it newest-lol-cat-pictures critical?

What's the network latency?

What is the CDN strategy?

How frequently does the data change?

How much data changes per second/minute/hour/day/week/month?

How much cache can you use?

Etc.

Good luck.