Multi-tenant Saas apps made simple on Azure Cosmos DB for PostgreSQL

on YouTube ↗27m

" summary

Azure Cosmos DB for PostgreSQL is a managed Postgres service using the Citus extension that shards by a distribution key to scale writes and reads, supports row-based sharding that can host 100,000 tenants per 16 vCPU node (schema-based ≈ 4–10k, DB-per-tenant ≈ thousands), offers create_distributed_table/create_reference_table helpers, online node addition with rebalancer visibility (11.2) and per-tenant query/CPU stats (11.3), and lets operators isolate noisy tenants by moving their shard online.

AI-written summary · about

" chapters (9)

1. 0:00Introduction
2. 0:53Multi-tenant SaaS
3. 3:35Sharding models
4. 7:28Azure Cosmos DB for PostgreSQL
5. 11:29Data modeling & distribution keys
6. 15:35Table types
7. 20:25Modify your application
8. 21:20Monitoring
9. 25:13Scaling out

" related talks

• 44mMulti-tenant SaaS apps made simple on Azure Cosmos DB for PostgreSQLAdam Wolk, Alicja Kucharczyk · SQLBits 2023
• 18mBuilding Performant Data Architecture for Multi-Tenant SaaS AppsAvijit Gupta · Azure Cosmos DB: Liftoff 2022
• 52mBuilding Distributed OLTP with Azure Cosmos DB for PostgreSQLCharles Feddersen · SQLBits 2023
• 14mEasier Queries for Multi-Tenant SaaS AppsJoe Nelson · Azure Cosmos DB: Liftoff 2022
• 06mKeynote: Azure Cosmos DB for PostgreSQLKirill Gavrylyuk · Azure Cosmos DB: Liftoff 2022
• 02h 02mAzure Cosmos DB: LiftoffKirill Gavrylyuk, Estefani Arroyo, Iria Osara, Sai Krishna Srirampur, Claire Giordano · Azure Cosmos DB: Liftoff 2022
• 13mHow to do Data Modeling for Distributed Postgres in Azure Cosmos DBSai Krishna Srirampur · Azure Cosmos DB: Liftoff 2022
• 16mOnline Scale-Out and Cloud Data IngestionAdam Wolk · Azure Cosmos DB: Liftoff 2022