Mysql, Site Outage | featured news

You had probably noticed that the site was down for a couple hours on Monday and hadn’t been updated until this morning. I was on my way to the airport for Cannes and, of course, the site had to go down. It’s not my fault though. There server crapped out because of hardware issues, and my site had to be moved to another one. That took about three hours. Well, actually, it only took about half an hour, but I didn’t know the site was down and out until two and half hours later.

The site crashed yesterday morning at around 9am, although it’s hardly noticable until a couple hours later. I didn’t notice it until I started picking stories to feature on the homepage. Whenever i tried to feature an article, it would stop the site from loading up.

From that, I knew that the MySQL database must be checking for corrupt tables. And if it’s doing that, a crash must have occurred. Checking out stats at my ISP confirmed that the server was restarted at 9am.

I spent the whole day dealing with servers. The facility where Wopular and MoviesWithButter are hosted were having some network issues. I was able to get MWB up and running within an hour or so. Wopular was a whole different story. The Database is about 21GB. It's a huge db, so whenever there's a network issue, I can always count on at least one corrupt table. And it always happens to be the largest table, which takes several hours to diagnose and repair.