Designing Scalable and Secure Multi-Tenant SaaS Databases
Designed for Senior SaaS platform architects and lead database engineers designing new multi-tenant environments for rapidly scaling enterprise customers to spark real collaboration and high-energy learning.
A 90-minute virtual workshop with breakout room capability. Participants are technically advanced, responsible for both architecture and hands-on implementation. Their main pain points: reconciling conflicting demands of scalability and strict customer isolation, navigating compliance, and avoiding costly downtime during migrations.
Tenant Towers Mystery
Open with a visual puzzle: display three database diagrams (shared schema, isolated schema, hybrid) but with key labels missing. Invite participants to guess which diagram is most scalable, which is most secure, and which is the biggest compliance risk. Their answers set up the core tensions in SaaS multi-tenancy.
Tap to view the full activity.
Why this works
Curiosity-driven mystery activates pattern recognition and primes participants to question assumptions before technical deep-dive.
Mythbusting: Isolation Edition
Show a quote from a real CTO: 'Our SaaS is totally secure—each tenant just gets a unique database.' Ask: is that always true? Lead a short mythbusting poll to reveal subtle risks (e.g., misconfigured backups, shared infra vulnerabilities) even with isolated databases.
Tap to view the full activity.
Why this works
Confronts a common misconception head-on, boosting credibility and encouraging critical thinking.
Fast Schema Sketch
Participants download a template that sketches a basic multi-tenant schema (e.g., tenant_id, users, billing). They get 3 minutes to annotate it with sticky notes or digital markups where they'd add security controls. No pressure—just quick creative thinking.
Tap to view the full activity.
Why this works
Low-stakes creative participation allows everyone to contribute without judgment, surfacing individual approaches and gaps.
Migration Relay Challenge
Divide participants into breakout teams. Each team gets a scenario: onboarding a new enterprise tenant with zero downtime. Teams race to storyboard their migration steps, including schema changes, data copy, and cutover strategy. They pitch their plan in a 1-minute 'relay' for peer vote.
Tap to view the full activity.
Why this works
High-energy, collaborative problem-solving triggers competitive spirit and builds quick consensus on best practices.
The Auditor’s Curveball
Present a real-world dilemma: a customer demands proof that their tenant's data is isolated, but you use a shared schema. Participants must brainstorm how they'd provide evidence and satisfy compliance without redesigning their model.
Tap to view the full activity.
Why this works
Real-world dilemma heightens relevance and forces participants to think beyond textbook solutions, fostering practical skills.
Personal Scaling Story
Invite everyone to write (in chat or on sticky notes) the biggest scaling or security surprise they’ve faced in multi-tenant SaaS—whether good or bad. Then, ask them to reflect: What would they do differently with today’s knowledge?
Tap to view the full activity.
Why this works
Active reflection anchors learning in personal experience, improving retention and fostering community.
Sign up to unlock 3 more activities
Get the full pack, facilitation flow, and more ready-to-run ideas.