Results 1 to 12 of 12
Thread: WHT Outage Feb 9, 2007
-
02-09-2007, 11:42 AM #1Web Hosting Master
- Join Date
- May 2001
- Location
- Dayton, Ohio
- Posts
- 4,977
WHT Outage Feb 9, 2007
Today the post table on the WHT forum database became corrupted. I have restored from a live replicated backup and I am repairing the old post table so no posts will be lost. I am sorry for the inconvenience!
-
02-09-2007, 11:51 AM #2Web Hosting Master
- Join Date
- Aug 2005
- Posts
- 3,587
live backups rule! Glad you could save this beast, good to be back. Good luck restoring the old posts etc.
-
02-09-2007, 12:23 PM #3Web Hosting Master
- Join Date
- May 2001
- Location
- Dayton, Ohio
- Posts
- 4,977
Originally Posted by amygdela
We have a couple slave MySQL servers, I backed up the current post table files to another location, moved the post table files from one of the slaves and turned the site back online. I have repaired the old post table and reintegrated any posts that were not written to the slave post table yet.
Pretty simple process
-
02-09-2007, 12:32 PM #4Web Hosting Master
- Join Date
- Aug 2001
- Location
- Boston
- Posts
- 1,568
I saw the outage this morning...and I was really crossing my fingers to see a new WHT layout when I came back since SWR made a vague announcement the other day!
-
02-09-2007, 01:52 PM #5Web Hosting Master
- Join Date
- Aug 2005
- Posts
- 3,587
Pretty simple process
-
02-09-2007, 02:19 PM #6Web Hosting Master
- Join Date
- Aug 2003
- Location
- Twin Cities Area
- Posts
- 5,649
that was a horrible experience!
if you haven't considered chapter 7 bankruptcy, maybe you should.
eliminate your debt, keep the property you want, most people qualify.
contrary to popular belief - no attorney is necessary!
-
02-09-2007, 07:16 PM #7Web Hosting Guru
- Join Date
- Sep 2005
- Posts
- 250
Good Work
-It's not about how much, it is about how to.
-
02-12-2007, 12:13 AM #8Web Hosting Master
- Join Date
- Jun 2006
- Location
- Amex & Amex
- Posts
- 1,291
Originally Posted by The Prohacker
Seeing how I'm new to vbulletin management would you care to shed the light on how the database just came corrupted?
Is it cause its just so large?
How do you manage such a large database?
When you say you have multiple "slave MySQL servers" does that mean that the main database is copied over to multiple other servers? Is that the "live replicated backup"?
Sorry for so many questions but I'm really interested in this regard.
Thanks
ppc123
-
02-12-2007, 11:48 AM #9Web Hosting Master
- Join Date
- May 2001
- Location
- Dayton, Ohio
- Posts
- 4,977
Originally Posted by ppc123
Originally Posted by ppc123
Originally Posted by ppc123
-
02-12-2007, 12:24 PM #10Aspiring Evangelist
- Join Date
- Sep 2006
- Location
- England, London
- Posts
- 418
Originally Posted by The ProhackerGiving up does not always means you are weak, it Simply means you are strong to let go!
-
02-12-2007, 02:37 PM #11Web Hosting Master
- Join Date
- May 2001
- Location
- Dayton, Ohio
- Posts
- 4,977
Here we go again!
http://www.webhostingtalk.com/showthread.php?t=583820
-
02-12-2007, 02:55 PM #12Junior Guru Wannabe
- Join Date
- Nov 2006
- Posts
- 35
I assume you have all servers connected via internal interface? Are your clients authenticating?
I had that problem recently where they weren't. What fixed it is:
skip-name-resolve
in the my.cnf. Although the server was listed as an IP Address, mysql was still trying to resolve hostnames and it delayed connections which can make it look like a lot of other things.
Or maybe you have some bad hardware?