Slashdot Mirror

← Back to Stories (view on slashdot.org)

The Biggest MySQL Cluster, Ever?

Posted by Cliff on from the an-RDBMS-that-needs-a-diet dept.

ExcerLee asks: "Our team is going to build a MySQL (load-balancing and fail-over) cluster for the Cluster World Expo in the end of June. This cluster is going to have at least 10 nodes, and will use dual-opteron systems from Polywell Computers and SuSE Enterprise Linux for AMD64 from SuSE. While we are working on this hefty cluster, we wonder if this is the biggest MySQL cluster has ever been built. I googled with terms like 'biggest mysql cluster', but didn't find much." If you've run a MySQL cluster before, how large was it and how well did it perform? Krow: I have been told of much larger clusters then this; Slashdot DBs total 6 machines with 18 processors, and LiveJournal has one of the most complicated clusters I have ever seen set up.

5 of 55 comments (clear)

  1. Re:livejournal? by aeinome · · Score: 5, Informative

    Here's an XML file detailing all of the clusters. It's a little hard to read, but it works.

    --
    When you don't have a leg to stand on, don't even get up.
  2. Re:They didn't [Was: Re:Why would they think that? by Hanashi · · Score: 2, Informative
    I'm sorry, but I don't think you are correct. See the following excerpt:

    While we are working on this hefty cluster, we wonder if this is the biggest MySQL cluster has ever been built.

    They're clearly asking if theirs is the biggest ever built.

    --
    Check out my eclectic infosec blog at InfoSecPotpou
  3. Re:Why would they think that? by moosesocks · · Score: 2, Informative

    10 of these ought to be more powerful than anything else that's been built. 1060 processors, 5760gb of RAM.

    It would definitely be the world's largest MySQL cluster. Of course, I dobut that anybody would even WANT a cluster that big. Once you get a database that size, you would probably want to custom-tailor your own solution, or not use a traditional database at all. The only databases big enough to warrant this type of power are probably those of the government (ie. the IRS); that being said, the government is probably using an ancient antiquated system which works just fine for their purpose.

    --
    -- If you try to fail and succeed, which have you done? - Uli's moose
  4. I'll bet the biggest is Google... by ubiquitin · · Score: 2, Informative

    Google has clusters of 100+ CPU's, and they run MySQL. I haven't seen any public confirmation that they are clustering MySQL, but it would make a lot of sense for them to do so. They would be smart to use a relatively flat db to store all incoming search requests for analysis.

    --
    http://tinyurl.com/4ny52
    1. Re:I'll bet the biggest is Google... by philj · · Score: 4, Informative

      How google works. Enjoy.