We’ve been doing a lot of talking about some of the growing pains we have been having with our database server. And how we are going to deal with it. Well we will be moving Stack Overflow’s database to its own hardware this Friday (2011-03-11).

When?

2011-03-11 9:00pm Eastern (2011-03-12 02:00 UTC)

Why?

To Make everything MORE AWESOME

What?

2 new Dell R710’s

  • 2x Intel Xeon Processor X5680 3.33 GHz
  • 96GB of RAM
  • 6 Intel X25-E SSD’s in a RAID 10

What will this mean?

First, we will be putting Stack Overflow into Read Only mode again for the maintenance – just like we did when we went down the Oregon trail. Once the migration is complete, Stack Overflow will be on its own DB pair, and can run free, and the rest of the Stack Exchange sites don’t have to contend with the Megalopolis for database time, making them MORE AWESOME as well.

«
»
  • thing2k

    2011-04-11 02:00 UTC? Don’t you mean 2011-03-12 02:00 UTC?

    • No, the date rolls over at 00:00 so when you convert from 9pm EST (21:00 EST) to 2am UTC you pass midnight and the date rolls over for UTC, but not EST.

      GAH SORRY … yes he was right, I had the month/day swapped. fixed the post

      • Heathhunnicutt

        April 11th or March 12th? You obviously mean March 12.

      • Jeff Dion

        I think that what Thing2k was mentionning is the month change in UTC time

  • Ross Smith

    2011-04-11 02:00 UTC? Don’t you mean 2011-03-11 02:00 UTC?

    • Anonymous

      Dates are hard.

      • Drachenstern

        let’s go shopping?

  • I guess, it should be 2011-03-12 02:00 UTC

  • How long the migration activity is going to happen?

  • Awesome man !!! Keep going on as well as keep growing on.

  • Nobody

    s/it’s/its/g

    • Ben Blank

      That’s what I love about the StackExchange community — even the grammar/spelling “trolls” are polite and helpful. 🙂

  • Robert

    Death to EXPERTS EXCHANGE!

    • Edward Ishaq

      They used to come up on many searches I did but not any more now that we have stackoverflow and the rest …

      • They also used to not be such douchebags and only required a (free) login to read answers. Now they require you to pay to even see any answers, unless you were one of the few who contributed x-thousand answers.

        • …answers per month.

        • Guest

          …or know to press End and just read it for free.

          • Gareth

            …but only if you’ve clicked through from a Google search result.

      • EJB

        With the new version of chrome (released yesterday), you can block a site from showing up in your future google searches – experts-exchange was the very first one I blocked – finally.

        • nikic

          That’s nothing to do with Chrome. That’s a Google feature. It’ll work in every newer browser.

  • Sam

    hoe many more hours we have from NOW?

  • dforck42

    Is Brent O helping with the move?

    • As usual he gave us a ton of help on the planning and checked our work.

  • Looks like this will be one hell of a boost 😀

    MORE AWESOME

  • StackOverflow++

  • Disqus was so crappy 1 year ago, now the entire internet uses it.

    Anyway…I think a stackoverflow question – bounty 1000 – to build a custom database just for the SO format (open source’d obviously) would be an interesting idea. Even if you never implement it, the potential there is big

    • What makes SO so unique that it would require a custom solution?

      • Have a look at the schema, most of the data is a page in SQL Server

  • asaikali

    nice, machines what database server do you run? It would be great to know what technologies and platform the stackoverflow uses.

  • Ben Sapp

    RAID 5 is MORE AWESOME than RAID 10 for solid state drives.

  • Does that configuration do failover without the hassle of a SAN/NAS?