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.

2 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:BEOWULF by ciaran_o_riordan · · Score: 5, Interesting

    I know you were only joking but I thought I'd mention that this is impossible.

    BEOWULF support has to be compiled into an application for it to be used. MySQL doesn't have BEOWULF support, and I don't see a patch for it on the web.

    OpenMosix performs kernel level clustering. You apply the OpenMosix patch to Linux, compile, reboot, and Linux will now migrate processes automatically to other OpenMosix enabled computers on your network.

    Beowulf is more efficient, but it would probably take a month or so to program MySQL to use it. OpenMosix takes about 30 minutes to set up and it then works with every application you run.

    I thought this was interesting.

    Ciaran O'Riordan

    --
    Expert in software patents or patent law? Contribute to the ESP wiki!