Subscribe to the Non-Human & AI Identity Journal

Notifications
Clear all

Shared database vs isolated tenant models: where do controls fail?


(@nhi-mgmt-group)
Member Moderator
Joined: 1 year ago
Posts: 15051
Topic starter  

TL;DR: Shared database and isolated tenant models each trade off isolation, cost, maintenance, scaling and onboarding in different ways, with tenant leakage and migration failure emerging as the main security and operational failure modes, according to Island’s analysis of multi-tenancy architecture. The governance lesson is that separation must be designed around data sensitivity, regulatory pressure and developer error tolerance, not convenience.

NHIMG editorial — based on content published by Island: The Enterprise Browser's Approach to Multi-Tenancy Architecture Engineering

Questions worth separating out

Q: What breaks when tenant isolation is weak in multi-tenant SaaS management?

A: Weak tenant isolation turns convenience into shared risk.

Q: Why do shared-schema multi-tenant systems create cross-customer risk?

A: Shared-schema designs rely on tenant_id being present in every query, constraint, and cache key.

Q: How do security teams know whether tenant controls are actually working?

A: They should test whether tenant A can ever retrieve tenant B’s records, whether tenant context is preserved from authentication through data access, and whether migrations or schema changes preserve separation under failure.

Practitioner guidance

  • Map tenant isolation requirements by customer class Identify which customers require database-per-tenant, separate encryption keys or BYOS-style controls before committing to a default architecture.
  • Enforce tenant context in the request path Derive tenant identity from authenticated request context and propagate it consistently into data access, storage selection and authorization decisions.
  • Add automated tenant leakage tests Create integration tests that attempt to access tenant A’s records while authenticated as tenant B and fail the build if any data returns.

What's in the full article

Island's full blog covers the implementation detail this post intentionally leaves for the source:

  • Code-level examples of tenant ID propagation through middleware and request context
  • Database filter patterns and linter-style checks for preventing cross-tenant queries
  • Migration and rollback approaches for isolated tenant database estates
  • Practical examples of BYOS and customer-managed key planning in multi-tenant products

👉 Read Island's analysis of shared database and isolated tenant architecture trade-offs →

Shared database vs isolated tenant models: where do controls fail?

Explore further

View Full Forum →  |  NHI Foundation Course →



   
Quote
(@mr-nhi)
Member Moderator
Joined: 3 months ago
Posts: 14635
 

Tenant isolation is an identity governance problem as much as a data architecture problem. The article shows that data separation fails when tenant context is not reliably enforced through request handling, query logic and access control. In other words, the boundary is not just where data lives, but which authenticated context is allowed to act on it. For IAM and platform teams, that makes tenant scoping part of authorization design, not a downstream implementation detail.

A question worth separating out:

Q: When should organisations choose isolated tenants over a shared database?

A: Organisations should choose isolated tenants when customers handle sensitive data, demand separate keys or storage, or require stronger separation than code-level filtering can credibly guarantee. The threshold is usually regulatory pressure, contractual commitments or a low tolerance for leakage risk, not just technical preference.

👉 Read our full editorial: Multi-tenancy architecture exposes the real tenant isolation trade-offs



   
ReplyQuote
Share: