Advertisement:
SMFPacks SEO Mod
« previous next »
Pages: [1] 2 3 ... 8   Go Down

Author Topic: New SQL Server  (Read 253819 times)

Offline dschwab9

  • IT Director/Server Admin
  • Servers Team
  • SMF Hero
  • *
  • Posts: 5,322
  • 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.
Logged

Offline Fustrate

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 6,467
  • 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!
Logged
Steven Hoffman
Former Lead Developer

Quote
Antechinus: That's a really horrible thing to call someone
Fustrate: I just couldn't control myself!
Antechinus: I get like that with virgin goats
Antechinus: and you can quote that one ;)
Quote from: Richard Dawkins
We are all atheists about most of the gods that societies have ever believed in. Some of us just go one god further.

Offline grafitus

  • SMF Hero
  • ******
  • Posts: 3,021
  • Gender: Male
  • just looking for own old energy
    • beratdogan on LinkedIn
Re: New SQL Server
« Reply #2 on: April 16, 2009, 03:20:00 PM »
Vaov.Be Better..
Logged

Online shadow82x

  • Support Specialist
  • SMF Super Hero
  • *
  • Posts: 10,501
  • Gender: Male
    • mcblaber on LinkedIn
    • @shadow82x 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
Logged
M. Colin Blaber
SMF Support Specialist

Online Runic

  • Project Manager
  • SMF Master
  • *
  • Posts: 25,085
  • Gender: Male
  • Bah Humbug!!
    • BryanRunicDeakin on Facebook
    • bryandeakin on LinkedIn
    • @bryandeakin on Twitter
    • Bryan Deakin.com
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  :)
Logged
AUNT CLARA IS HERE!!!

Bryan Runic Deakin
|
Μπράιαν Poύνικ Ντίκεν
Project Manager/Marketing
|
Διαχειριστής έργου/Μάρκετινγκ
Wha Like Us!
Say YES to Scottish Independence

Offline Aleksi "Lex" Kilpinen

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 15,444
  • 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...
Logged
Finnish Support Local Moderator & Support Specialist
My Mods: Facebook and Twitter Sharer


Offline SleePy

  • SMF Friend
  • SMF Master
  • *
  • Posts: 28,730
  • 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
Logged
]
Jeremy D — Ex-Site Manager
Support the SMF Support team!
Profiles:
GitHub
G+

Offline Fustrate

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 6,467
  • 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 »
Quote from: SleePy on April 16, 2009, 03:25:20 PM
Thanks Derek :D

What I couldn't do with a server like that :P
Run Crysis.
Logged
Steven Hoffman
Former Lead Developer

Quote
Antechinus: That's a really horrible thing to call someone
Fustrate: I just couldn't control myself!
Antechinus: I get like that with virgin goats
Antechinus: and you can quote that one ;)
Quote from: Richard Dawkins
We are all atheists about most of the gods that societies have ever believed in. Some of us just go one god further.

Offline Tristan Perry

  • Beta Tester
  • SMF Hero
  • *
  • Posts: 2,499
  • 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.
Logged

Offline Eliana Tamerin

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 5,465
  • Gender: Female
Re: New SQL Server
« Reply #9 on: April 16, 2009, 03:53:45 PM »
Quote from: Fustrate on April 16, 2009, 03:26:48 PM
Quote from: SleePy on April 16, 2009, 03:25:20 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.
Logged
Do NOT PM me for support.

SimplePortal 2.3.5 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
Logged

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

  • Marketing
  • SMF Super Hero
  • *
  • Posts: 10,472
  • 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...
Logged
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,444
  • Gender: Male
  • The Artist Formerly Known as LexArma
Re: New SQL Server
« Reply #12 on: April 16, 2009, 04:05:09 PM »
Quote from: F.L.A.M.E.R 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...
My initial thoughts too - but after a little thought, with the speed the forum runs now, I guess we'll soon catch up ;)
Logged
Finnish Support Local Moderator & Support Specialist
My Mods: Facebook and Twitter Sharer


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

  • Marketing
  • SMF Super Hero
  • *
  • Posts: 10,472
  • 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)
Logged
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,467
  • 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 ;)
Logged
Steven Hoffman
Former Lead Developer

Quote
Antechinus: That's a really horrible thing to call someone
Fustrate: I just couldn't control myself!
Antechinus: I get like that with virgin goats
Antechinus: and you can quote that one ;)
Quote from: Richard Dawkins
We are all atheists about most of the gods that societies have ever believed in. Some of us just go one god further.

Offline Aleksi "Lex" Kilpinen

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


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

  • Marketing
  • SMF Super Hero
  • *
  • Posts: 10,472
  • 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..)
Logged
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)

  • Marketing
  • SMF Super Hero
  • *
  • Posts: 10,472
  • 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.
Logged
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,444
  • 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"
Logged
Finnish Support Local Moderator & Support Specialist
My Mods: Facebook and Twitter Sharer


Offline Dzonny

  • Lead Localizer
  • SMF Hero
  • *
  • Posts: 9,437
  • 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
Logged
|Sistem za razmenu banera|Servisi za webmastere| My Mods

Dont't fear the reaper...
mail: dzonny (@) simplemachines.org
Pages: [1] 2 3 ... 8   Go Up
« previous next »