How should the first release isolate tenant records?
- Shared database with mandatory tenant scope
- Separate schema or database per tenant
Choose: Start with a shared database and a mandatory tenant key for a small SaaS first release, backed by centralized server authorization and cross-tenant tests. Move to stronger physical separation only for a concrete compliance, scale, or customer requirement.
Tradeoff: A shared database is simpler to operate and migrate but makes every query boundary critical. Separate databases reduce some blast radius but increase provisioning, migrations, monitoring, support, and recovery work.
