Overclock.net banner

A more scalable web server

345 Views 17 Replies 7 Participants Last post by  timw4mail
I understand the popularity of Apache, because its so ubiquitous.

I propose that we switch our webserver to lighttpd or nginx, as they are less susceptible to being overloaded the way Apache is.

If it is the database, then perhaps a dedicated MySQL server?

I'm just disappointed at how often the site goes down, often at least once a day.
  • Rep+
Reactions: 1
1 - 18 of 18 Posts
OCN is already using lighttpd.
Quote:

Originally Posted by error10 View Post
OCN is already using lighttpd.
Then forgive my ignorance.
See less See more
is there any particular reason for the large downtimes?
Quote:


Originally Posted by Mxbn0
View Post

is there any particular reason for the large downtimes?

because ocn is telling us to get outside and find life
It's scary out there but you will learn
See less See more
2
lighttpd is light. MySQL is not. Not when you have almost 75,000 users and almost 5,000,000 posts. Don't forget millions of REP+'s, system infos, ratings, postbits, avatars, sigs, news, ads, and all the other various stuff that goes into generating each and every page. As you can imagine, the database is in an almost constant state of being hammered. Too much of that and it'll fall over. So it probably could use some optimization and hopefully some of these staff will be seeing to that.
Quote:


Originally Posted by error10
View Post

lighttpd is light. MySQL is not. Not when you have almost 75,000 users and almost 5,000,000 posts. Don't forget millions of REP+'s, system infos, ratings, postbits, avatars, sigs, news, ads, and all the other various stuff that goes into generating each and every page. As you can imagine, the database is in an almost constant state of being hammered. Too much of that and it'll fall over. So it probably could use some optimization and hopefully some of these staff will be seeing to that.

Its generally pretty scalable, but that magnitude...
Do we have a dedicated MySQL server?
See less See more
The Technical admins have more idea of what we run on. However I have to say that OCN rarely goes down for me.
Quote:

Originally Posted by timw4mail View Post
Its generally pretty scalable, but that magnitude...
Do we have a dedicated MySQL server?
I dunno, but I can say that in general the more resources you throw at it the better. Up to a point. If you're Google then you might have to architect your database a bit differently.


Maybe OCN's technical people will care to comment.
See less See more
2
Quote:


Originally Posted by timw4mail
View Post

Its generally pretty scalable, but that magnitude...
Do we have a dedicated MySQL server?

As far as I know, our backend is currently three servers. The only one I know specs on for certain is "kingpin", the web server, which consists of 2x quad core Harpertowns, 8gb of RAM, and 2x15k SAS drives. One of the database servers is configured very similarly to this, and somewhere in the mix the third one fits in, though I do not know its role or its specifications. Note though that's all off what I can remember, so it could be completely different.
I do know for certain that the two Harpertown servers were added to our existing hardware back in August.
See less See more
2
Quote:


Originally Posted by Chipp
View Post

As far as I know, our backend is currently three servers. The only one I know specs on for certain is "kingpin", the web server, which consists of 2x quad core Harpertowns, 8gb of RAM, and 2x15k SAS drives. One of the database servers is configured very similarly to this, and somewhere in the mix the third one fits in, though I do not know its role or its specifications. Note though that's all off what I can remember, so it could be completely different.
I do know for certain that the two Harpertown servers were added to our existing hardware back in August.

Maybe its time to look for alternatives to MySQL?
See less See more
2
Quote:


Originally Posted by timw4mail
View Post

Maybe its time to look for alternatives to MySQL?

In the near future admin will be bringing on a full-time tech admin, so decisions such as that would fall under his/her realm of knowledge. If its determined MySQL is indeed an issue, whatever can be done to rectify the problem will be done.
See less See more
2
Is the Rep panel in the User CP gone because of Database issues, or is that unrelated?
Quote:

Originally Posted by timw4mail View Post
Is the Rep panel in the User CP gone because of Database issues, or is that unrelated?
wow i didnt even notice but hes right its gone.
and the site goes down so often i have a little button that links to overclockstatus.net on my firefox
See less See more
2
Quote:

Originally Posted by timw4mail View Post
Is the Rep panel in the User CP gone because of Database issues, or is that unrelated?
As Scott_MC explained it, yes. It was removed to help prevent lockups (which I am going to assume were database related).
See less See more
Quote:

Originally Posted by Chipp View Post
As Scott_MC explained it, yes. It was removed to help prevent lockups (which I am going to assume were database related).
I was curious to see those comments, too...
See less See more
2
Quote:

Originally Posted by timw4mail View Post
I was curious to see those comments, too...

Rest assured they will be back in the future. Only a temporary move.
See less See more
2
Quote:


Originally Posted by Chipp
View Post

Rest assured they will be back in the future. Only a temporary move.

Good to know, thanks
See less See more
2
1 - 18 of 18 Posts
This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.
Top