Thread: Forum outages
View Single Post
danramos's Avatar
danramos is offline danramos
2010-10-26 , 07:59
Posts: 4,672 | Thanked: 5,455 times | Joined on Jul 2008 @ Springfield, MA, USA
#24
Originally Posted by Reggie View Post
Yes, the backup is online and set to incremental. For some reason though, MySQL locks some of the major tables during the backup making the the site seem unaccessible. The major tables are quite large as well.

I'm checking some more items that might be causing the problem now. It looks like the server is responding well now, despite the not so low server load.

Just to clarify, the forum server is separate from the other parts of maemo.org. As nidO has mentioned, it's the spike on the number of visitors in the forum that causes the forum server outage.
Ah okay! The context and the way it was being explained made it sound like the same servers--if it's purely refreshes and genuine forum traffic, then there's only the MySQL problem (although I'm still not sure I understand why backups have to occur on a set schedule as opposed to a live syncing backup or something more efficient with no downtime.. but then I don't know the rest of the story either) and bandwidth (which I suppose could be throttled at the server or, better, the load balancer/router/whatever you're using.
__________________
Nokia's slogan shouldn't be the pedo-palmgrabbing image with the slogan, "Connecting People"... It should be one hand open pleadingly with another hand giving the middle finger and the more apt slogan, "Potential Unrealized." --DR