How to Implement Multi-Database Tenancy in Laravel for a SaaS Application?

Hi everyone,

I'm currently building a SaaS application using Laravel and looking to implement multi-database tenancy, where each tenant has their own separate database.

I’ve come across packages like:

tenancy/tenancy

spatie/laravel-multitenancy

Before I move forward, I’d love to hear from anyone who has experience with this setup. Here are a few questions:

1. Which package would you recommend for managing multi-database tenancy in Laravel—Spatie or Tenancy for Laravel?

2. How do you handle migrations and seeders for each tenant? Do you run them automatically when a tenant is created?

3. What’s the best way to identify and switch tenants—by subdomain, domain, or user login?

4. How do you manage tenant-specific configurations like custom domains or environment values?

5. Are there any common pitfalls or performance issues to be aware of with multi-database setups?

6. How do you test and deploy tenant-aware applications efficiently?