News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Simple Machines is proud to announce that we have added a new server.

Started by Amacythe, July 19, 2006, 01:27:36 AM

Previous topic - Next topic

MH-MINI

Didn't know that the DB would grow that fast, I think [Unknown] announced last year or so that it was about 270MB or something.

Mini

klumy

Quote from: dschwab9 on October 04, 2006, 10:35:34 PM
The database is 2.9 gigs

in this case it would make sense to increase the ramsiye so the whole database could be loaded into the ram, which would improve speed

dschwab9

But in reality, the whole database doesn't need to fit in RAM in our case.    For example, lots of the database records are really really old (from the forum, years back, for example), and aren't necessarily queried very often.

Trust me, the database server is doing just fine ;D   At the moment, it's only using 1.8GB of RAM and all of MySQL's caches are at healthy untilization levels, which means any additional RAM would just be sitting around unused (and costing money).   I'm all about having beefy servers, but you reach a point where any extra is just over kill.   If/when we start swapping a lot, we'll add another gig of RAM.   It's just not necessary at the moment.

Bas

Nice new DB server Derek, but I would knock out that old Pentium4 and let the Opties do it all.
That would speed up even more :)
And you are right, more ram costs a lot when it's doing nothing ;)
Greetings Bas.

Luke Beale

That is good as i couldnt get on here a few times but now it should be up all the time  :D

Bas

The system goes down a lot, in the last couple of weeks it was donw more then 4 times for a long time.
Using more servers just complicates the matter to keep it running.
Greetings Bas.

青山 素子

Quote from: Bas on December 15, 2006, 02:36:25 PM
Using more servers just complicates the matter to keep it running.

Of course, it all depends on what is causing the problems. Sometimes you need to add a server to solve a problem. Separating the database from the website server is beneficial on a site like this as you can then tune each server for the type of load on it. While you do have the problem of interconnectivity with that type of arrangement, you might have made your problems simpler.
Motoko-chan
Director, Simple Machines

Note: Unless otherwise stated, my posts are not representative of any official position or opinion of Simple Machines.


Bas

I disagree a whole lot.
The server on this site is made too complicated over nothing.
I wonder how much traffic it does, but did you ever calculated how much traffic a simple 100Mbit card can do a month?
It will scare the living daylight out of anybody.
More servers doesn't need to give more speed, it might, but for sure more servers gives more overhead....and the overhead should be talken very light, as it will be a lot.
Sorry I disagree with you a lot, there is no point to seperate 1 webserver from 1 database server, unless you have 10 webservers using the same database, only then you have a solid point.
Greetings Bas.

青山 素子

It isn't so much speed as load. 100 mbit is very fast, and if you are serving static content you don't need anything fancy (although system RAM is helpfl for caching at that point).

If, however, you are moving onto dynamic sites, you might run into an issue where one side or another is fighting for resources. At that point, if you've already done all you can to help that situation, it might make more sense to build out instead of up (add another machine rather than getting a bigger machine). Once you do that, you can then work on making each part work as best it can on the server it is sitting on.
Motoko-chan
Director, Simple Machines

Note: Unless otherwise stated, my posts are not representative of any official position or opinion of Simple Machines.


Bas

Yeah all nice, but the servers here (SMF server) crash a couple of times a week.
So it didn't improve that much.
I wish they would move all to the Opterons, then the crashing should be a thing from the past ;)
Greetings Bas.

青山 素子

Moving to an Opteron isn't the proper solution if there is no need to. In at least one of the cases, there was some problem with the mail queue.
Motoko-chan
Director, Simple Machines

Note: Unless otherwise stated, my posts are not representative of any official position or opinion of Simple Machines.


dschwab9

Guys, I think we've had enough discussion on this.   Bottom line is, we have two servers, one database and one web server.   It might grow in the future, however, there is no chance of it going back to one server.  What we are doing works, and works well.   Yes, there have been some glitches, but that's part of growing, AND, the majority of them end up being connectivity issues beyond our control.

Advertisement: