Support the ongoing development of Laravel.io →
Configuration Database Architecture
Last updated 1 year ago.
0

SAAS are usually designed to scale horizontally in terms of client count. What is the point of using a database per clients?

What I suggest is using one database for main app, and one for all clients apps.

To directly respond to your questions:

  1. Use migrations (example path: migration/clientside) to create each client database. When upgrading you jsut have to run migrate on each client database to upgrade your system. Subscription upgrade should be handled in your app without change to the database.

  2. Answered in 1 with the migration trick.

  3. No experience about that sorry.

Last updated 1 year ago.
0

Sign in to participate in this thread!

Eventy

Your banner here too?

Moderators

We'd like to thank these amazing companies for supporting us

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

© 2024 Laravel.io - All rights reserved.