Forum Rollback

Discussion in 'News - Front Page Posts' started by Kyoji, Dec 22, 2010.

  1. Kyoji
    Veteran Staff Member Admin

    Joined:
    Jun 22, 2008
    Messages:
    10,210
    Likes Received:
    191
    Location:
    Indiana, U.S.
    The forums were rolled back several hours. Some posts and threads will be missing and possibly a few users who just recently registered. The cause was an infestation of mutant space squirrels, but they were quickly dispatched. Sorry for the inconvenience.
     
    Last edited: Dec 22, 2010
  2. The Communist
    Veteran

    Joined:
    Jun 22, 2008
    Messages:
    4,380
    Likes Received:
    9
    Occupation:
    Student
    Location:
    Texas
    In what ways were the squirrels mutated? Extra limbs?
     
  3. Kurushii
    Veteran

    Joined:
    Sep 25, 2010
    Messages:
    773
    Likes Received:
    11
    Location:
    ニコニコ動画
    Great my thread on server selections in TERA KOBT is gone :(
     
  4. AzureB
    Guest

    Joined:
    Jun 25, 2008
    Messages:
    795
    Likes Received:
    0
    Location:
    Australia
    @ Kyoji - I love your new avatar.
     
  5. Areli
    Veteran

    Joined:
    Aug 1, 2009
    Messages:
    2,201
    Likes Received:
    4
    Occupation:
    Govt.
    Location:
    Chicago Il.
    you lost my credits - I hit the goddamn jackpot on Ninjas. ok not the jackpot but besides losing my fantastic jab at your XoO t-shirt drawing, I was up about 7500 more than I am now :(

    seriously, why the rollback? I'm just curious what could get into our forums to cause something like that. I'm sure others are too.
     
  6. Que
    Admin

    Joined:
    Jun 24, 2008
    Messages:
    1,461
    Likes Received:
    31
    That was the backup. We lost less than a day thankfully. The database got borked bad and I got a phone call at about 2am to fix it. While loosing any amount of data is bad it could have been much much worse.
     
  7. Que
    Admin

    Joined:
    Jun 24, 2008
    Messages:
    1,461
    Likes Received:
    31
    Added 10k to your account.
     
  8. Trice
    Veteran Crowfall Member

    Joined:
    Jun 23, 2008
    Messages:
    1,883
    Likes Received:
    16
    Gender:
    Male
    Occupation:
    System Engineer @ BigFish Games
    Location:
    Kirkland, WA
    hrm.. so, it sounds like there a full backup is done without syncing transaction logs? Are the transaction logs being synced with the backup? check mysqldump options etc. The more I think about it the more I wonder if we have control over the backup or the host.

    For all I know, you could have a decent transaction log and just need to use it? http://techovdoom.blogspot.com/2010/01/rollback-with-mysql-transaction-log.html
     
  9. Vapor
    Veteran

    Joined:
    Mar 26, 2010
    Messages:
    1,781
    Likes Received:
    1
    Occupation:
    Warrior
    Location:
    EST Zone
    Well that explains it
     
  10. Sogetsu
    Veteran

    Joined:
    Jul 27, 2009
    Messages:
    7,511
    Likes Received:
    3
    Occupation:
    Logistics
    Location:
    Atlanta, GA
    I got really concerned, then went to bed.

    Glad they are back up now.
     
  11. Que
    Admin

    Joined:
    Jun 24, 2008
    Messages:
    1,461
    Likes Received:
    31
    Very interesting idea but the host has control of any transaction logs that may exist.
     
  12. Trice
    Veteran Crowfall Member

    Joined:
    Jun 23, 2008
    Messages:
    1,883
    Likes Received:
    16
    Gender:
    Male
    Occupation:
    System Engineer @ BigFish Games
    Location:
    Kirkland, WA
    Kind of figured as much, might be worth having a chat with them to see what they are doing. Also, what does our contract say regarding data integrity / backups?

    having to rollback to a PIT (point-in-time) 7 hours ago is just pure BS, wonder if they support any e commerce sites? That would just suck monkey balls!
     
  13. Arimil
    Veteran Admin

    Joined:
    Apr 26, 2010
    Messages:
    2,044
    Likes Received:
    1
    I blame Kyoji, him being paranoid I'm going to bork the forums and all.
     
  14. Sogetsu
    Veteran

    Joined:
    Jul 27, 2009
    Messages:
    7,511
    Likes Received:
    3
    Occupation:
    Logistics
    Location:
    Atlanta, GA
    I wonder if that button was the color red?