Design multitenant SaaS apps by using Azure Cosmos DB for PostgreSQL

Intermediate
Developer
Azure
Azure Cosmos DB

Azure Cosmos DB for PostgreSQL provides a powerful data platform for multitenant software as a service (SaaS) applications. Starting from a single-node instance, a multitenant database can be horizontally scaled to a multi-node distributed cluster of up to 20 servers to meet the demands of tenant growth.

Learning objectives

By the end of this module, you'll be able to:

  • Prepare tables that are in a single-node database for distribution.
  • Transition from a single-node database to a multi-node database by using Azure Cosmos DB for PostgreSQL.
  • Distribute multitenant tables with minimal application impact.
  • Monitor the utilization of multitenant databases by using Azure Cosmos DB for PostgreSQL.

Prerequisites

  • Basic familiarity with relational databases, including creating and updating tables, creating indexes, and querying tables.
  • An intermediate understanding of distributed database concepts, such as distribution column selection, sharding, table colocation, and table types.