Saturday, March 31, 2007

18th entry - Case Study, Friendster with MySQL.

According to the case study provided from MySQL AB (2007), web page, it speak about Friendster an online community implemented MySQL in their database.

In the early 2003 as Friendster launched, they didn't expect their online community web server will attract so many users sign up as a members. In the 1st half of the year, Friendster hit a million user by that time.

The Friendster Engineering team does not expect this will happened. As the numbers of registered member growing rapidly as the days goes by, the Friendster database server's performance in 'crawling' state because of the heavy data load and traffic between the server and the members.

Soon complain from the members that the site is slow, downtime, or didn't function to what the members required. The engineering team have to find a solution on this matter. Their solution was to implement MySQL database environment to scale out the database network to withstand the amount of database generated everyday basis with out distracting or interrupting the uptime of the Friendster's servers.

Preference
MySQL (2005), "mysql-friendster-casestudy.pdf (application/pdf Object)",
http://www.mysql.com/why-mysql/
case-studies/mysql-friendster-casestudy.pdf