News for hackers. Stuff that matters.
Re:Stack Overflow running short on space by StavrosK on Tuesday February 07, 2012 @12:16AM (#3560558)
Does anyone know if there's any specific reason why they have multiple databases on the same box? From what I see, one could trivially install the full text search engine on another server and reduce much of the space requirements and contention.
Re:Stack Overflow running short on space by jacques_chester on Tuesday February 07, 2012 @12:21AM (#3560569)
If you read closely, you'll see that StackOverflow's database has been moved onto its own hardware away from other StackExchange sites.

I think they're using SQL Server's inbuilt text search engine (edit: no, see below).

Re:Stack Overflow running short on space by JeremyBanks on Tuesday February 07, 2012 @12:57AM (#3560648)
Actually, they switched to Lucene.NET a year ago: http://blog.stackoverflow.com/2011/01/stack-overflow-search-... It sounds as though the search indexing isn't done by the database server anymore.
Re:Stack Overflow running short on space by jacques_chester on Tuesday February 07, 2012 @12:59AM (#3560653)
Thanks for the correction.
Re:Stack Overflow running short on space by StavrosK on Tuesday February 07, 2012 @01:51AM (#3560777)
Oh, no, I see that, I meant why don't they put the full text search engine (Lucene.NET, as per the comment below) on its own server. Wouldn't that make more sense, if they're running into this trouble?
Re:Stack Overflow running short on space by nick_craver on Tuesday February 07, 2012 @06:48AM (#3561381)
We have done just that, Lucene.Net runs on the web tier which is otherwise severely under-utilized hardware (all servers sat at under 10% CPU before we moved search to it). But, it will be moving again soon (we're actually discussing that today). I'll have a another post around this architecture shift for search and a few other things coming up.
Re:Stack Overflow running short on space by StavrosK on Tuesday February 07, 2012 @08:36AM (#3561664)
Ah, thanks, I figured that was a good move.