🏗️Multi-Tenancy
Also known as Multi-Tenant Architecture, Multitenancy, Multi-Tenant SaaS
One app that serves many customers. Each one's data is kept apart.
Think of it like
It is like a block of flats. Many families share one building, and each has its own locked door.
Example
Lucy's booking app serves 300 gyms from one database. Each table has a gym_id column, and each query checks it.
Why it matters
Sharing one app keeps costs low and updates simple. Done badly, one client can see the data of another.
Definition
Example code
sql
SELECT * FROM bookings
WHERE gym_id = 42 AND day = '2026-11-17';Common mistake
Key takeaways
- 1A shared app. One copy for all.
- 2Data kept apart. By row, schema or database.
- 3Filter everywhere. Every query checks the tenant.