Switch to English Language Passer en langue française Omschakelen naar Nederlandse Taal Wechseln Sie zu deutschen Sprache Passa alla lingua italiana
Members: 70,550   Posts: 1,544,838   Online: 1097
      
Page 4 of 7 FirstFirst 1234567 LastLast
Results 31 to 40 of 61
  1. #31
    roteague's Avatar
    Join Date
    Jul 2004
    Location
    Kaneohe, Hawaii
    Shooter
    4x5 Format
    Posts
    6,672
    Images
    18
    Thanks Sean for all your hard work and dedication.
    Robert M. Teague
    www.visionlandscapes.com
    www.apug.org/forums/portfolios.php?u=2235

    "A man who works with his hands is a laborer; a man who works with his hands and his brain is a craftsman; a man who works with his hands and his brain and his heart is an artist" -- Louis Nizer

  2. #32

    Join Date
    Oct 2005
    Location
    Madison, WI
    Shooter
    4x5 Format
    Posts
    101
    Although failures happen to everybody, this is why there is still a very large market for expensive machines from Sun, IBM, and other providers who do more than assemble x86 boxes.

  3. #33
    JeffD's Avatar
    Join Date
    Aug 2004
    Location
    Atlanta, GA USA
    Shooter
    4x5 Format
    Posts
    308
    Images
    10
    Good time to review the backup procedure. I can't figure out how a failure on the server would screw up your backup, but I guess it did. I started backing up my web server off site daily, after an event similar to yours convinced me it was essential. Now I sleep better at night.

  4. #34
    Sean's Avatar
    Join Date
    Aug 2002
    Location
    New Zealand
    Shooter
    Multi Format
    Posts
    8,560
    Blog Entries
    7
    Images
    15
    Quote Originally Posted by JeffD
    Good time to review the backup procedure. I can't figure out how a failure on the server would screw up your backup, but I guess it did. I started backing up my web server off site daily, after an event similar to yours convinced me it was essential. Now I sleep better at night.
    Well I had 4 backups in play luckily and between them we were able to recover everything.

    1 backup on server's secondary drive (it was partially corrupted as it was a copy of the corrupt primary disk)
    1 decommissioned server in california (it's data was good but from the 15th)
    1 off site full rsync backup (data was good but only had apug.org and was from the 17th)
    1 full site backup from the 19th on my local pc with good data but hard to transfer with my slow NZDSL connection

    The problem is most of the data was corrupt in production, and that corrupt data then copied over to the nightly backups which made the backups corrupt. We had no indication there was an issue until the crashes. When you have about 6.5gigs of data in the backup you never truly know it's good until you try to use it. I never anticipated this because usually a primary disk dies and you fall back to the secondary with last nights data. In this case last nights data was also bad. Luckily we had a variety of backups + acquiring some still good db's off the old disks.

    In the future I plan to not overwrite nightly backups anymore, for example maybe have 15days worth of backups on the backup disk. If data goes bad we can keep going back a day until it's clean (hopefully always having a recoverable set of databases less than a day old). I'll be examining a lot of options. At this very moment I have a newly generated zip of the entire site transferring to my offsite storage and my local pc. I'll then take nightly database backups until the new solution is in place..

  5. #35
    Sean's Avatar
    Join Date
    Aug 2002
    Location
    New Zealand
    Shooter
    Multi Format
    Posts
    8,560
    Blog Entries
    7
    Images
    15
    -also working on a failover page so in the event of an outage we can have a notice with temporary chatroom.

  6. #36
    Markok765's Avatar
    Join Date
    Apr 2006
    Location
    Ontario, Canada
    Shooter
    Medium Format
    Posts
    2,270
    Blog Entries
    1
    Images
    24
    Quote Originally Posted by Sean
    -also working on a failover page so in the event of an outage we can have a notice with temporary chatroom.
    Would the chatroom be open only to subscribers? Thanks for the hard work!
    Marko Kovacevic
    Blog
    Youtube

  7. #37

    Join Date
    Jan 2005
    Location
    south central Missouri
    Shooter
    Multi Format
    Posts
    1,927
    Images
    9
    Thanks Sean, I thought maybe I was on everyone's ignore list

    Mike

  8. #38

    Join Date
    Oct 2005
    Location
    Madison, WI
    Shooter
    4x5 Format
    Posts
    101
    Quote Originally Posted by Sean
    Well I had 4 backups in play luckily and between them we were able to recover everything.
    What is your database? MySQL?

  9. #39
    Aggie's Avatar
    Join Date
    Jan 2003
    Location
    So. Utah
    Shooter
    Multi Format
    Posts
    4,925
    Images
    6
    Dell Sucks! (I like the word sucks it is so to the point) I too have had one of their laptops, which was delivered without all the parts ordered on it. Everytime I had to try and get the proper part they would tell me "You get what you pay for" to which I would reply, "No I didn't that is the problem." It took 8 months for them to send me the correct parts, and then it became a doorstop due to multiple failures withint another 8 months. My son had a desktop from them. He had more problems than I did. He finally gave up and built one of his won from scratch.
    Non Digital Diva

  10. #40
    Sean's Avatar
    Join Date
    Aug 2002
    Location
    New Zealand
    Shooter
    Multi Format
    Posts
    8,560
    Blog Entries
    7
    Images
    15
    Quote Originally Posted by MikeM1977
    What is your database? MySQL?
    yup

Page 4 of 7 FirstFirst 1234567 LastLast


 

APUG PARTNERS EQUALLY FUNDING OUR COMMUNITY:



Contact Us  |  Support Us!  |  Advertise  |  Site Terms  |  Archive  —   Search  |  Mobile Device Access  |  RSS  |  Facebook  |  Linkedin