Page 1 of 1

2011-08-24 downtime.

Posted: Wed Aug 24, 2011 8:45 pm
by Krom
So some of you might have noticed that the board was offline for a bit today, and even after it came back I had disabled it for a short while.

Well, the problem that has been a headache for RC and I for a while, the database log file growing to absurd proportions for no apparent or fixable reason finally reached its limits and mssql refused to serve the board anymore till we manually truncated the log file (which had no negative impact on the board and RC was able to do it from his smart phone). Then this evening I logged into the server and did what I've been meaning to do for quite some time: change the database back-end from the MSSQL server to a MySQL server RC kindly installed specifically for this board.

So on this new back-end, the out of control log file problem should be resolved (although I will be keeping an eye on it for sure). But more importantly MySQL brings a very useful side benefit: fulltext native mysql search indexing. So for the first time in years, the built in search engine on the board works.

TL/DR: SEARCH WORKS AGAIN.

P.S. there might be a minor blip of downtime tomorrow while I update the board software.

Re: Today's downtime.

Posted: Wed Aug 24, 2011 8:52 pm
by Spidey
Yay!

Good work

Re: Today's downtime.

Posted: Wed Aug 24, 2011 9:12 pm
by Isaac
Happy Isaac is successful happy! Thanks guys!

Re: Today's downtime.

Posted: Wed Aug 24, 2011 9:18 pm
by Jeff250
The MySQL conversion has been a long time coming--nice!

Re: Today's downtime.

Posted: Wed Aug 24, 2011 9:26 pm
by Isaac
Jeff, I replied to you in the tech forum, but I think the natural internet disaster erased it. It was not insured. I'll have to rewrite it. :P

Re: Today's downtime.

Posted: Wed Aug 24, 2011 11:10 pm
by Richard Cranium
All the kudos go to Krom on this one. Way to go on the DB conversion.

Re: Today's downtime.

Posted: Thu Aug 25, 2011 3:58 am
by Sergeant Thorne
Nice!

Re: Today's downtime.

Posted: Thu Aug 25, 2011 8:28 am
by Foil
Many thanks to RC and Krom! :D

<Hip! Hip! Hoorah!>

Re: 2011-08-24 downtime.

Posted: Thu Aug 25, 2011 8:51 am
by Krom
And the board software update to the latest version is done.

Re: 2011-08-24 downtime.

Posted: Thu Aug 25, 2011 9:00 am
by Isaac
Cool. So the forum is more stable and faster?

Re: 2011-08-24 downtime.

Posted: Thu Aug 25, 2011 9:02 am
by Krom
Mostly security fixes.

Re: 2011-08-24 downtime.

Posted: Thu Aug 25, 2011 9:53 am
by Isaac
Oh yeah, that's good. There's a lot of crazies out there. Its good we have more security.

Re: 2011-08-24 downtime.

Posted: Thu Aug 25, 2011 4:10 pm
by Tunnelcat
Thanks Krom and everyone else who has worked hard to maintain and upgrade the DBB board. It's getting really polished now. :)

Re: 2011-08-24 downtime.

Posted: Fri Aug 26, 2011 1:35 pm
by snoopy
Thanks for the work!

Re: 2011-08-24 downtime.

Posted: Sat Aug 27, 2011 6:42 am
by callmeslick
good job, and thanks. Folks who do the work to maintain places like this are so valuable!

Re: 2011-08-24 downtime.

Posted: Sun Aug 28, 2011 5:27 pm
by Duper
*faint!*

(well done guys!)