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.

Filed Under

  • PHP, Usability

Related Posts

  • un-Friendster: fired for blogging
  • The Endpoints of the Scale of Stupidity on Video
  • Looking Towards the Cloud
  • PDO versus MDB2
  • php | tek Wrapup
You can leave a response, or trackback from your own site.

39 Responses to “Friendster wrapup: does MySQL scale”

  1. Jeff Moore's Blog » un-Friendster: fired for blogging says:
    9/1/2004 at 5:58 am

    [...] d hoped that more information would come out about Friendsters Java to PHP conversion (1 2 3). Sadly, I don’t think thats going to happen. It seems th [...]

  2. Mike says:
    7/17/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.

  3. web hosting php mysql says:
    3/12/2007 at 8:18 pm

    web hosting php mysql

    Really nice info, the odds are increasing. Really appreciate the efforts to write this, was looking for it sometime ago. This is the

  4. Interesting Facts says:
    5/5/2011 at 10:52 am

    I enjoyed reading this a lot …

    I really hope to read more of your posts in the future, so I’ve bookmarked your blog. But I couldn’t just bookmark it, oh no.. When I see quality website’s like this one, I like to share it with others So I’ve created a backlink to your site (from …

  5. Quora says:
    5/11/2011 at 7:28 am

    What were the reasons behind Jonathan Abrams losing control of Friendster?…

    The discussion of loss of control probably cannot be complete without reminding ourselves of why the company ended up with VC’s owning too much of the business in the first place.

    The first round of funding was auspicious, with KPCB and Benchmark inv…

  6. Tora Aopen says:
    10/26/2011 at 4:08 am

    Thanks for sharing superb informations. Your web-site is so cool. I’m impressed by the details that you’ve on this website. It reveals how nicely you perceive this subject. Bookmarked this website page, will come back for extra articles. You, my pal, ROCK! I found just the information I already searched everywhere and simply could not come across. What a perfect site.

  7. wehostia.com says:
    10/29/2011 at 11:08 pm

    wehostia.com…

    [...]Friendster wrapup: does MySQL scale – Professional PHP[...]…

  8. mira hair oil says:
    11/22/2011 at 11:28 am

    Let me begin by saying good post. Im not certain if it has been talked about, but when making use of Chrome I can never get the entire website to load without refreshing several times. Could just be my personal computer. Thanks.

  9. szkolenia dla pracowników says:
    12/1/2011 at 11:28 am

    A careful understanding and also suggestions I’m going employ on my personal blog site. You’ve naturally put in lots of time for this. Thank you!

  10. Projekt domu says:
    12/6/2011 at 12:36 pm

    Its like you read my thoughts! You seem to know so much about this, such as you wrote the guide in it or something. I believe that you just can do with a few p.c. to power the message house a bit, however instead of that, that is great blog. A great read. I will certainly be back.

  11. Richie Richelieu says:
    1/1/2012 at 7:54 pm

    Hiya, I am really glad I have found this information. Today bloggers publish just about gossips and web and this is actually frustrating. A good website with exciting content, this is what I need. Thanks for keeping this web site, I’ll be visiting it. Do you do newsletters? Can not find it.

  12. Jeanelle Delay says:
    1/1/2012 at 9:23 pm

    Undeniably believe that which you said. Your favorite reason seemed to be on the net the easiest thing to be aware of. I say to you, I definitely get annoyed while people think about worries that they just do not know about. You managed to hit the nail upon the top and also defined out the whole thing without having side effect , people can take a signal. Will probably be back to get more. Thanks

  13. Garry Hittner says:
    1/5/2012 at 9:25 pm

    Very nice post. I just stumbled upon your weblog and wanted to say that I have truly enjoyed browsing your blog posts. In any case I’ll be subscribing to your feed and I hope you write again very soon!

  14. Francis Benty says:
    1/6/2012 at 11:36 am

    Its like you read my mind! You appear to know so much about this, like you wrote the book in it or something. I think that you can do with some pics to drive the message home a bit, but instead of that, this is excellent blog. An excellent read. I will definitely be back.

  15. Mitchell Marrujo says:
    1/6/2012 at 11:26 pm

    wonderful. I actually like what you have acquired here, certainly like what you are saying and the way in which you say it. You make it entertaining and you still care for to keep it smart. I cant wait to read much more from you. This is really a great website.

  16. Nakesha Spidel says:
    1/7/2012 at 10:25 pm

    It is appropriate time to make some plans for the future and it’s time to be happy. I’ve read this post and if I could I desire to suggest you few interesting things or suggestions. Maybe you can write next articles referring to this article. I desire to read more things about it!

  17. Roland Koob says:
    1/8/2012 at 10:34 am

    It is the best time to make some plans for the future and it is time to be happy. I’ve read this post and if I could I desire to suggest you some interesting things or suggestions. Perhaps you can write next articles referring to this article. I wish to read more things about it!

  18. Racheal Karry says:
    1/9/2012 at 5:59 pm

    I have been surfing online more than 3 hours today, yet I never found any interesting article like yours. It’s pretty worth enough for me. In my view, if all web owners and bloggers made good content as you did, the web will be much more useful than ever before.

  19. Jene Orum says:
    1/9/2012 at 8:30 pm

    I’ve been browsing online more than 3 hours today, yet I never found any interesting article like yours. It’s pretty worth enough for me. In my opinion, if all site owners and bloggers made good content as you did, the net will be a lot more useful than ever before.

  20. Vilma Carnahan says:
    1/9/2012 at 9:09 pm

    Hi there, just became aware of your blog through Google, and found that it is really informative. I am going to watch out for brussels. I will appreciate if you continue this in future. Many people will be benefited from your writing. Cheers!

  21. Sadye Running says:
    1/12/2012 at 9:24 pm

    I loved as much as you’ll receive carried out right here. The sketch is attractive, your authored subject matter stylish. nonetheless, you command get got an shakiness over that you wish be delivering the following. unwell unquestionably come more formerly again since exactly the same nearly a lot often inside case you shield this hike.

  22. Bronwyn Budhu says:
    1/13/2012 at 10:08 pm

    Hello There. I found your blog using msn. This is a really well written article. I’ll be sure to bookmark it and return to read more of your useful info. Thanks for the post. I will definitely comeback.

  23. Kelley Petrus says:
    1/21/2012 at 10:55 am

    I like the valuable info you provide in your articles. I will bookmark your blog and check again here frequently. I am quite certain I will learn plenty of new stuff right here! Good luck for the next!

  24. Elissa Pea says:
    1/21/2012 at 11:15 am

    Nice post. I was checking constantly this blog and I’m impressed! Extremely helpful information particularly the last part :) I care for such information much. I was looking for this certain info for a very long time. Thank you and good luck.

  25. empire social says:
    1/22/2012 at 3:14 pm

    You are really a excellent webmaster. The website loading velocity is amazing. It sort of feels that you’re doing any distinctive trick. In addition, The contents are masterpiece. you have done a great activity in this matter!

  26. Odis Spoth says:
    1/22/2012 at 6:31 pm

    I’m extremely impressed with your writing skills and also with the layout on your weblog. Is this a paid theme or did you customize it yourself? Either way keep up the nice quality writing, it is rare to see a great blog like this one these days..

  27. Herbert Sandling says:
    1/25/2012 at 1:44 pm

    I’ve been browsing online more than three hours today, yet I never found any interesting article like yours. It’s pretty worth enough for me. In my opinion, if all web owners and bloggers made good content as you did, the net will be much more useful than ever before.

  28. Luci Juvera says:
    1/26/2012 at 10:37 pm

    Unquestionably believe that which you stated. Your favorite justification seemed to be on the internet the easiest thing to be aware of. I say to you, I definitely get annoyed while people consider worries that they plainly do not know about. You managed to hit the nail upon the top as well as defined out the whole thing without having side-effects , people could take a signal. Will probably be back to get more. Thanks

  29. Cole Luelf says:
    1/26/2012 at 10:49 pm

    I like the valuable information you provide in your articles. I will bookmark your weblog and check again here frequently. I am quite certain I’ll learn plenty of new stuff right here! Best of luck for the next!

  30. Waneta Vanalst says:
    1/26/2012 at 11:31 pm

    Hello there, just became alert to your blog through Google, and found that it’s truly informative. I’m gonna watch out for brussels. I’ll be grateful if you continue this in future. Lots of people will be benefited from your writing. Cheers!

  31. Abraham Biscocho says:
    1/30/2012 at 9:03 pm

    Howdy there admin, I clearly wanted to actually make a short statement to firmly state that I adored your post. Thanks!

  32. Earl Skowronski says:
    1/31/2012 at 3:10 pm

    I like the helpful information you provide in your articles. I’ll bookmark your weblog and check again here frequently. I’m quite certain I’ll learn many new stuff right here! Best of luck for the next!

  33. Kandra Noriego says:
    2/2/2012 at 12:44 pm

    Its like you read my mind! You appear to know so much about this, like you wrote the book in it or something. I think that you can do with a few pics to drive the message home a little bit, but instead of that, this is excellent blog. A great read. I’ll definitely be back.

  34. Clemente Michaux says:
    2/2/2012 at 2:04 pm

    Unquestionably believe that which you stated. Your favorite justification seemed to be on the internet the easiest thing to be aware of. I say to you, I definitely get irked while people think about worries that they just do not know about. You managed to hit the nail upon the top and defined out the whole thing without having side-effects , people can take a signal. Will probably be back to get more. Thanks

  35. Theodore Wetmore says:
    2/17/2012 at 6:28 pm

    Thanks for an unbelievable submit, would study your particular others reviews. thank you your thinking within this, I experienced a bit struck by this post. Many thanks again! You commit a great point. Portrays natures best by the great info here. I feel that when a greater number thought about it like that, they’d possess a better time frame get the grasp ofing the situation.

  36. Michaela Zaman says:
    2/23/2012 at 10:04 pm

    Excellent goods from you, man. I’ve understand your stuff previous to and you’re just too fantastic. I really like what you’ve acquired here, certainly like what you’re saying and the way in which you say it. You make it enjoyable and you still care for to keep it wise. I cant wait to read far more from you. This is actually a wonderful site.

  37. jaketkulit says:
    3/1/2012 at 4:57 am

    Many thanks for an unbelievable put up, would study your particular others topics. thank you your notions with this, I experienced a lttle bit made an impact to by this post. Merit again! You wanna make a great time. Got some excellent data here. I do think that if more individuals thought about it like this, they’d have got a better time have the hold ofing the matter.

  38. Projekty tanich domów says:
    3/19/2012 at 5:55 pm

    Projekty tanich domów…

    [...]Friendster wrapup: does MySQL scale – Professional PHP[...]…

  39. Lovie Dewan says:
    3/20/2012 at 3:25 am

    I am really impressed together with your writing abilities in addition to using the layout in your blog.

Leave a Reply

Click here to cancel reply.

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

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

Comment Preview

    Subscribe Feed
    Share Subscribe to this blog…
    Share Bookmark or share this page…
  • About

    My name is Jeff Moore. I'm a PHP programmer living in San Francico and working for a startup.

    More about me…

  • Categories (Home)

    • Agile Methods (14)
    • Mac (14)
    • Misc (18)
    • Open Source (14)
    • PHP (99)
    • Software Design (29)
    • Usability (14)
    • Web Design (20)
  • Recent Comments

    • Working with PHP 5 in Mac OS X 10.5 (Leopard)  258
      Tuan Lal, Lavagem de estofados, Edward L. Kind [...]
    • php | tek 2008  36
      how to mend ice machine, Akademija Debelih, Odbacena [...]
    • goto in PHP  59
      kasor, Thomas Valdivieso, Murray Ziadie [...]
    • Firefox Extensions for Web Developers  33
      kasor, Website Design Toronto, mobila bistrita [...]
    • Why PHP is easier to learn than Java  68
      kasor, Justina Calvery, Guy Lipton [...]
    • Meta Tag Refresh Faux Paux  43
      html email templates, E-Juice Reviews, image [...]
    • Improved Error Messages in PHP 5  49
      Carroll Tina, Przeprowadzka, Emery Harari [...]
    • Benchmarking PHP's Magic Methods  33
      kayu oyunlar?,dora,oyun,oyna, Benjamin Bejjani, paypal website [...]
    • Microbenchmarks of single and double qouting.  24
      kefir grains minneapolis, sexshop dildo, tuim688 [...]
    • PEAR Templates  17
      Kandice Sansing, car insurance estimates for teenagers, Dale Brence [...]
  • Recent Posts

    • Richard Thomas
    • ZendCon: Writing Maintainable PHP Code
    • Looking Towards the Cloud
    • Holiday Tech Support
    • Closures are coming to PHP
    • php | tek Wrapup
    • php | tek 2008
    • Sarah Snow Stever
    • Benchmarking PHP’s Magic Methods
    • The Endpoints of the Scale of Stupidity on Video
  • Site

    • Archives
    • Log in
  • Search