09-02-2013, 03:42 PM
A CASE STUDY PRESENTATION ON THE DATABASE BEHIND MYSPACE
A CASE STUDY PRESENTATION .pptx (Size: 111.14 KB / Downloads: 29)
INTRODUCTION
MySpace is a social networking site.
Launched in November 2003, and by may 2007,it had 175 million member accounts.
The technical requirements for such social networking sites are different because they are heavily trafficked.
So in initial stage, MySpace has adopted two web servers
DATABASE SERVER
MS SQL SERVER
This was suitable for small to medium sites for simplicity.
But when accounts increased to 500000 users, one database server is not enough, so MySpace added three SQL servers databases ,one served as master database which receives new data and copied them to other two databases.
Now when accounts increased to 2 million, speed problem arises, so MySpace switched to vertical partitioning model