Thursday, February 07, 2008

Scaling the third most active Social Network with MySQL/InnoDB/Solaris


Sun Microsystems has published a case study, Delivering quality service to eleven million users with MySQL, InnoDB,
and the Solaris 10 Operating System
, on Fotolog, the third most active social network according to ComScore and 14th most trafficked site according to Alexa.

Challenges:
• Scale to support eleven* million members and more than 100** million page views a day
• Increase performance without increase in database hardware (significant cost savings)

Solution
• MySQL database software
• InnoDB transactional storage engine for MySQL
• Solaris™ 10 Operating System
• Sun V440 and V210

Results
• Support for four times as many users with no additional hardware
• Higher percentage of working dataset in the memory with efficient schemas
• Four times the number of concurrent threads without adding servers
• Anticipated ability to double current number of threads

I will be presenting an updated and much more juicier version of how we achieved such scalability level from database point of view at the MySQL Conference 2008. The talk is titled, Optimizing MySQL and InnoDB on Solaris 10 for World's Largest Photo Blogging Community. So if you needed a sign to attend the conference, well you got one now :)

Notes:
* Now, Fotolog is reaching 15 million members with same number of database servers.
** Now reaching 150 million plus page views a day

Labels: , , , ,

4 Comments:

At 1:30 PM, OpenID ZUrlocker said...

Frank, excellent info. I think this will be a very well attended session at the conference. Looking forward to seeing you again.

--Zack

 
At 1:43 AM, Blogger Frank said...

Thank you, Zack!

MySQL/InnoDB and Sun do great things for us.

I can't wait for the conference as well. It's so amazing how a year has passed and it's just around the corner.

Frank

 
At 3:49 AM, Anonymous Anonymous said...

There are many social networking services operated like Orkut.com, MySpace, Facebook, etc. Orkut.com is being operated by Google. MySpace is an online community that lets you meet your friends' friends. These are popular sites especially among youths. Here people come into contact with each other and build up relations whether personal or business. There is a provision of creating a private community on MySpace and share photos, journals and interests with your growing network of mutual friends. We can judge the popularity of these sites by seeing their ranking in Alexa. Orkut has been steadily rising on the Alexa charts but MySpace is still significantly bigger than Orkut.com.

MySpace is for everyone:
1) Friends who want to talk Online
2) Single people who want to meet other Singles
3) Matchmakers who want to connect their friends with other friends
4) Families who want to keep in touch--map your Family Tree
5) Business people and co-workers interested in networking
6) Classmates and study partners

Anyone looking for long lost friends

 
At 4:28 AM, Anonymous Anonymous said...

There are many social networking services operated like Orkut.com, MySpace, Facebook, etc. Orkut.com is being operated by Google. MySpace is an online community that lets you meet your friends' friends. These are popular sites especially among youths. Here people come into contact with each other and build up relations whether personal or business. There is a provision of creating a private community on MySpace and share photos, journals and interests with your growing network of mutual friends. We can judge the popularity of these sites by seeing their ranking in Alexa. Orkut has been steadily rising on the Alexa charts but MySpace is still significantly bigger than Orkut.com.

MySpace is for everyone:
1) Friends who want to talk Online
2) Single people who want to meet other Singles
3) Matchmakers who want to connect their friends with other friends
4) Families who want to keep in touch--map your Family Tree
5) Business people and co-workers interested in networking
6) Classmates and study partners

Anyone looking for long lost friends

 

Post a Comment

<< Home