What is the Web Server and Database used in SD.net ?

the_ace · Post by **the_ace** » 2004-03-01 02:26am

Can the admins please answer that as this is one of the few PHPBB2 forums I've seen that handles well without any kind of errors/bugs with a high number of members and posts.
Cause most PHPBB2 forums I've been in to give me timeout errors due to my slow internet connection.

Post by **fgalkin** » 2004-03-01 02:28am

It gives me timeout errors from time to time.

P.s. Welcome to SD.net!

Have a very nice day.
-fgalkin

Post by **Darth Wong** » 2004-03-01 02:30am

It actually ran better on my home system. But Lord MJ's server can handle the huge bandwidth this site generates, so I use his server despite some Java applets on the machine which eat up CPU cycles in huge bursts at certain times of day.

This thing would be lightning fast on my home machine since I kludged up a substitute for the search_wordmatch tables, but that's not really an option because my Internet connection is not as good as the connection that Lord MJ has in the datacentre.

the_ace · Post by **the_ace** » 2004-03-01 02:33am

I meant OS Platform/ webserver brand name/ DB server brand name...those details.
Or are they confidencial ?

His Divine Shadow · Post by **His Divine Shadow** » 2004-03-01 03:11am

I'm just guessing but I think he uses MySQL for the DB

Post by **Darth Wong** » 2004-03-01 03:13am

Database is MySQL 4.0.15 running on Linux (MJ's server is RedHat, mine is Mandrake). Webserver is Apache.

the_ace · Post by **the_ace** » 2004-03-01 03:36am

Thanks. That the config I thought it would be. Just one more question, Are both the DB and the web server on the same computer or are they hosted on 2 different computers ?

Post by **haas mark** » 2004-03-01 04:01am

-munches on n00bie- Welcome to SD.Net, enjoy your stay!

I don't *think* that they can be run on two machines, but then again, I don't know for sure, necessarily... so ignore me, as I'm getting some valuable info out of this as well..

Rogue 9 · Post by **Rogue 9** » 2004-03-01 04:02am

*Sigh* Why must you bite the newbies? *Gives The Ace an anti-ver vaccine.* Here, hit him with this stick if he tries it again. *Hands the newbie a stick.*

Post by **haas mark** » 2004-03-01 04:09am

Rogue 9 wrote:*Sigh* Why must you bite the newbies? *Gives The Ace an anti-ver vaccine.* Here, hit him with this stick if he tries it again. *Hands the newbie a stick.*

-takes stick from n00b and bashes Rogue- CYRAN'S JOB. -hands stick back to n00bie-

the_ace · Post by **the_ace** » 2004-03-01 04:32am

*takes the vaccine and swings the stick in a manner that'll scare a bunny rabbit*
Thanks Rouge.

@ verilon : it IS possible to have the 2 in different computers. Depending on your HW/SW configuration, sometimes it can be more efficient than having both on the same computer.

For eg : if you have a T3 net connection and a Gigabit LAN and loads web sites hosted on the web server computer then it is better to host the database on anther computer on that same LAN than having the DB on the same computer.

Post by **Darth Wong** » 2004-03-01 04:42am

Both are hosted on the same computer, although MJ's computer has a much heavier non-site processing load than mine, so mine (1GHz Celeron with 512MB of RAM and an 80MB Seagate HD) actually gives better performance with fewer hiccups even though his is more powerful (but as I said before, he has a much faster and more reliable connection than mine). That's why it runs off Lord MJ's server right now.

However, it should be noted that this is a tweaked version of phpBB. I disabled the standard search_wordmatch system because it doubles the database size (which is already >600MB even without it) and greatly increases the number of queries for a post or an edit. I replaced it with a simple MySQL fulltext search on the most recent 20000 posts, and people go to the Archive board in order to search older posts.

the_ace · Post by **the_ace** » 2004-03-01 04:51am

Thanks again. That ends my questions. Feel free to lock or nuke this thread.

Post by **haas mark** » 2004-03-01 05:14am

the_ace wrote:@ verilon : it IS possible to have the 2 in different computers. Depending on your HW/SW configuration, sometimes it can be more efficient than having both on the same computer.

Ok that makes sense.

Mlenk · Post by **Mlenk** » 2004-03-01 03:58pm

fgalkin wrote:It gives me timeout errors from time to time.

Same here, usually when I've been logged on for an hour straight or more.