News Score: Score the News, Sort the News, Rewrite the Headlines

Geographically distributed Postgres for multi-tenant applications

We'd like to document a pattern for distributing Postgres databases to multiple regions or even multiple clouds. You can do this with any managed Postgres service or by self-hosting, because it doesn't rely on any functionality beyond what is available in a standard Postgres installation. In short, the pattern looks like this: Separate per-tenant data tables from the control plane tables.Place the per-tenant data tables in the region closest to where you expect the users to be.Create a global vi...

Read more at xata.io

© News Score  score the news, sort the news, rewrite the headlines