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…
1 Like
Great share! An additional advantage of multiple databases is that it makes it easier to perform a refresh of client databases.
1 Like
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.