nixCraft Poll

Topics

Recovered from database Disaster / Corruption

Posted by Vivek Gite [Last updated: January 25, 2007]

Earlier today monit reported Lighttpd webserver problem. Due to MySQL database corruption site was down for almost 2hrs.

We restored all data, again, without any loss of files or posts/articles except comment made after 24th Jan 2007! Entire site is roll-back to last good backup which was made on 23-Jan-2007.

Thanks to NAS backup.

As usual disaster strike at midnight (3AM):
mint-reports.png
(Traffic hit graph)

If you see any problem please write to me vivek ReMoVeMe AT nixCraft . COM.

Want to stay up to date with the latest Linux tips, news and announcements? Subscribe to our free e-mail newsletter or RSS feed to get all updates. You can Email this page to a friend.

You may also be interested in other helpful articles:

Discussion on This Article:

  1. Motin Says:

    Do you use a good system to detect and get notified of disasters that you can recommend? I would sleep better if I could just check my e-mail after midnight…

  2. nixcraft Says:

    I’m using Nagios, Munin, Monit and few custom made perl/shell scripts. You need to play with these tools all of them are quite effective.

Leave a Reply

We encourage your comments, and suggestions. But please stay on topic, be polite, and avoid spam. Thank you very much for stopping by our site!

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word

Copyright © 2004-2008 nixCraft. All rights reserved - TOS/Disclaimer - Privacy policy - Sitemap - Powered by Open source software.