Advertisement:

Author Topic: New SQL Server  (Read 310411 times)

Offline dschwab9

  • SMF Friend
  • 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 GitHub
    • @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,034
    • 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 cblaber

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,271
  • Gender: Male
    • cmblaber on LinkedIn
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
Colin Blaber
Former Customize & Support Team Member

Offline BryanD

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 22,088
  • Gender: Male
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  :)
Former Project Manager and Customizer of SMF
Former Marketing and Vice-President of Simple Machines

Offline Aleksi "Lex" Kilpinen

  • Support Specialist
  • SMF Super Hero
  • *
  • Posts: 16,709
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • aleksi-kilpinen on LinkedIn
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...
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,028
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @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

Offline Fustrate

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 6,474
  • Gender: Male
  • Controller of the rum budget
    • Fustrate on GitHub
    • @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,611
  • 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 Adish - (F.L.A.M.E.R)

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,614
  • Gender: Male
  • I am a ninja!
    • adishpatel on Facebook
    • https://www.linkedin.com/in/adishpatel on LinkedIn
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...

Offline Aleksi "Lex" Kilpinen

  • Support Specialist
  • SMF Super Hero
  • *
  • Posts: 16,709
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • aleksi-kilpinen on LinkedIn
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 ;)
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

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

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,614
  • Gender: Male
  • I am a ninja!
    • adishpatel on Facebook
    • https://www.linkedin.com/in/adishpatel on LinkedIn
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)

Offline Fustrate

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 6,474
  • Gender: Male
  • Controller of the rum budget
    • Fustrate on GitHub
    • @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

  • Support Specialist
  • SMF Super Hero
  • *
  • Posts: 16,709
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • aleksi-kilpinen on LinkedIn
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... ;)
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

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

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,614
  • Gender: Male
  • I am a ninja!
    • adishpatel on Facebook
    • https://www.linkedin.com/in/adishpatel on LinkedIn
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..)

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

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,614
  • Gender: Male
  • I am a ninja!
    • adishpatel on Facebook
    • https://www.linkedin.com/in/adishpatel on LinkedIn
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.

Offline Aleksi "Lex" Kilpinen

  • Support Specialist
  • SMF Super Hero
  • *
  • Posts: 16,709
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • aleksi-kilpinen on LinkedIn
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"
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline Dzonny

  • Lead Localizer
  • SMF Super Hero
  • *
  • Posts: 11,717
  • Gender: Male
  • No sleep...
    • dzontra.nikola on Facebook
    • Dzonny on GitHub
    • dzontranikola on LinkedIn
    • @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