Menu
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?
956
Maintaining a single database system is more straightforward than handling multiple database systems. It is also slightly easier to get statistics on an application's usage if they operate a single database system. It is easier to develop an administrator application.
You can try some cloud data management platforms. Generally, this kind of platforms supports connecting multiple databases, such as MySQL, PostgreSQL or MongoDB, so you can connect several databases at the same time.
Try to keep logically related information together and unrelated information separate. Try to avoid multiple databases or tables with the same design or purpose. Multiple database apps are usually apps which have their own data requirements but also have to integrate with another existing app or service's database.
If you think you're site will grow or will like to take your site to the next level I would go with a host that offers at least 2-5 mysql databases.
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.
103
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
