How does facebook store billions of rows of DB data every month? [closed]
Want to improve this question? Update the question so it's on-topic for Stack Overflow.
Closed 11 years ago.
Improve this questionI know that they do use MySql for DB. But my question is, what could they use to store billions of rows of status updates etc. in one table. Do they partrition them ? Or do they have another way to store this huge amount of data?
They are likely sharding their data in combination of master-slave replication.
The problem with databases is replication can only take you so far, because writes don't scale nearly as easily as reads. Therefore, writes heavy database servers are generally sharded or functionally partitioned.
精彩评论