Multi Tenancy

Multi-tenancy is a software architecture approach that enables a single application to serve multiple independent clients — in this case, schools — from a shared codebase.
Each school operates as an autonomous tenant, maintaining its own data, configuration, and branding while benefiting from the same centralized application infrastructure.

Within SchoolPalm, multi-tenancy allows multiple educational institutions to seamlessly run under a single hosted platform without interfering with one another.
This ensures that every school — regardless of size or type — can manage its operations independently while system administrators retain a unified overview and control through a Super Admin Portal.

Role of Multi-Tenancy in SchoolPalm

Multi-tenancy forms the core of SchoolPalm’s SaaS (Software as a Service) model.
It enables the platform to host hundreds of schools efficiently, with each school having:

• Its own database, ensuring complete data isolation and privacy.
• A unique subdomain (e.g., emmahigh.schoolpalm.com), creating a personalized and branded experience.
• Independent control over academic, financial, and administrative modules.
• The ability to scale without requiring new software installations.

This approach allows SchoolPalm to deliver enterprise-grade functionality to every institution while minimizing infrastructure and maintenance overhead.

Architectural Design

The architecture separates the application layer from tenant data, ensuring that all schools share the same system logic while maintaining separate data stores.

Key Components

1. Central Application Core

   • Houses shared functionality such as authentication, dashboards, role management, and system configuration.
   • Manages routing and tenant resolution logic based on subdomains.

2. Tenant Databases

   • Each school has a dedicated database where its unique data is stored.
   • The system dynamically connects to the correct database once a tenant (school) is identified through its subdomain or domain alias.
   • This guarantees data segregation, security, and easier backup or migration per tenant.

3. Super Admin Layer

   • Provides oversight for all registered schools.
   • Handles tenant creation, subscription management, and performance analytics.
   • Offers visibility into cross-tenant metrics without direct data overlap.

Integration with the Tech Stack

The multi-tenancy model is tightly integrated into SchoolPalm’s selected technologies:

• Backend:
  Built on Laravel, which offers powerful service container management, middleware, and routing capabilities to dynamically handle tenant resolution and database connections.

• Frontend:
  Developed with Jetstream + Inertia.js, ensuring reactive interfaces and smooth navigation across tenants.
  TailwindCSS and Quasar power the UI components, making it possible to customize layouts and themes per school.

• Routing and Domains:
  Each school operates under a dedicated subdomain, automatically linked to its data source.
  Example:

  • emmahigh.schoolpalm.com → connects to schoolpalm_emmahigh database.
  • globalit.schoolpalm.com → connects to schoolpalm_globalit database.

• Hosting Model:
  The system runs as a centralized SaaS deployment on cPanel or VPS environments.
  This allows for automated tenant provisioning, dynamic subdomain assignment, and independent data management.

Advantages within SchoolPalm

By adopting a multi-tenant architecture, SchoolPalm achieves:

• Scalability: The ability to host many schools efficiently under one platform.
• Security: Strong data isolation at the database level.
• Flexibility: Each institution customizes its setup, branding, and modules.
• Maintainability: Centralized updates and feature rollouts without downtime per tenant.
• Cost-Effectiveness: Shared infrastructure reduces hosting and maintenance costs.

Summary

Multi-tenancy is the foundation that transforms SchoolPalm from a single-school management tool into a cloud-based educational ecosystem.
It ensures that every school benefits from a personalized, secure, and scalable experience — all powered by one intelligent, unified application.
Through subdomain-based tenant resolution and database-level separation, SchoolPalm guarantees data integrity, independence, and seamless performance across all connected institutions.