How do you design a multi-tenant database? Shared table vs schema-per-tenant vs database-per-tenant.

Answer preview

Three models trade isolation against cost. Shared table (pool) puts every tenant in the same tables with a tenant_id discriminator. Schema-per-tenant keeps one set of tables per tenant inside one database. Database-per-tenant (silo) gives each tenant its own database or instance.…