Results 1 to 12 of 12
-
09-14-2009, 08:56 PM #1Newbie
- Join Date
- Jun 2008
- Posts
- 28
Optimizing for 10K users + vBulletin
Hello, I run a website on a dedicated server on the following specs
Processor: Dual Xeon E5520 Quad Core (Gainstown)
Memory: 4GB DDR RAM
Hd1: 250GB 7200RPM SATA / 8MB Cache
Hd2: 160GB 7200RPM SATA / 8MB Cache
OS: Linux - CentOS 5
(+64 Bit)
(My site is the ONLY site on the server)
On saturday I will have a heavy load -- almost 1-10K users active and registering constantly.
How do I make sure that my server does not CRASH! or go to 1 minute page load times.
I think the big thing it he mySQL on vBulletin. IT has to have the correct settings and be optimized to its fullest so it does not take a hit.
Any help is appreciated.
Thank you
-
09-14-2009, 09:41 PM #2Junior Guru
- Join Date
- May 2007
- Location
- Canada
- Posts
- 183
Sounds like you need to split your web and db servers, so that one does not do all the work. If you are stuck with what you have, you need to start doing some tweaking to your apache and mysql configuration files to optimize for what you have. Faster drives would help as well. I wrote a little article a while back about tuning mysql:
http://solidservers.ca/2009/07/tuning-tweaking-mysql/Quality Hosting - http://www.robohostingsolutions.com
My Blog - http://solidservers.ca
Freelance Server Administration (decent rates!) - Chris(at)SolidServers.ca
-
09-14-2009, 09:49 PM #3Newbie
- Join Date
- Jun 2008
- Posts
- 28
How do i split my DB and the web servers ? Like how do I get them to work with each other.
-
09-14-2009, 09:54 PM #4Web Hosting Master
- Join Date
- Jun 2008
- Posts
- 1,471
Just need to change your vBulletin configuration file and instead of pointing it to the MySQL server at 127.0.0.1, point it to the IP of the external MySQL server.
You'll want to take your forum offline, dump your database, and then restore it on your new/separate MySQL server and make the change to the vBulletin configuration.
-
09-14-2009, 10:07 PM #5Junior Guru
- Join Date
- Mar 2009
- Location
- Rocky Face, GA
- Posts
- 196
I've worked quite a bit with vBulletin over the course of the past few years and this is a question that comes up quite often as communities grow, expand and the traffic begins to roll in.
1). Upgrade The Memory/RAM to 8GB
A system with 4GB of RAM is great, if it's a desktop, but when it comes to a busy on-line community that is processing multiple requests every minute (every second even), the additional boost in RAM will come in handy. It will especially come in handy for #2.
2). Install an OP-Code Cacher
MemCache is supported by vBulletin as is xCache. They need to be installed as a root user or using SU. My experience is primarily with xCache so that is the one that I personally recommend that you use.
xCache will cache the most frequently accessed PHP files to RAM which drops the number of requests to the MySQL database and thus reduces the overall load placed on the server from MySQL.
Setting the value to 32-64MB is suggested, however, if you receive a high amount of OOM (Out of Memory) errors in the xCache control panel, then you may want to increase that to 128MB depending on your setup. That said, xCache has a built-in flushing system (garbage collection) which will automatically flush out files that are expired and allow them to be re-cached.
3). Optimize Your MySQL Configuration (my.cnf)
If you are using a standard MySQL installation, chances are MySQL has not been optimized and you're running on a OOB install. Optimizing my.cnf to make use of query-caching and a number of other built-in features will drastically reduce the overall load placed on the server by reducing the number of requests needed.
There are a few suggestions floating around the web. If you need a pretty good my.cnf configuration, shoot me a PM with your current my.cnf file and I'll be more than happy to make some modifications for you (for free, of course!).
4). Optimize PHP (php.ini)
As with any PHP install, if you don't need something, disable it or don't configure PHP with it. There are a number of functions that can be disabled in PHP and combining that with the use of xCache will greatly boost PHP performance.
5). Optimize Apache (apache.conf)
This is really a tricky area as it needs to really (and honestly) be constantly tweaked according to the traffic you're receiving. You'll need to test the waters a bit and see what works best for you and then continue tweaking until you only need to modify the values every now and then.
The other route is to split into 2 servers, one for PHP/Apache/E-Mail and the other for MySQL. You can still apply the above to a dual-server setup. This is a more costly route (of course, depending on what you pay for the above), but if you continue to grow and receive that sort of traffic, it is where you're heading.
A single server will only carry you so far unless you plan on dropping some serious cash on a Quad-CPU (not quad-core) setup with 12-32GB of RAM and even then, HD I/O is going to be your one disadvantage as it won't be able to keep up with the CPU.Michael T. @ Resellr.Net - CEO
The Premier Reseller Hosting Solution
Visit Us @ Resellr.Net | Follow Resellr.Net on Twitter
-
09-14-2009, 10:08 PM #6Newbie
- Join Date
- Jun 2008
- Posts
- 28
oh i see i will look into that. Currently i am switching to nginx and installing x-cache. Is that good ?
Currently I am having my managed personal looking at optimizing everything. I am having trouble integrated x-cache with vBulletin.
Also the managed person tech recommended FAST-CGI. Is that a good choice.
Please adviseLast edited by XfrostX; 09-14-2009 at 10:13 PM.
-
09-14-2009, 11:18 PM #7Web Hosting Guru
- Join Date
- Oct 2005
- Posts
- 292
Nginx and PHP/FastCGI should not be a problem.
But as others suggested, I also strongly recommended taking a second look at your MySQL configuration (my.cnf). Tell your host to change the MySQL config memory model to make full good use of at least 2-3 gig of your ram.
Remember to ask your managed hosting personnel to tell you what *caused* the slowdown. Most of the time, it would be IO from our database.
-
09-14-2009, 11:55 PM #8Newbie
- Join Date
- Jun 2008
- Posts
- 28
ok thanks, and what should my php memory limit be ?
-
09-15-2009, 01:37 AM #9Web Hosting Master
- Join Date
- Jun 2008
- Posts
- 1,471
That is the least of your concern. Its just a limit to make sure that a single script does use an absurd amount of memory, the default is something like 32 or 64M, and I think 32M is plenty.
Nginx is a great choice, and yes, absolutely fast-cgi, because cgi has horrible performance.
It is really important to tune your configuration values correctly. I use Lighttpd on sites that receive ~100requests/second of dynamic (PHP) only content and I've found you can dramatically improve or degrade performance through "bad" configuration.
-
09-18-2009, 10:24 PM #10Junior Guru Wannabe
- Join Date
- Aug 2009
- Posts
- 43
#1 use nginx
#2 use php-fpm with nginx
#3 use xcache or apc for the opcode cacher
#4 use sphinx for searches or anything that will use "ORDER BY" in queries , you will thank me later
Using these 4, you can easily EASILY handle the load on a single server.
-
09-18-2009, 10:27 PM #11Web Hosting Master
- Join Date
- Apr 2007
- Posts
- 652
I would suggest for something as critical as this to use a seasoned professional -- so it doesn't go crashing on you. One that comes to mind is Steven from rack911.com
Hope whatever you decide goes well for you.Justin Yancey | Northern Virginia & District of Columbia | https://www.linkedin.com/in/justinyancey
-
09-20-2009, 03:41 PM #12New Member
- Join Date
- Sep 2009
- Posts
- 1
memcache did the job for my VB community. Having a separate drive for your log files, and a separate drive for your /var/lib/mysql (in my case a SSD drive) would boost your performance as well. On the other hand, as everybody else pointed out, 4GB of memory seems to be low for that kind of traffic.
Similar Threads
-
Need help from VBulletin users
By VinaGal in forum Web Hosting LoungeReplies: 2Last Post: 11-12-2006, 03:02 PM -
Making ModernBill use the vBulletin users
By pergesu in forum Hosting Software and Control PanelsReplies: 1Last Post: 06-20-2006, 09:11 AM -
Existing ModernBill users for Vbulletin
By Ivan23 in forum Hosting Security and TechnologyReplies: 0Last Post: 11-20-2005, 09:24 PM -
vbulletin users, please shed a light
By silhouette in forum Programming DiscussionReplies: 0Last Post: 05-09-2005, 02:35 PM -
vbulletin users come in!
By d3nnis in forum Web Hosting LoungeReplies: 4Last Post: 12-18-2003, 05:43 AM