Scaling with Schemas: Multi-Tenancy Migration in Laravel
The Reimpact platform is undergoing a significant architectural shift, moving from a MySQL row-level multi-tenancy model to a more robust PostgreSQL schema-per-tenant setup. This post dives into the key considerations and steps involved in this migration, leveraging Laravel and Filament.
The Motivation for Schema-Based Tenancy
Row-level multi-tenancy in MySQL, while initially simpler to