0

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

I'm talking about online apps similar to web collaborative or billing apps. I'm wondering how they setup their DB? Do they put all the users info in the same DB, or does each user have their own DB?

Kate Gregory
  • 18,808
  • 8
  • 56
  • 85
lena
  • 119
  • 1
  • 12
  • 1
    Lena you don't need to (and shouldn't) edit the question to indicate you've accepted an answer, simple choosing an answer is enough. – blowdart Dec 30 '09 at 17:15

2 Answers2

1

Take a look at Multi-Tenant Data Architecture.

Damir Sudarevic
  • 21,891
  • 3
  • 47
  • 71
0

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.

Brad Gignac
  • 819
  • 4
  • 8