Lowyat.NET Forums

Welcome Guest ( Log In | Register )

 
RSS feedReply to this topicStart new topicStart Poll

Outline · [ Standard ] · Linear+

> Server Upgrade Notice [update]

se7en
post Sep 4 2007, 11:35 AM


the return of Jack Sparrow
Group Icon

Group: Admin
Posts: 1,674
Joined: January 2003
From: Captain's Cabin, Black Pearl





We will be upgrading our database server this Thursday (6th September 07). We expect this exercise to take anywhere between 2 to 5 hours.

The forums will be taken offline from 1030pm to 12am (and probably be inaccessible up till 5am depending on any complications that might happen during the transfer).

The new database server should be able to cope with the peak hour load that has been causing the recent increase in "server busy" messages.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
wKkaY
post Sep 4 2007, 12:23 PM


I am looking at. YOU!!
Group Icon

Group: Forum Admin
Posts: 3,918
Joined: January 2003




So far, the average-case timings I have are:

15 minutes - mysqldump
5 minutes - transfer
15 minutes - mysql import

Plus another 20 minutes for hardware fiddling. I think 2 hours is a reasonable window to expect smile.gif
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
se7en
post Sep 7 2007, 09:45 AM


the return of Jack Sparrow
Group Icon

Group: Admin
Posts: 1,674
Joined: January 2003
From: Captain's Cabin, Black Pearl





The new server doesn't seem to be coping very well. We're busy trying to figure out why it randomly puts itself to sleep!


Added on September 8, 2007, 7:51 pmServer has been stable for last 24+ hours without any signs of problems.

We'll continue to monitor and hopefully everything is ok.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
wKkaY
post Sep 11 2007, 03:02 PM


I am looking at. YOU!!
Group Icon

Group: Forum Admin
Posts: 3,918
Joined: January 2003




Here's some performance graphs before and after the upgrade.

user posted image
This is the old DB server's typical load over a day. Look at the fat IO Wait graph, indicating that we're IO-saturated.

user posted image
While this is the new DB server's typical load. What load!? rclxm9.gif

user posted image
And as a consequence of reduced DB backlog, the webserver's load spikes have reduced as well. This is a weekly graph, so compare the first 3 days (pre-upgrade) and the days following it.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post

Bump TopicReply to this topicTopic OptionsStart new topic
 

Lo-Fi Version Time is now: 5th September 2008 - 02:33 PM
All Rights Reserved 2003-2008 Vijandren Ramadass (~why so serious?~)
Hosting powered by IPServerOne - a Malaysian Web Hosting Company