2011-08-24 downtime.
Moderators: Krom, Lothar, Richard Cranium, KoolBear
- Krom
- DBB Database Master
- Posts: 16137
- Joined: Sun Nov 29, 1998 3:01 am
- Location: Camping the energy center. BTW, did you know you can have up to 100 characters in this location box?
- Contact:
2011-08-24 downtime.
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.
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.
Yay!
Good work
Good work
Re: Today's downtime.
Happy Isaac is successful happy! Thanks guys!
❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉
-⎽__⎽-⎻⎺⎺⎻-⎽__⎽--⎻⎺⎺⎻-★ ·:*¨༺꧁༺ ༻꧂༻¨*:·.★-⎽__⎽-⎻⎺⎺⎻-⎽__⎽--⎻⎺⎺⎻-
❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉
-⎽__⎽-⎻⎺⎺⎻-⎽__⎽--⎻⎺⎺⎻-★ ·:*¨༺꧁༺ ༻꧂༻¨*:·.★-⎽__⎽-⎻⎺⎺⎻-⎽__⎽--⎻⎺⎺⎻-
❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉
Re: Today's downtime.
The MySQL conversion has been a long time coming--nice!
Re: Today's downtime.
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.
❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉
-⎽__⎽-⎻⎺⎺⎻-⎽__⎽--⎻⎺⎺⎻-★ ·:*¨༺꧁༺ ༻꧂༻¨*:·.★-⎽__⎽-⎻⎺⎺⎻-⎽__⎽--⎻⎺⎺⎻-
❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉
-⎽__⎽-⎻⎺⎺⎻-⎽__⎽--⎻⎺⎺⎻-★ ·:*¨༺꧁༺ ༻꧂༻¨*:·.★-⎽__⎽-⎻⎺⎺⎻-⎽__⎽--⎻⎺⎺⎻-
❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉
-
- DBB Supporter
- Posts: 1444
- Joined: Tue Aug 07, 2001 2:01 am
Re: Today's downtime.
All the kudos go to Krom on this one. Way to go on the DB conversion.
- Sergeant Thorne
- DBB Material Defender
- Posts: 4641
- Joined: Sun Nov 25, 2001 3:01 am
- Location: Indiana, U.S.A.
Re: Today's downtime.
Nice!
- Foil
- DBB Material Defender
- Posts: 4900
- Joined: Tue Nov 23, 2004 3:31 pm
- Location: Denver, Colorado, USA
- Contact:
Re: Today's downtime.
Many thanks to RC and Krom!
<Hip! Hip! Hoorah!>
<Hip! Hip! Hoorah!>
- Krom
- DBB Database Master
- Posts: 16137
- Joined: Sun Nov 29, 1998 3:01 am
- Location: Camping the energy center. BTW, did you know you can have up to 100 characters in this location box?
- Contact:
Re: 2011-08-24 downtime.
And the board software update to the latest version is done.
Re: 2011-08-24 downtime.
Cool. So the forum is more stable and faster?
❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉
-⎽__⎽-⎻⎺⎺⎻-⎽__⎽--⎻⎺⎺⎻-★ ·:*¨༺꧁༺ ༻꧂༻¨*:·.★-⎽__⎽-⎻⎺⎺⎻-⎽__⎽--⎻⎺⎺⎻-
❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉
-⎽__⎽-⎻⎺⎺⎻-⎽__⎽--⎻⎺⎺⎻-★ ·:*¨༺꧁༺ ༻꧂༻¨*:·.★-⎽__⎽-⎻⎺⎺⎻-⎽__⎽--⎻⎺⎺⎻-
❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉
- Krom
- DBB Database Master
- Posts: 16137
- Joined: Sun Nov 29, 1998 3:01 am
- Location: Camping the energy center. BTW, did you know you can have up to 100 characters in this location box?
- Contact:
Re: 2011-08-24 downtime.
Mostly security fixes.
Re: 2011-08-24 downtime.
Oh yeah, that's good. There's a lot of crazies out there. Its good we have more security.
❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉
-⎽__⎽-⎻⎺⎺⎻-⎽__⎽--⎻⎺⎺⎻-★ ·:*¨༺꧁༺ ༻꧂༻¨*:·.★-⎽__⎽-⎻⎺⎺⎻-⎽__⎽--⎻⎺⎺⎻-
❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉
-⎽__⎽-⎻⎺⎺⎻-⎽__⎽--⎻⎺⎺⎻-★ ·:*¨༺꧁༺ ༻꧂༻¨*:·.★-⎽__⎽-⎻⎺⎺⎻-⎽__⎽--⎻⎺⎺⎻-
❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉
- Tunnelcat
- DBB Grand Master
- Posts: 13738
- Joined: Sat Mar 24, 2007 12:32 pm
- Location: Pacific Northwest, U.S.A.
Re: 2011-08-24 downtime.
Thanks Krom and everyone else who has worked hard to maintain and upgrade the DBB board. It's getting really polished now.
Cat (n.) A bipolar creature which would as soon gouge your eyes out as it would cuddle.
Re: 2011-08-24 downtime.
Thanks for the work!
Arch Linux x86-64, Openbox
"We'll just set a new course for that empty region over there, near that blackish, holeish thing. " Zapp Brannigan
"We'll just set a new course for that empty region over there, near that blackish, holeish thing. " Zapp Brannigan
- callmeslick
- DBB Grand Master
- Posts: 14546
- Joined: Sat Apr 09, 2011 8:12 am
- Location: Rockland,DE and Parksley, VA
Re: 2011-08-24 downtime.
good job, and thanks. Folks who do the work to maintain places like this are so valuable!
"The Party told you to reject all evidence of your eyes and ears. It was their final, most essential command."
George Orwell---"1984"
George Orwell---"1984"
Re: 2011-08-24 downtime.
*faint!*
(well done guys!)
(well done guys!)