7

My question is probably fairly common, but I wanted to ask it anyway.

When choosing a database type for large scale application (social networking, for example), is MySQL able to handle it? I mean, hundreds of thousands, if not millions of users...

If not, I can't imagine that everyone would be using Microsoft Servers and SQL. What would be the suitable alternates?

1
  • 2
    If you are able to create a system which is too large or busy for MySQL to handle please let us know. :) Apr 26, 2011 at 3:35

4 Answers 4

3

Facebook uses MySql. See this video, a presentation by Facebook devs, on how they do it http://www.readwriteweb.com/hack/2010/11/facebook-mysql-scale.php

2
  • Wow... that's the answer I was looking for. Why I am surprised that FB is using MySQL?
    – dcolumbus
    Apr 26, 2011 at 1:22
  • Well, somewhat, facebook also uses Cassandra for its messaging system.
    – Jess
    Apr 26, 2011 at 1:47
2

this is a list of a few big fishes that use MySQL:

United Nations
Mc Graw Hill
YouTube
Facebook
Adobe
Wikipedia
Wordpress
Drupal

I hope this could help you to clear your mind ;)

1
  • I thought YouTube was backed by Google's BigTable. Are you sure its MySQL?
    – TheLQ
    Apr 30, 2011 at 13:17
1

Yes. Scalability is not one of the problems with MySQL.

4
  • "not one of the problems with MySQL" ... does that mean that there are other glaring issues with MySQL that I should know about?
    – dcolumbus
    Apr 26, 2011 at 1:05
  • 2
    @dcolumbus: As with absolutely every technology, it has it's drawbacks.
    – Trufa
    Apr 26, 2011 at 1:57
  • @dcolumbus See this old list of "gotchas" or this gotcha. I personally prefer PostgreSQL, but to it (of course) has its own tradeoffs. Here's a small comparison.
    – Phrogz
    Apr 26, 2011 at 2:08
  • @dcolumbus: what Trufa said. Even the best piece of technology in the world will have a downside. You have to balance the pluses and minuses of every item in your software stack when deciding on them.
    – Rob Moir
    Apr 26, 2011 at 7:30
0

Yes it is. MySQL on proper hardware and good configuration can handle 1000s of writes per second and reads can scale out into 10's of thousands per second across replicated slaves

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .