Server upgrades and other miscellaneous fun stuff…

*sigh* It’s been a busy week for me at the office, but I’ve also been having to deal with some of the problems involving MK Online’s backup system. After the hard drive crash that occurred back around Christmas, I’ve come to realize that simply backing up the databases like we have been doing isn’t the best option. We need to back up EVERYTHING involving the site. I’d been working on a possible solution for the past week or so, and am on the verge of implementing it. At the same time, I’ve been working on improving the data redundancy on the main D’Arque Cathedral server. Well, the work came to a head last night on both projects.

On the main D’Arque Cathedral server, most of the data storage is on a single 80 GB hard drive. I also had a spare 120 GB drive I had left over from when I upgraded my main PC. The 120 GB drive would have been overkill for the MK Online’s backup; frankly 80 GB is overkill but it’s what I had. So, what I did was get on Newegg’s website and order an identical 120 GB hard drive to the one I had. It arrived Wednesday, but I wasn’t at the office to receive it. So, I brought it home last night and got to work installing it. The idea was to set up the two 120 GB drives in the main D’Arque Cathedral server, and set them up as a software RAID 1 configuration. (RAID 1 = mirrored drives.) It took a bit longer than expected as it was highly recommended that I put the two drives on separate cables/controllers instead of the same one, and I couldn’t get a cable that would reach both the CD-ROM drive and one of the hard drives. So, I had to grab my unused drive controller card and put the drives on that. (The CD-ROM is hooked to the motherboard.) From there, it was just a matter of partitioning the drives, setting up the RAID, formatting them, and then copying the data from the 80 GB drive to the RAID. It’s up and running with the two drives; I’ve also got a program running that monitors the drives and will send an email to my Blackberry if there’s a serious problem.

The 80 GB drive will go into a test server I have. It’ll have to wait until Sunday, though, as the server’s motherboard won’t support the 80 GB drive, and I used my spare PCI IDE drive controller to get the RAID 1 working on the D’Arque Cathedral server. I’ll be going by Fry’s tomorrow, anyway, so picking up a new drive controller card won’t be a problem. What I’ll be doing is setting it up where the main MK Online server will do a secure file replication every morning; all site files (including hosted sites) will be synchronized with the copy on my test server. That way if something happens, we don’t lose more than a day or two’s worth of files. I’m not interested in having another catastrophic loss, and this will prevent it from happening again.

Oh, well. The script for the replication is ready; I just have to get the new drive into the test server so we can begin the actual backups. The RAID 1 on the main D’Arque Cathedral server is working fine now, so life is good on that front. Hopefully this will put an end to any further extended downtimes on either site.

Damnit…

Well, this sucks.
I’m at Saturn of North Houston right now, waiting on my car (which is getting its 72k mile service), and have no real net access outside of my Blackberry. They have a wireless network here, but since the last time I came in here, they locked it with a WEP key. So, I’m stuck cooling my heels until my car is finished.
It’s been a fairly hectic week at work, all told. In addition to my usual support work, I’ve been having to oversee upgrades and additions to our phone and data wiring and systems as we move THREE different divisions to the campus at which I work. Moreover, I need to have most (if not all) of it done by the end of the month. The worst of the three migrations will have to be done by Friday. Fun fun… Then, at the end of the month, I have a business trip to Canada (and somewhere else; more details on that later).
On another front, all of this office work and work on the backend stuff at MK Online meant I had to wait on Justin to post the news on Game Informer’s preview of Mortal Kombat: Armageddon, which will be the next MK fighting game. I’ve been stuck trying to help fix the PM system on the site, plus finalizing the work on the new backup system so that we’re prepared in the event of a catastrophic crash like we had a few weeks back. I’ll give details on the backup system a bit later, as it ties in to work I’m doing on the main D’Arque Cathedral server. It’s been a lot of work to plan out and prepare, but in the end I’m confident we’ll be ready for the next time we have issues.
Anyway, my thumbs are getting tired from all this typing on my Blackberry, so I’ll just end it here. I’ll post again later in the day once I get to the office.