Originally published at: https://caribbean.dev/should-you-use-a-single-or-multiple-databases-for-your-saas-project/
Have you ever wondered how large SaaS applications are built? Do they use a single database for all clients or multiple databases? Let’s say you have a SaaS-based application that has data stored in a database and multiple customers, also known as tenants or clients, using the same application. Each tenant has their own set…
Great share! An additional advantage of multiple databases is that it makes it easier to perform a refresh of client databases.
Definitely, I tend to do this using laravel…
php artisan migrate:refresh --tenant=1
There’s also this great talk by Tom Schlick on multitenancy strategies. Give it a what when u get the time.