© 2003-2026 Ironclad Games Corporation Vancouver, BC. All rights reserved.
© 2006-2026 Stardock Entertainment
Search
Forum Home | Login
T-Man
T-Man
Join Date 03/2001
+101 sdemployee

T-Man's Work Report (3-11-05)

It's all about the database

March 11, 2005 5:20:34 PM from WinCustomize ForumsWinCustomize Forums

Who's says I don't do much work anymore?  Want to know what I accomplished this week.  Well here it is!

  • I moved our database from one server to another server

Woohoo!  Now don't everyone get all excited at once.  Ok it doesn't seem like much but it was a fairly large task.  Everyone of our systems and websites communicates with this database so I had to do this in a way where downtime was minimal.

First the servers were in two entirely different locations.  Matter of fact, they were in two different states just to make it more challenging.  I chose to use SQL Server Replication to transfer the data since copying the files would take more than 2 hours.  I didn't really want to do replication since I have had many headaches with it in the past but I figured this was my best option to keep data conistant between the two locations.  For the most part replication this time went pretty smooth which was completely unusual from past experiences.  I think most of it was probably because SQL Server 2000 replication works much better than SQL Server 7.0 which is what I had used in the past.  Plus I have learned a bit more since the last time.

Ok, Data has been replicated and is in both locations, any changes being made to the old server are automatically being pushed to the new server. Excellent.  Now all I need to do is make are dozen or so websites and applications point to the new database.  After making many configuration changes on all the servers to facilitate the move I was finally able to make the switch with only having a couple of minutes of downtime. 

We had a couple of snags with TotalGaming.net and GalCiv.com communicating with the new server but everything else went fairly smooth. 

I did actually do some more work but that was mostly what I worked on this week.  Here are a couple other modifcations that I made to WinCustomize this week.

  • Turned on the filter to cap past customers at 500MB's of downloads
  • Added some additional ads to the site on the main index and preview pages
  • Updated the UserLevel code to pickup product registrations from your cross referenced account
  • Spent a couple hours chasing down a bug that brought WinCustomize down.  Must remember to use LONG instead of INT
  • Take son to hockey practive
  • pick up daughter from gymastics practice

ooops, sorry about that, getting my lists confused.  Anyway, thats about it in a nutshell.

Locked Post
Search this post
Advanced Search
Subscription Options
Reason for Karma (Optional)
Successfully updated karma reason!
T-Man
Apocalypse_67
Join Date 01/2003
0
Reply #1 March 11, 2005 5:33:38 PM
from WinCustomize ForumsWinCustomize Forums
Who's says I don't do much work anymore?

...errrr, I believe it was Frogboy

Great job T-Man. I guess all the server error pages I've been getting is due to all this, but its really good to hear that you are not messing up much.... errr, I mean fixing up everything.

Take son to hockey practive
pick up daughter from gymastics practice


You mean, Frogboy actually lets you leave your desk??

Keep up the good work
Reason for Karma (Optional)
Successfully updated karma reason!
T-Man
T-Man
Join Date 03/2001
+101 sdemployee
Reply #2 March 11, 2005 5:36:39 PM
from WinCustomize ForumsWinCustomize Forums

And obviously I can't type or spell

It's friday.  I must go home now.

Reason for Karma (Optional)
Successfully updated karma reason!
T-Man
Jafo
Join Date 03/2001
+1883 sdemployee
Reply #3 March 11, 2005 5:53:24 PM
from WinCustomize ForumsWinCustomize Forums
OK....so that was the first hour....what'd you do for the rest of the time?....
Reason for Karma (Optional)
Successfully updated karma reason!
T-Man
gef
Join Date 08/2001
+15
Reply #4 March 11, 2005 6:06:00 PM
from WinCustomize ForumsWinCustomize Forums
Perhaps all Admins should offer their work reports, ( he he ).
Reason for Karma (Optional)
Successfully updated karma reason!
T-Man
MikeB314
Join Date 07/2001
+45
Reply #5 March 11, 2005 6:11:25 PM
from WinCustomize ForumsWinCustomize Forums

Nice work, T-Man. Moving that database without any notable downtime for WC is a major feat in itself. There's a lot of data passing through here in a given day, and to keep several websites live while remotely moving the database to another state really is commendable.

In retrospect, all I really managed to do this week was blow up a monitor. I love the smell of burning electronics on a Friday afternoon.

Reason for Karma (Optional)
Successfully updated karma reason!
T-Man
HG_Eliminator
Join Date 07/2002
+354
Reply #6 March 11, 2005 6:42:40 PM
from WinCustomize ForumsWinCustomize Forums
LOL @ MikeB.... sounds like a full week T-Man...thanks for the work it really has paid off...
Reason for Karma (Optional)
Successfully updated karma reason!
T-Man
Corky_O
Join Date 04/2004
0
Reply #7 March 11, 2005 6:56:18 PM
from WinCustomize ForumsWinCustomize Forums
Don't you just love it when it works right?!

Sounds like it went fairly smoothly, great job, T-Man.

Enjoy your weekend.
Reason for Karma (Optional)
Successfully updated karma reason!
T-Man
_02
Join Date 12/2004
0
Reply #8 March 11, 2005 8:14:26 PM
from WinCustomize ForumsWinCustomize Forums
Things have been better for me, and I wan't to thank you for all your hard work. It is quit a big job, and you are doing great!
Reason for Karma (Optional)
Successfully updated karma reason!
T-Man
Island Dog
Join Date 06/2003
+1051 sdemployee
Reply #9 March 11, 2005 8:27:06 PM
from WinCustomize ForumsWinCustomize Forums
Great work. Thanks for all you do.
Reason for Karma (Optional)
Successfully updated karma reason!
T-Man
joeKnowledge
Join Date 03/2004
+2
Reply #10 March 11, 2005 9:25:52 PM
from WinCustomize ForumsWinCustomize Forums
Reason for Karma (Optional)
Successfully updated karma reason!
T-Man
gooberbean28
Join Date 11/2004
+36
Reply #11 March 12, 2005 1:31:52 AM
from WinCustomize ForumsWinCustomize Forums
Same here T-Man
Reason for Karma (Optional)
Successfully updated karma reason!
T-Man
Cyberworld
Join Date 07/2002
+4
Reply #12 March 12, 2005 7:10:49 AM
from WinCustomize ForumsWinCustomize Forums
Great job as always
Reason for Karma (Optional)
Successfully updated karma reason!
T-Man
Sleeping Dragon
Join Date 03/2004
0
Reply #13 March 12, 2005 10:02:10 AM
from WinCustomize ForumsWinCustomize Forums
Thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you!!!!!!!!!!!!!!
Reason for Karma (Optional)
Successfully updated karma reason!
View all recent posts
Mark all posts as read Delete cookies created by the forum Return to Top
Stardock Forums v        Server Load Time:   Page Render Time: