Advertisement:

Author Topic: New SQL Server  (Read 288376 times)

Offline dschwab9

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

Offline dschwab9

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

Offline GravuTrad

  • Senior Translator
  • SMF Hero
  • *
  • Posts: 8,490
  • 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 »
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
  • Server Team
  • SMF Hero
  • *
  • Posts: 5,320
  • Gender: Male
    • Technology, Ministry and Other Ramblings
Re: New SQL Server
« Reply #23 on: April 16, 2009, 05:25: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 ::)

The forum isn't putted in maintenance mode before this kind of operation?
It was in maintenance mode....

Offline Eliana Tamerin

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 5,515
  • 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." ?
Do NOT PM me for support.

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

Online zilladotexe

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,203
  • Gender: Male
    • zilladotexe on GitHub
    • @zilladotexe on Twitter
    • XboxLeaders.com
Re: New SQL Server
« Reply #25 on: April 16, 2009, 05:46:49 PM »
* JBlaze lost ~35 posts :(

All for the better though :)
zilladotexe
Formerly known as "JBlaze"
Former Support & Customization     
Professional Bug Creator
Current Projects     
Xbox LIVE API
SM Classifieds
SimpleXBL
Important Links
Please, no PMs for support.
Unmanaged VPS Starting at $20/mo

Offline GravuTrad

  • Senior Translator
  • SMF Hero
  • *
  • Posts: 8,490
  • 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?
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,700
    • Disturbed Message Board
Re: New SQL Server
« Reply #27 on: April 16, 2009, 06:25:09 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?

bullbreedluverz

  • Guest
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

Offline Nolt

  • Language Moderator
  • Full Member
  • *
  • Posts: 455
  • 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.

Online zilladotexe

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,203
  • Gender: Male
    • zilladotexe on GitHub
    • @zilladotexe on Twitter
    • XboxLeaders.com
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?
zilladotexe
Formerly known as "JBlaze"
Former Support & Customization     
Professional Bug Creator
Current Projects     
Xbox LIVE API
SM Classifieds
SimpleXBL
Important Links
Please, no PMs for support.
Unmanaged VPS Starting at $20/mo

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 #31 on: April 16, 2009, 09:00:17 PM »
As I understand it, no.
Steven Hoffman
Former Team Member, 2009-2012

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 #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.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub
G+

Offline GravuTrad

  • Senior Translator
  • SMF Hero
  • *
  • Posts: 8,490
  • 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
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.

Online zilladotexe

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,203
  • Gender: Male
    • zilladotexe on GitHub
    • @zilladotexe on Twitter
    • XboxLeaders.com
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 :(
zilladotexe
Formerly known as "JBlaze"
Former Support & Customization     
Professional Bug Creator
Current Projects     
Xbox LIVE API
SM Classifieds
SimpleXBL
Important Links
Please, no PMs for support.
Unmanaged VPS Starting at $20/mo

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 #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!
Need paid assistance for your forum? CLICK ME!
Email: flamer@simplemachines.org (Stop sending me love proposals! I don't do Internet dating :P)

Online zilladotexe

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,203
  • Gender: Male
    • zilladotexe on GitHub
    • @zilladotexe on Twitter
    • XboxLeaders.com
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 :(
zilladotexe
Formerly known as "JBlaze"
Former Support & Customization     
Professional Bug Creator
Current Projects     
Xbox LIVE API
SM Classifieds
SimpleXBL
Important Links
Please, no PMs for support.
Unmanaged VPS Starting at $20/mo

Offline IchBin™

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,110
  • 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.


Brad "IchBin™" Grow        TinyPortal        Themes
Coding Guidelines       

Offline aldo

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

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 #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
Finnish Support Local Moderator & Support Specialist
My Mods: Facebook and Twitter Sharer