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

Author Topic: New SQL Server  (Read 254396 times)

Offline dschwab9

  • IT Director/Server Admin
  • Servers Team
  • SMF Hero
  • *
  • Posts: 5,322
  • Gender: Male
    • Technology, Ministry and Other Ramblings
Re: New SQL Server
« Reply #20 on: April 16, 2009, 04:39:01 PM »
Will look at search shortly. I think I need to reconfigure Sphynx to work with the new server.
Logged

Offline dschwab9

  • IT Director/Server Admin
  • Servers Team
  • SMF Hero
  • *
  • Posts: 5,322
  • Gender: Male
    • Technology, Ministry and Other Ramblings
Re: New SQL Server
« Reply #21 on: April 16, 2009, 04:48:41 PM »
Search should be working now.
Logged

Offline GravuTrad

  • Senior Translator
  • SMF Hero
  • *
  • Posts: 8,201
  • Gender: Male
  • One of the french SMF translators
Re: New SQL Server
« Reply #22 on: April 16, 2009, 05:12:23 PM »
The forum isn't putted in maintenance mode before this kind of operation?

for the search problem, it was like each change of server, sphinx problem like you said. ;)
http://www.simplemachines.org/community/index.php?topic=295395.msg1949737#msg1949737
http://www.simplemachines.org/community/index.php?topic=295395.msg1954602#msg1954602
http://www.simplemachines.org/community/index.php?topic=217492.0

Thanks derek

nb: the requests go really faster now, thanks.
« Last Edit: April 16, 2009, 05:21:52 PM by GravuTrad »
Logged
On a toujours besoin d'un plus petit que soi! (Petit!Petit!)



Think about Search function before posting.
Pensez à la fonction Recherche avant de poster.

Offline dschwab9

  • IT Director/Server Admin
  • Servers Team
  • SMF Hero
  • *
  • Posts: 5,322
  • Gender: Male
    • Technology, Ministry and Other Ramblings
Re: New SQL Server
« Reply #23 on: April 16, 2009, 05:25:18 PM »
Quote from: Nao 尚 on April 16, 2009, 05:06:18 PM
It's all great news, except... If it was planned, couldn't the team have performed a backup before upgrading?
We did - that's why it was only 4 hours instead of days worth of stuff ::)

Quote from: GravuTrad on April 16, 2009, 05:12:23 PM
The forum isn't putted in maintenance mode before this kind of operation?
It was in maintenance mode....
Logged

Offline Eliana Tamerin

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 5,469
  • Gender: Female
Re: New SQL Server
« Reply #24 on: April 16, 2009, 05:42:12 PM »
You didn't see the blank page with black text that said "We're upgrading the server." ?
Logged
Do NOT PM me for support.

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

Offline JBlaze

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,872
  • Gender: Male
    • realjblaze on Facebook
    • realjblaze on LinkedIn
    • @jasonclemons on Twitter
    • My Blog
Re: New SQL Server
« Reply #25 on: April 16, 2009, 05:46:49 PM »
* JBlaze lost ~35 posts :(

All for the better though :)
Logged
The nefarious Jason "JBlaze" Clemons

Twitter GitHub Forrst

Xbox LIVE API - A simple and powerful REST API for reading Xbox LIVE data.

Offline GravuTrad

  • Senior Translator
  • SMF Hero
  • *
  • Posts: 8,201
  • Gender: Male
  • One of the french SMF translators
Re: New SQL Server
« Reply #26 on: April 16, 2009, 06:05:01 PM »
Yes i had it, but if you are in maintenance mode, you do a backup of your bases and you reinject them in the new server, you don't lose any posts.

So the migration process is on the fly between the two servers? (like do plesk for example)
no backup before? to can redo it as much as you want?
Logged
On a toujours besoin d'un plus petit que soi! (Petit!Petit!)



Think about Search function before posting.
Pensez à la fonction Recherche avant de poster.

Offline TheDisturbedOne

  • SMF Hero
  • ******
  • Posts: 1,702
    • Disturbed Message Board
Re: New SQL Server
« Reply #27 on: April 16, 2009, 06:25:09 PM »
Quote from: dschwab9 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.
A quick questiion.  About how big is the SQL database for the community forums?
Logged

Offline stikkki

  • SMF Hero
  • ******
  • Posts: 2,537
  • im just the idiot the pc employs 2 click the mouse
    • eots dzine smf themes
Re: New SQL Server
« Reply #28 on: April 16, 2009, 06:48:22 PM »
hey its great to have the server issues sorted

but just a thought

as is done on most sites if staff plan to put the site in maintenance mode it would be nice if an announcement was made to inform members that scheduled work will be taking place

if there was an announcement made then i didnt see it but i see nothing in news & updates and i recieved no email/newsletter
Logged

Offline Nolt

  • Language Moderator
  • Full Member
  • *
  • Posts: 406
  • Gender: Male
  • SMF Polish Translator
    • smfpolska on Facebook
    • Wizzi
Re: New SQL Server
« Reply #29 on: April 16, 2009, 06:49:36 PM »
Great job... and thanks for this upgrade.
Logged

Offline JBlaze

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,872
  • Gender: Male
    • realjblaze on Facebook
    • realjblaze on LinkedIn
    • @jasonclemons on Twitter
    • My Blog
Re: New SQL Server
« Reply #30 on: April 16, 2009, 08:59:44 PM »
Just a quick question...

Can the lost posts be recovered or not?
Logged
The nefarious Jason "JBlaze" Clemons

Twitter GitHub Forrst

Xbox LIVE API - A simple and powerful REST API for reading Xbox LIVE data.

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 #31 on: April 16, 2009, 09:00:17 PM »
As I understand it, no.
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 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 #32 on: April 16, 2009, 09:07:53 PM »
For only 4 hours of posts, I don't think it is worth it really.

Its only 4 hours, it isn't like its 4 months.
Logged
]
Jeremy D — Ex-Site Manager
Support the SMF Support team!
Profiles:
GitHub
G+

Offline GravuTrad

  • Senior Translator
  • SMF Hero
  • *
  • Posts: 8,201
  • Gender: Male
  • One of the french SMF translators
Re: New SQL Server
« Reply #33 on: April 16, 2009, 09:24:52 PM »
I believe the real question was, for 4 hours of post, why don't redo the migration...
This question was important to answer for derek and the team, the choose has been taken, it's now to late...

so...4 hours of posts is not a lot for each member...maybe it's more with the total of the members of this forum...but the choices have been made. It's over now. ;)

We have to go to something else now...life continues lol.... :D
Logged
On a toujours besoin d'un plus petit que soi! (Petit!Petit!)



Think about Search function before posting.
Pensez à la fonction Recherche avant de poster.

Offline JBlaze

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,872
  • Gender: Male
    • realjblaze on Facebook
    • realjblaze on LinkedIn
    • @jasonclemons on Twitter
    • My Blog
Re: New SQL Server
« Reply #34 on: April 16, 2009, 09:26:46 PM »
I was just asking :)

The nice conversation I was having in the Chit Chat board is now gone :(
Logged
The nefarious Jason "JBlaze" Clemons

Twitter GitHub Forrst

Xbox LIVE API - A simple and powerful REST API for reading Xbox LIVE data.

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

  • Marketing
  • SMF Super Hero
  • *
  • Posts: 10,486
  • Gender: Male
  • I am a ninja!
    • adishpatel on Facebook
Re: New SQL Server
« Reply #35 on: April 16, 2009, 09:30:36 PM »
Please dont do further migration for now until you are sure with the totally. I finally finished the 2 pages of Support topics again! ...Phew!
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 JBlaze

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,872
  • Gender: Male
    • realjblaze on Facebook
    • realjblaze on LinkedIn
    • @jasonclemons on Twitter
    • My Blog
Re: New SQL Server
« Reply #36 on: April 16, 2009, 09:32:00 PM »
Also, on another note, I dont know if this was covered but i have lost 15+ PM's, some of which were important :(
Logged
The nefarious Jason "JBlaze" Clemons

Twitter GitHub Forrst

Xbox LIVE API - A simple and powerful REST API for reading Xbox LIVE data.

Offline IchBin™

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,920
  • Gender: Male
  • I don't speak German.
    • IchBin.us
Re: New SQL Server
« Reply #37 on: April 16, 2009, 10:03:06 PM »
I think you guys missed out on some key points. They put the forum in maintenance mode to do the DB migration. Trying to do a backup BEFORE they do the migration. Derek lost the connection during this, so it sounds like he had to roll back to a previous backup. There's no point in trying to recover if the site has been opened up again... Especially since it sounds like he doesn't have anything to restore to other than a previous backup before the disconnect.

Derek,

Thanks for your hard work. From what I hear your work schedule has been really hellish for you lately. The fact that you had the time, and were able to give it to SMF to fix our issues is very generous of you. Thank you for your hard work and dedication. You da man! This site is faster than it has been in long time for me. Two thumbs up for you.


Logged
Brad "IchBin™" Grow        TinyPortal        Themes
Coding Guidelines       

Offline aldo

  • Sophist Member
  • *****
  • Posts: 1,357
  • Gender: Male
Re: New SQL Server
« Reply #38 on: April 16, 2009, 11:43:16 PM »
Sweet! Seems faster, but what do I know? ::)
Logged

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 #39 on: April 17, 2009, 01:15:57 AM »
I would like to say my thanks as well, my site hasn't really been  too fast lately (since we're really limited on cash and have to make compromises with limited resources :P ) and still SMF seemed even slower lately - but after this change - I want a new server too!  :P
Logged
Finnish Support Local Moderator & Support Specialist
My Mods: Facebook and Twitter Sharer


Pages: 1 [2] 3 4 ... 8   Go Up
« previous next »