Oh god we’re back up

This post was written by Dark_Sage. He is Dark_Sage.

Twitter    


Yes yes yes

Stuff incoming. Super duper promise.

Because you're worth it, baby.
Because you’re worth it, baby.

 

Takeaways from this experience:

1. Don’t assume your automated backups are actually working

2. Don’t use InnoDB (whatever the hell that is)

3. Don’t set your site to use 4 gigs of RAM when it’s operating off a server that only has 1.5 gigs allocated to it

4. Scotch and coke is not nearly as good as whiskey and coke despite what logic may tell you

21 thoughts on “Oh god we’re back up”

  1. As always Dark Sage is up to no good, (ties Dark Sage in chains and whips him until he bleeds.)

    Well glad to see you guys up and running.

    FYI Jack and coke is the best combi.

    Reply
  2. If you’re having scotch anything but straight, you’re doing it wrong(tm) – I will accept you having ice with it though.

    Reply
    • I’ve never understood why some prefer the ice. If you are going to be drinking scotch and by scotch I mean good scotch (what’s the point otherwise) You think you would be doing so for the flavor, why dull it with ice? (little bit of water roughly room temp is a acceptable addition, water soluble compounds and all the jazz)

      Reply
  3. If you’re not using InnoDB on a website which is clearly using MySQL, then what the hell are you using?

    Just check your backups on a weekly basis like you’re supposed to.

    Reply
      • MyISAM. Per the tech support guy I spent 6 hours with to get this site back…

        “To be honest, the best practice I’d recommend is that, unless you’ve got an extremely high traffic site that’s also very database intensive (a high traffic forum like Slashdot, for example), you avoid using InnoDB. The performance benefits of InnoDB are only significant when you’ve got many simultaneous operations trying to act on the same tables (hundreds per second or more) and are often outweighed by the vulnerability to table corruption.”

        “I really do recommend switching your site’s database to MyISAM; without getting into the details too much, InnoDB is definitely better at scaling with really large deployments that may mirror across multiple MySQL servers, but it also comes with a lot more complications, and when it breaks, it breaks very badly. With a MyISAM table, the worst a crashed table means is usually just a single line of a single table lost, instead of the entire table unusable and possibly the MySQL server destabilized as well.”

        Reply
  4. But Scotch and Moxie is the most belligerent new england thing ever.

    Except nobody outside of New England gets Moxie.

    Reply
  5. 3. Don’t set your site to use 4 gigs of RAM when it’s operating off a server that only has 1.5 gigs allocated to it
    AHAHAHUEHEAHUUEHAE

    Reply

Leave a Comment