Professional PHP

PHP Programming, Web Development, PHP Advocacy and PHP Best Practices.
« Jason Sweat’s Blog
Happy 20th B-day Corewars »

Friendster wrapup: does MySQL scale

July 14th, 2004

Here is a wrap up of some links and information from the friendster PHP conversion of a couple weeks ago.

First, it appears performance really was a major problem for friendster. Friendster Quickly Gathering Foes:

The key issues behind the Friendster abandonment trend, according to users, are the service’s inability to do anything about its habitual server lag problems, and its growing reputation for heavy-handed moral policies and unilateral decisions it makes on behalf of its members.

Performance problems show up in this usuability study of Friendster. more discussion of friendster performance. This quote from Cracking the code to Romance seems to show they are aware of the issue.

Notified of the security holes Moore and Chisholm exploit, Friendster rep Lisa Kopp insists, “We have a policy that we are not being hacked.” When I explain that, policy or no, they are being hacked, she says, “Security isn’t a priority for us. We’re mostly focused on making the site go faster.”

While the consensus seems to be that you can write scalable applications in either Java or PHP, MySQL is another major part of Friendster’s architecture. Why Friendster is so slow makes an educated guess on the cause of Friendsters performance problems, laying the blame on an inappropriate use of MySQL. I wonder how much of this is educated and how much of this is guess.

Philip Greenspun suggests that Friendster “flush MySQL and replace with Oracle 10g.”

It would seem that the friendster folks have a mysql support contract and Attend MySQL conferences:

between sessions, three young men from Friendster are chatting with a neat-looking person in a MySQL shirt, who introduces them to another neat-looking person in a MySQL shirt and says, “he’ll be your primary support contact.”

If the natural architecture of PHP is to push scalability issues out of the language and into the database, the Friendster case seems to raise the question, does MySQL scale?

I would like to see more official information out of Friendster regarding this case.

categories PHP, Usability
tags php scalability

Related Posts

  • un-Friendster: fired for blogging
  • The Endpoints of the Scale of Stupidity on Video
  • PDO versus MDB2
  • Why is PHP Code Considered Hard to Maintain?
  • flickr case study
You can leave a response, or trackback from your own site.

3 Responses to “Friendster wrapup: does MySQL scale”

  1. #1 Mike responds...
    July 17th, 2004 at 3:08 pm

    Greenspun’s student-driven analysis certainly aims to be informative, but I think only Friendster’s engineers can shed some light on the assumptions that people have been making, both about the PHP/JSP debate, and their particular opinions on MySQL scaling. My guess is that Jeremy Zawodny knows a bit about MySQL scaling, and would probably argue against Greenspun’s Oracle comment. Something like this, maybe: I can use a Zamboni to plow my driveway of snow, but there are other things less expensive and probably better suited for it.

    It’s something like traffic design: everyone who sits in a traffic jam thinks that they are smarter than the civil engineers who designed the traffic flow and light timings. Everyone is an expert.

    I think that while the question of whether or not MySQL is scalable is best answered by people who use it in production, with high load, in many different ways. The levele of opinion needs to come down in these topics, and the level of fact and proof needs to come up.

  2. Jeff Moore's Blog » un-Friendster: fired for blogging pingbacked on September 1st, 2004 at 5:58 am
  3. web hosting php mysql trackbacked on March 12th, 2007 at 8:18 pm

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>

code: use [code=php][/code].

Comment Preview

  • Search

  • Subscribe

    Subscribe All Posts
    Subscribe All Comments
    Subscribe All Bookmarks
    Subscribe with Bloglines Subscribe with My Yahoo Add to netvibes Subscribe in NewsGator Online Subscribe with Google feed reader
  • Share This

  • Categories (Home)

    • Agile Methods (14)
    • Mac (14)
    • Misc (16)
    • Open Source (14)
    • PHP (93)
    • Software Design (27)
    • Usability (14)
    • WACT (7)
    • Web Design (20)
  • Recent Comments

    • Delphi for PHP  27
      GNtdTFJVFOSmiLLje, JackSfe, ZIB_NIMER [...]
    • PHP Coding Standards  6
      3123, Jack Johnson, Ignatius [...]
    • Expert and Novice Programmers  13
      Ben W, flj, chris web developer [...]
    • Working with PHP 5 in Mac OS X 10.5 (Leopard)  83
      e-okul, Luis Oscar Cruz, xentek [...]
    • How to Transfer Mac OS X Application Data between Computers  34
      Khaled bin Alwaleed, Oscar, TeeJay [...]
    • Sarah Snow Stever  23
      Snowcore, ennah, Philippine Website Developers [...]
    • PHP Development From Java Architects Eye  9
      Bobrila, FelhoBacsi, Angsuman Chakraborty [...]
    • Improved Error Messages in PHP 5  9
      ennah, Khumaer, retry [...]
    • The value of MVC  7
      Vulchak, อะไหล่แอร์, Derek Scruggs [...]
    • Why PHP is easier to learn than Java  13
      , , WTF [...]
    • goto in PHP  38
      Goldilocks, , SFM [...]
  • Pages

    • Tags
  • Recent Posts

    • Sarah Snow Stever
    • Benchmarking PHP’s Magic Methods
    • The Endpoints of the Scale of Stupidity on Video
    • Working with PHP 5 in Mac OS X 10.5 (Leopard)
    • Keywords and Language Simplicity
    • Improved Error Messages in PHP 5
    • Michigan Taxes Graphic Design Services
    • Ruby versus PHP or There and Back Again
    • Mighty Mouse Kryptonite and Exceeding Expectations
    • reCAPTCHA - Combining Distributed Problem Solving with a Web Service
  • Archives

    • 2007: Jan Feb Mar Apr May Sep Oct Nov
    • 2006: Jan Feb Mar Apr May Jun Jul Oct Nov Dec
    • 2005: Jan Feb Mar Apr May Sep Oct Nov Dec
    • 2004: Apr May Jun Jul Aug Sep Oct Nov
  • Menu

    • Register
    • Login