DB setup for Web2 online applications [Solved]

Question

Hi,

I'm planning to code a Web2 online application and I'm looking for best-pratices.

I'm talking about online apps similar to web collaborative or billing apps.

In fact I'm wondering how they setup their DB?

Do they put all users info in the same DB, is each user have their own DB?

Any suggestion and information are welcome!

Thanks

Answer 1

Generally, everyone is going to be in the same DB. Different users or accounts are differentiated by a unique identifier (obviously). Once they need to scale beyond a single database, they will set up replication or clustering to distribute the load across different DB servers. These servers are mirrors of each other data.

Answer 2

Take a look at Multi-Tenant Data Architecture.