CODEWITHSUNDEEP
mysqldatabase
Jack
Jack

Reputation: 97

Large websites - multiple databases or or multiple tables?

I'm wondering how websites like youtube/facebook/stackoverflow etc. work. Do they use single database with many tables or multiple databases? If so (multiple), why? Is it faster option?

Upvotes: 6

Views: 3113

Answers (2)

ChapMic
ChapMic

Reputation: 28114

You can find some information here:
Example : Youtube Architecture
On this website, you will also see the evolution of Youtube which can be interesting for you in order to know how it works.

Upvotes: 4

Jader Dias
Jader Dias

Reputation: 90465

There is nothing to do with performance. Databases separate unrelated data domains and deploying items.

If two tables might be related to the same application then they should be in the same database.

One exception is when a table is reused accross many unrelated applications. Then it can have its own database and then the apps can use more than one database.

Upvotes: 3

Related Questions