Multitenancy in Laravel: Migrations, Testing, and switching tenants 

Thank you so much! This is the most important Laravel video I’ve ever watched.

Great video! There aren't too many great videos about multi-tenancy and how to build one from scratch. I would love to see part two that looks at making rest of the Laravel tenant specific like you mention the console commands.

You Sir, are a gentleman and a scholar - thank you for posting this very helpful video!

Great video. Great explanation. And very complete. Thanks for including the testing too.

Great video Mohamed! All very well put, it will definitely help to ease the overcomplicated approaches that people are using.

Thank you so much for the video. So useful for me. I am developing a SAAS application.

Amazing video 🙌🏻🙌🏻🙌🏻. Thank you so much !!! Really clear and useful. There is so much to learn from here. All the different functions and config structures. Very well explained and demoed 🙏🏻🙏🏻🙏🏻

Thanks for keeping things simple :)

Awesome!! Very nice approach

Excellent video! So informative!

Thank you so much for your video, I needed to learn about this, I really appreciate your dedication. Hug from Brazil

I don't do backend or even PHP, I just enjoy learning from your videos

Thank you Said for talking about Multinenancy. Would love more videos from you on scaling Laravel.

One approach I took is to use table prefixes for tenants. This saved me some provisioning work when it comes to creating new databases while onboarding a new tenant.

Great video, Thank you Mohamed!

I had some difficulties running the worker. In config/queue.php I found 'database' => [ 'driver' => 'database', 'table' => 'jobs', 'queue' => 'default', 'retry_after' => 90, ], and added: 'connection' => 'landlord', Now everything is going into a central queue instead of independent tenant queues, and I can process all items in the queue via `php artisan queue:work --tries=1` -- besides that, everything was really straight forward to port over. Thanks again!

Very thanks, I learning from your videos a lot

Very helpful Waiting for more videos 💓

you saved my life! thanks a lot for this tutorial

thanks a lot, you save my days, love it

Super interesting thanks for this one!

Very helpful. Thanks Mohamed

wow, great video man! thanks you explained vey well

Thank you so much bro. You saved a life.

This is my urgent need!! Thanks

Great video mohammed, thanks

Great video! Thank you

bro youre insane thankyou so much

Thanks for this video.

Great tuto Thank's for explanation

Wow! This is the best explaination I've seen of this! The scenario I've come accross is that all users login at the same url, with the users table in the Landlord database. The user can only belong to one tenant, and so has a tenant_id on the user.

Thanks for this.

Going over the head, need to watch again and again

Many thanks 😊👍

Awesome video bro

Great content 👍

Thanks a lot for sharing this right on time :) this answer lots of queries and gives better clarity on implementation. I would love to see more of such videos. Wish audio was bit smooth !

Mohamed Said, Great video thanks

Excellent video 👋🏽, I would like to know how to create the multi database with docker (sail). Thanks for the dedication!

well done bro!

Hi Muhammad, Thanks for putting this together. Nice Work. I have question from the forum. I never developed Saas with multi tenancy before. Should we start this setup from the start of a project or after making our full application for single tenant the we can add these pieces to make it Multitenant? I have an application for one School for example can i turn it now to Multi Schools with unique subdomain?

Seems we think alike,used almost the same approach but tenant manager is a separate project since it includes the product website. I Use middleware to switch tenants.

would be great if you make a complete course laravel - tenant from scratch Thank you

Thanks Said! Great video! It's hard to find information on setting up multi database tenancy with laravel. This was a welcome adddition. I'm still missing what to do with Redis and Filesystem in that case. Is there a simple way for prefixing those without extending the existing laravel drivers?

How i set dynamically configuration for every tenant?

Thanks for sharing your effort. I have followed your instruction even tried your repository but I am getting 404 error on homepage when I run php artisan serve. Please anyone help. Thank you

Can you check in code which tenant is used currently? For custom logic for each tenant?

Thank you for the huge efforts you put to make development using Laravel much more easy and fun process. I have a question here: what do you mean by having to make a database per tenant? Can you please share some scenarios where using a database per tenant would be a better option? Thanks again Mohammed

@Mohamed, You mentioned you prefer a tenant structure as tablename_tenantKey rather than an individual database for each tenant. Can we discuss why? I've been learning towards migrating my tenants into their own database, but I'm not sure if I'm ready to make the jump yet. I'll need to figure out a new solution on database backups, etc. I'm also feeling like Postgres will be easier to scale as compared to MYSQL. Digital Ocean has much more support for Postgres in regards to real-time backups, failover, etc. What do you think? Where can we go from here? I'd love some more content! Thank you.

Hello Sir! Thank you so much! It's too easy to convert an existing app with this. But how can we manage it in a single domain? I don't want to add domains like you explain.

can you please point me to show we will be running scheduled jobs on all tenants?

Can you or someone please share more info on how to setup and run the application you have shared on github?

Great video. Can we run it on localhost server? If can then how to run it?

if I have complete project done and I want use multi tenancy using subdomain to switch db what the best approach

Salam Mohammad, Changing the database connection using the `config` helper works like a charm, so, I'm wondering what is the purpose of using "DB::reconnect" and "Schema::connection", though?

Hi, Great tutorial. I've used Tenancy with Multi Tenant & single DB. I need a functionality to ghost login my admin as a tenant user. Could you help me out with that please, if possible.

I want to create a multitenant application where a new Database should be created when a user is registered, can you please share more details in the repository.

Hello, Great video. my question is around context switching.. imagine switching db at a very high rate. would this impact performance ?

Hi, do you have tips how to maintain for multiple laravel projets that share the base codes but each project has some little customizations, so that when someone update the base codes the other projects will get this updates too?

Each customer requires different customisation to the application, we can ofcourse provide shared db and compute, but , how do i have different application versions for different customers.? Eg : one customer wants normal calculator, one customer wants, scientific calculator, one more customer wants a music player while performing calculations, and one more customer wants voice based calculator

How to declare tenant api routes?can you give me a example please

No doubt it solves the problem but it leaves me to think about how it will run scheduled jobs in all tenants?

What is the recommended way to run a specific business logic and migration for one tenant?

Thanks Mohamed, I did it before, but not as clean as you. How can we have horizon on multi-database approach? To see which job is for which tenant?

Great work Mohamed. Just have one question. Did you create all the databases (for the tenants) manually before you run the "tenants:migrate" command or it was generated by the same command.

Thank you for the video, is this compatible witih Laravel 8?

it took me 1:35 second to hit the like button 😅

I followed each and every step and could reach the end quite smoothly, very detailed demonstration. But when I refresh the front end it gets me 404 error laravel.intolap.com/romegasoftware/. Please ignore the directory name. Any relevance?

How do you add not equal to sign in 7:43 of this video?

Great vid. Can you tell me why I might be getting this error. Illuminate\Database\QueryException SQLSTATE[HY000] [1049] Unknown database 'laravel' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE') I see in the db tenants table database laravel and paravel so I don't know why it's complaining. thanks

What if all tenant migrations are stored in Migrations/Tenant folder, in this case how migrations will work? I tried and command just ignored the path and migrated all tables to the main connection.

First of all i would like to appreciate your effort Mohamed Said. Let me tell u, i am getting error Symfony\Component\Debug\Exception\FatalThrowableError : syntax error, unexpected '=>' (T_DOUBLE_ARROW), expecting ')' at D:\xampp\htdocs\multi_tenancy\app\Console\Commands\TenantsMigrateCommand.php:31 ); } else { Tenant::all()->each( fn($tenant) => $this->migrate($tenant) ); } }

Excelent video.... I am having some problems with Laravel 8 and running my ExampleTest.php i am getting an undefined factory() error. Has anyone run into this problem? Tests\Feature\ExampleTest::itReturnsCurrentTenantAndListOfItsUsers Error: Call to undefined function Tests\Feature\factory()

شكرا محمد في ممكن شروحات بالعربية من فضلك

You forgot your Screencast TODOs man, that font size...

Not Found :github.com/themsaid/multitenancy-example

excelente vídeo;yo lo hice con múltiples schemas misma base de datos postgresql guiándome del articulo que escribiste divinglaravel.com/understanding-how-laravel-configures-database-connections

multi tenancy spatie route slugs problem - Route::domain('{tenant}.localhost')->middleware('tenant')->group(function(){ Route::prefix('owner')->middleware(['auth', 'owner'])->group(function () { Route::get('/Entries/edit/{id}',function($id){ echo $id; }); }); }); output gives tenant name

Repo is still private I guess.

Hello, I have a problem. I made a fully working multi-site system. However, the system does not work when the boostrap / cache / config file is created. Because config.php file is created for only 1 site. How can I make this file a separate file for each site. I couldnt find it. Please help me.

ليه مش بتنكلم عربي ؟

Nice Video. But i am having an issue when running with swoole (laravel-s). f (!$this->app->runningInConsole()) returns true in TenancyProvider. How can i solve it, any suggestions please?I am using Lumen 8