Can I have a node in specific geo location

93316825 0 Reputation points
2023-03-20T20:39:42.22+00:00

Hi,

I am trying to figure out if Azure Citus is a good option for a multi-tenancy scenario where some tenants need to have their data store in specific geo region.

This implies that we would have bulk of tenants on one node and some that need their data living in a specific geo location which is not the geo location of the node.

My guess is that I will need a node per tenant unless those "special" tenants have the same geo location requirement?

What I am confused about is that I haven't found an option to have nodes spread on different geo location when I have been looking around in Azure Portal.
Any hints and/or advices are welcome.

Regards,

Mirza

Azure Database for PostgreSQL
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 27,717 Reputation points Microsoft Employee
    2023-03-21T01:22:23.5033333+00:00

    @93316825 Welcome to the Microsoft Q&A forum, Thanks for posting your question.

    Azure Cosmos DB for PostgreSQL, Hyperscale (Citus), is a great option for multi-tenant / SaaS applications. Distributed Postgres database sharded by tenant provides elevated performance due to its multi-node nature and you can use tenant isolation for big important tenants. You can get started by following this quick start guide and by using this tutorial for multi-tenant apps.

     Tenant isolation has been a signature feature of Citus for years. You can check this blog post about tenant isolation in Citus, all of it is applicable to Azure Cosmos DB for PostgreSQL.

     All of this is applicable to a cluster provisioned in a single Azure region. Once you start thinking about various geo-locations, you may want to take a look at the cluster read replication feature in Azure Cosmos DB for PostgreSQL. This feature allows you to create a read-only cluster in any supported Azure region. That allows you to scale your reads by offloading them of your primary cluster.

     Today Azure Cosmos DB for PostgreSQL doesn't support writes to the same database in multiple regions. To deliver high performance for a cluster mentioned above latency between the nodes in that cluster needs to be low and we can achieve that only if all nodes in a cluster are in the same Azure region.

    I hope this information helps.

    If you think your question has been answered, click "Mark as Accept Answer",This can be beneficial to other community members reading this forum thread.

    Regards

    Geetha