Advertisement:

Author Topic: New SQL Server  (Read 288380 times)

Offline dschwab9

  • IT Director/Server Admin
  • Server Team
  • SMF Hero
  • *
  • Posts: 5,320
  • Gender: Male
    • Technology, Ministry and Other Ramblings
New SQL Server
« on: April 16, 2009, 03:15:08 PM »
Hey guys, just wanted to give everyone an update on the site status.

We have just completed migrating our SQL databases to a brand new box. The new machine is a 2.5GHz 8 core machine with 12GB of RAM and 6 146GB 10,000 RPM SAS drives in RAID 10. This should dramatically improve the speed of the forums.

One minor issue - during the migration, I lost connectivity to the old database server, requiring a hard reboot, which in turn corrupted a couple of tables. Due to this issue, there are roughly 4 hours worth of posts from this morning missing. If your post disappeared, I apologize.

If anyone finds any other issues, please report them in this topic and I will look into it.

Offline Fustrate

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 6,474
  • Gender: Male
  • Controller of the rum budget
    • @Fustrate on Twitter
    • Fustrate
Re: New SQL Server
« Reply #1 on: April 16, 2009, 03:19:22 PM »
* Fustrate likes this news.

It's kind of scary loading a page this fast after the last month and a half... thanks for the awesome fright!
Steven Hoffman
Former Team Member, 2009-2012

Offline grafitus

  • SMF Hero
  • ******
  • Posts: 3,040
    • beratdogan on GitHub
    • beratdogan on LinkedIn
    • @beratdgan on Twitter
Re: New SQL Server
« Reply #2 on: April 16, 2009, 03:20:00 PM »
Vaov.Be Better..

Offline mcblaber

  • Support Specialist
  • SMF Super Hero
  • *
  • Posts: 11,209
  • Gender: Male
    • mcblaber on LinkedIn
    • @mcblaber on Twitter
    • AvatarPrime
Re: New SQL Server
« Reply #3 on: April 16, 2009, 03:22:33 PM »
Very good news!

Quote
It's kind of scary loading a page this fast after the last month and a half... thanks for the awesome fright!
Agreed :P
M. Colin Blaber
SMF Support Specialist

Offline Runic

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,454
  • Gender: Male
  • His Royal Runicness
    • bryan.deakin.1 on Facebook
    • pouvik on GitHub
    • @bryandeakin on Twitter
    • Dyspraxic Chat
Re: New SQL Server
« Reply #4 on: April 16, 2009, 03:23:06 PM »
darn you I lost about 10000 posts cause of you.


Nah I didnt I lost about 30 but ah well end of day its great to be back and have a faster server.

Great job and nice server specs  :)
Bryan Runic Deakin
His Royal Runicness
Owner @ Bryan Deakin dot Com
Owner @ Dyspraxic Chat

Former Project Manager @ SMF
Former Vice President @ Simple Machines
Former Admin @ idesign360.com

Read my new poem "The Note"!!!

Offline Aleksi "Lex" Kilpinen

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 15,430
  • Gender: Male
  • The Artist Formerly Known as LexArma
Re: New SQL Server
« Reply #5 on: April 16, 2009, 03:25:08 PM »
Hmm... My last post is from Today at 10:50:05 - and now it's 22:23, so thats 12 hours minus maintanance time - missing, since I've been spamming the support boards since morning to the maintanence.... ::)

EDIT: But guess this is still good news - I just feel a bit sorry for all the lost support posts...
Finnish Support Local Moderator & Support Specialist
My Mods: Facebook and Twitter Sharer



Offline SleePy

  • Site Team
  • SMF Master
  • *
  • Posts: 28,963
  • Gender: Male
  • Thats his happy face.
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: New SQL Server
« Reply #6 on: April 16, 2009, 03:25:20 PM »
Thanks Derek :D

What I couldn't do with a server like that :P
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub
G+

Offline Fustrate

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 6,474
  • Gender: Male
  • Controller of the rum budget
    • @Fustrate on Twitter
    • Fustrate
Re: New SQL Server
« Reply #7 on: April 16, 2009, 03:26:48 PM »
Thanks Derek :D

What I couldn't do with a server like that :P
Run Crysis.
Steven Hoffman
Former Team Member, 2009-2012

Offline Tristan Perry

  • SMF Hero
  • ******
  • Posts: 2,498
  • Gender: Male
    • Tristan Perry
Re: New SQL Server
« Reply #8 on: April 16, 2009, 03:42:08 PM »
Wow, very amazing server :) Will definitely be able to handle much of what is thrown at it.

Offline Eliana Tamerin

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 5,515
  • Gender: Female
Re: New SQL Server
« Reply #9 on: April 16, 2009, 03:53:45 PM »
Thanks Derek :D

What I couldn't do with a server like that :P
Run Crysis.

Bad graphics card, it'd look horrible. All black with little white text... *shudders*

Thanks Derek, for all your hard work on this.
Do NOT PM me for support.

SimplePortal 2.3.6 is OUT!
SimplePortal Project Manager
Download | Docs
SimplePortal: Power of Simplicity!

Offline Spaceman-Spiff

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 1,524
  • Gender: Male
Re: New SQL Server
« Reply #10 on: April 16, 2009, 04:00:42 PM »
That's ok, with an 8-core CPU, we can do software rendering of Crysis!

 ;D

Offline (F.L.A.M.E.R)

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,614
  • Gender: Male
  • I am a ninja!
    • adishpatel on Facebook
Re: New SQL Server
« Reply #11 on: April 16, 2009, 04:02:10 PM »
I think i lost about 70-100 posts. I resolved about 2 pages od Support Topics..!! Comon get them back.. I have to go through them again... :( marked many solved today...
Need paid assistance for your forum? CLICK ME!
Email: flamer@simplemachines.org (Stop sending me love proposals! I don't do Internet dating :P)

Offline Aleksi "Lex" Kilpinen

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 15,430
  • Gender: Male
  • The Artist Formerly Known as LexArma
Re: New SQL Server
« Reply #12 on: April 16, 2009, 04:05:09 PM »
I think i lost about 70-100 posts. I resolved about 2 pages od Support Topics..!! Comon get them back.. I have to go through them again... :( marked many solved today...
My initial thoughts too - but after a little thought, with the speed the forum runs now, I guess we'll soon catch up ;)
Finnish Support Local Moderator & Support Specialist
My Mods: Facebook and Twitter Sharer



Offline (F.L.A.M.E.R)

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,614
  • Gender: Male
  • I am a ninja!
    • adishpatel on Facebook
Re: New SQL Server
« Reply #13 on: April 16, 2009, 04:06:52 PM »
Aah, i would love to post again, but seriously, i might have marked over 20 topics solved today and posted about 100.. i was on a post count of about 130 when it was in maintanance.. (not sure though)
Need paid assistance for your forum? CLICK ME!
Email: flamer@simplemachines.org (Stop sending me love proposals! I don't do Internet dating :P)

Offline Fustrate

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 6,474
  • Gender: Male
  • Controller of the rum budget
    • @Fustrate on Twitter
    • Fustrate
Re: New SQL Server
« Reply #14 on: April 16, 2009, 04:07:58 PM »
Then stop complaining and go solve them again ;)
Steven Hoffman
Former Team Member, 2009-2012

Offline Aleksi "Lex" Kilpinen

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 15,430
  • Gender: Male
  • The Artist Formerly Known as LexArma
Re: New SQL Server
« Reply #15 on: April 16, 2009, 04:09:16 PM »
Then stop complaining and go solve them again ;)
Repetition is the mother of all learning... ;)
Finnish Support Local Moderator & Support Specialist
My Mods: Facebook and Twitter Sharer



Offline (F.L.A.M.E.R)

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,614
  • Gender: Male
  • I am a ninja!
    • adishpatel on Facebook
Re: New SQL Server
« Reply #16 on: April 16, 2009, 04:09:59 PM »
I am on it boss.. :P but after sometime.. If it could get back, i think it would be a great thing. (just to be sure if we arnt getting it back..)
Need paid assistance for your forum? CLICK ME!
Email: flamer@simplemachines.org (Stop sending me love proposals! I don't do Internet dating :P)

Offline (F.L.A.M.E.R)

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,614
  • Gender: Male
  • I am a ninja!
    • adishpatel on Facebook
Re: New SQL Server
« Reply #17 on: April 16, 2009, 04:13:40 PM »
Just reporting in a problem.. (maybe!) I dont see any unread posts even though people are making posts in different sections. Unread replies works fine.
Need paid assistance for your forum? CLICK ME!
Email: flamer@simplemachines.org (Stop sending me love proposals! I don't do Internet dating :P)

Offline Aleksi "Lex" Kilpinen

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 15,430
  • Gender: Male
  • The Artist Formerly Known as LexArma
Re: New SQL Server
« Reply #18 on: April 16, 2009, 04:18:28 PM »
Search seems to not work, "Unable to access the search daemon"
Finnish Support Local Moderator & Support Specialist
My Mods: Facebook and Twitter Sharer



Offline Dzonny

  • Localizer
  • SMF Super Hero
  • *
  • Posts: 10,359
  • Gender: Male
  • No sleep...
    • dzontra.nikola on Facebook
    • @opusteniforum on Twitter
    • Samo opusteno
Re: New SQL Server
« Reply #19 on: April 16, 2009, 04:36:47 PM »
I'm glad that community is speeded up.. :)
* Dzonny is happy
|Sistem za razmenu banera|Servisi za webmastere| My Mods

Dont't fear the reaper...
mail: dzonny (@) simplemachines.org