hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : VPS Hosting : Is VPS enough?
Reply

Forum Jump

Is VPS enough?

Reply Post New Thread In VPS Hosting Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 05-04-2012, 09:23 AM
ataozcelik ataozcelik is offline
New Member
 
Join Date: May 2012
Posts: 4

Is VPS enough?


Hi,

I just want to get to know what is the best solution for my website. Currently I have vBulletin (PHP) forum running on my website where DB size is around 1GB (1 million + posts) and 1200 active users. During the peak time my forum has 500 online users but in the average 150-200 users are online all the day.

Currently I'm in a VPS server with this spec:

Disk: 75 GB
RAM: 2 GB
OS: CentOS
Traffic: 450 GB

The problem is when I have over 300 users online the server basically stops responding and I need to restart the server. When I check the logs I see there are several resource alerts regarding shared_cpu where the system enters the red zones. What I can see is MySql consumes a lot of processing power which blocks the server after this number of users.

Now, should I look for an alternative VPS solution or should I consider a dedicated server? Although I have massive users engaging I don't need a large disk ( may be 2 small disks where mysql sits on a different disk) , not so much traffic. What are your suggestions for me?



Sponsored Links
  #2  
Old 05-04-2012, 09:44 AM
Collabora Collabora is offline
Disabled
 
Join Date: Mar 2009
Location: Santa Monica, CA
Posts: 3,372
Its difficult to say if you should take the leap. Are you using any plugins? Have you tried any optimizations (e.g. memcache, overide maxclient with swtune.conf, tunining sql queries, etc)? Check I/O with "iostat" and "sar -a" and post results

  #3  
Old 05-04-2012, 09:48 AM
ataozcelik ataozcelik is offline
New Member
 
Join Date: May 2012
Posts: 4
I don't use any plugins and do not have any optimizations other than this:

<IfModule prefork.c>
StartServers 16
MinSpareServers 10
MaxSpareServers 40
ServerLimit 512
MaxClients 512
MaxRequestsPerChild 8000

Should I check the I/O now or when it is heavily loaded? I am not so well familiar with Linux but can do some optimizations if you guide me, thank you very much for your help.

Sponsored Links
  #4  
Old 05-04-2012, 10:45 AM
ControlVM ControlVM is offline
We Love Xen® Hypervisor
 
Join Date: Aug 2009
Posts: 3,154
If you are currently with OpenVZ I'd suggest you move to Xen which personally I like it stability.

__________________
ControlVM Technology
SSD KVM VPSForex VPSXen VPS Hosted PBX ● Hosted VoIP VPS
6 Data Centers: USA (Los Angeles - - Kansas City - - Phoenix) ● Germany Malaysia Singapore


  #5  
Old 05-04-2012, 10:49 AM
TmzHosting TmzHosting is offline
Managed VPS Experts
 
Join Date: Nov 2007
Location: New Jersey, USA
Posts: 3,658
How much are you paying for that VPS now? I would recommend a lower end dedicated server. Disk space and bandwidth is not your bottle neck it's CPU and RAM.

What is your budget?

- Daniel

__________________
Managed & Unmanaged VPS's [OpenVZ & KVM] by tmzVPS.com | Lowest Priced SSD Accelerated VPS Plans in the Industry!
█ Locations in the US (California, Florida) and UK (London, Maidstone). Weekly OFFSITE Backups INCLUDED with all of our plans. 99.9% Network Uptime!
cPanel/WHM | Premium Network | Premium Softaculous and more INCLUDED!
█ DATA Migrations Included | 24/7 Certified Support |INSTANT SETUP | Gigabit Connections


  #6  
Old 05-04-2012, 11:01 AM
Flapadar Flapadar is offline
Web Hosting Master
 
Join Date: Jun 2011
Location: Aberdeen
Posts: 2,410
I would agree with Daniel; the easiest solution would probably be a cheap dedicated server. I would recommend using http://www.hetzner.de/en/hosting/pro...rootserver/ex4

  #7  
Old 05-04-2012, 11:15 AM
ajonate ajonate is offline
Web Hosting Master
 
Join Date: Apr 2011
Location: Las Vegas, NV
Posts: 1,518
Quote:
Originally Posted by ataozcelik View Post
Currently I'm in a VPS server with this spec:

Disk: 75 GB
RAM: 2 GB
OS: CentOS
Traffic: 450 GB
That should be more than enough for your application, as long as the VPS node isn't oversold and you have at least 2 processor cores available. I suggest that you convert the vBulletin storage engine to innodb, since that will be faster and more efficient.

https://www.vbulletin.com/forum/entr...oDB-Conversion

  #8  
Old 05-04-2012, 11:22 AM
ataozcelik ataozcelik is offline
New Member
 
Join Date: May 2012
Posts: 4
Thanks all the answers, VPS is in Turkey and I chose that for low ping reasons, but I can consider other options of course. The price is around 95$ I know it's expensive comparatively but this is the usual Turkish market price.

Quote:
That should be more than enough for your application, as long as the VPS node isn't oversold and you have at least 2 processor cores available. I suggest that you convert the vBulletin storage engine to innodb, since that will be faster and more efficient.
I don't know how many cores they have given to us, but I doubt that we have 2 processor cores, I'll check that. I've checked your innoDB recommendation but our forum server is not under heavy load all the time, actually since it is a soccer related forum it gets peaked after our teams games. Do you still think it will be better to convert it into innoDB?

What about memcache, should I consider it?

  #9  
Old 05-04-2012, 11:32 AM
ajonate ajonate is offline
Web Hosting Master
 
Join Date: Apr 2011
Location: Las Vegas, NV
Posts: 1,518
Quote:
Originally Posted by ataozcelik View Post
I don't know how many cores they have given to us, but I doubt that we have 2 processor cores, I'll check that. I've checked your innoDB recommendation but our forum server is not under heavy load all the time, actually since it is a soccer related forum it gets peaked after our teams games. Do you still think it will be better to convert it into innoDB?

What about memcache, should I consider it?
You are probably okay on processors. I would be surprised if you didn't have at least two cores available with a 2 gb memory account.

I doubt that you'll get much from memcache.

  #10  
Old 05-04-2012, 11:58 AM
jroc jroc is offline
WHT Addict
 
Join Date: Mar 2012
Posts: 162
This could easily be disk io bound - iostat -x would give you insight into this.

For the money you are spending I'd look to a cheap dedicated server or high end VPS (such as linode.com) western Europe. Latency wouldn't be much of a problem, and nothing like as bad as you see now.

  #11  
Old 05-04-2012, 12:00 PM
ajonate ajonate is offline
Web Hosting Master
 
Join Date: Apr 2011
Location: Las Vegas, NV
Posts: 1,518
Quote:
Originally Posted by ataozcelik View Post
I've checked your innoDB recommendation but our forum server is not under heavy load all the time, actually since it is a soccer related forum it gets peaked after our teams games. Do you still think it will be better to convert it into innoDB?
If you are comfortable running without innodb then that's fine, but you should disable it because it uses about 125 mb of memory when it's enabled. Add this to the /etc/my.cnf file.

skip-innodb

After mysqld restart your memory usage will be a lot lower. If you need innodb sometime in the future you can always pull that command out.

  #12  
Old 05-04-2012, 12:04 PM
notinterested notinterested is offline
Web Hosting Master
 
Join Date: Mar 2011
Posts: 622
I wouldn't be so sure CPU is fine. I've seen my share of systems that don't advertise the CPU allotment only to find there was a reason why they didn't wanna talk about it upfront.

Now, I think a VPS is fine but the question is which is the right one. A cheap dedicated can fix the problem easy, but you might run into an oversold or unreliable network, or just one that isn't watched frequently enough to ease your mind about potential downtime. Some of these cheap providers stay up for a long time, but when they go down...boy do they go down.

Perhaps an SSD to run the SQL, a better CPU allotment, and any optimization that helps lighten the load. I'm just beginning to work with them, but 64u.com is proving to have quite the first impression on me...for what it's worth.

__________________
Supposed to say "check the offer forums, get a better host" and flash my signature, right?

  #13  
Old 05-04-2012, 12:56 PM
kpmedia kpmedia is offline
Web Host Reviewer
 
Join Date: Feb 2006
Location: Kepler 62F
Posts: 12,048
VPS is fine, but you really need to add/enable and optimize a ton of cache settings. vBulletin runs like crud at high traffic and no tweaks. The out-of-the-box setup for vB is only fine for small to medium sites. When it gets large, cache or die.

Don't use an OpenVZ VPS here.

You may find that EuroVPS is an excellent fit for location/performance. It costs a little more than the cheapo hosts, but it's definitely worth it. VMPort is another good one, in UK.

__________________
|| Need a good host?
|| See my Suggested Hosts List || New Editorial: HostGator Alternatives & Who is EIG?
||

  #14  
Old 05-04-2012, 12:58 PM
ataozcelik ataozcelik is offline
New Member
 
Join Date: May 2012
Posts: 4
@jarland 64u.com is in Turkey but I've never heard of them? I think they resell servers from other countries Germany/USA.

@jroc this server is brand newly installed so iostat is not installed at all as I'm not so familiar with Linux environment I don't want to mess up very much with the running system. I guess I can use yum to install iostat?

@ajonate I don't think we have innodb running currently. Does it come by default with the vBulletin now?

Perhaps I should post some of the resource log:

Code:
May 04, 2012 07:45:18 PM
 
Resource
 
Resource counter_cpu_share_used red alert on environment vps149364.v.sadecehosting.com current value: 88 soft limit: 85 hard limit: 95

May 04, 2012 07:42:18 PM
 
Resource
 
Resource counter_memory_share_used green alert on environment linvps05.sadecehosting.com current value: 74 soft limit: 85 hard limit: 95
These are one of the typical resource alerts I'm getting.

  #15  
Old 05-04-2012, 01:49 PM
raindog308 raindog308 is offline
Web Hosting Master
 
Join Date: Jul 2010
Posts: 773
Quote:
Originally Posted by ajonate View Post
I suggest that you convert the vBulletin storage engine to innodb, since that will be faster and more efficient.
The chief benefit to innodb is that its locking model is better for high contention situations. So that may help the OP. In terms of "faster" and "efficient" - well, MyISAM is often faster. However if you have a lot of update/delete activity (which is common in high-concurrency forums), then innodb may help and will be faster in those situation.

__________________
My advice and reviews of VPS providers based on my personal experience: VPSadvice.com

Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Windows VPS | Xen VPS | OpenVZ VPS | Starting $9.99/month | 1 gbps uplink|Germany VPS veeble VPS Hosting Offers 1 03-27-2011 02:57 PM
NQhost - Linux VPS, Windows VPS, FreeBSD VPS, Cheap VPS solutions NQhost VPS Hosting Offers 0 10-19-2010 06:47 AM
NQhost - Linux VPS, Windows VPS, FreeBSD VPS, Cheap VPS and new October design NQhost VPS Hosting Offers 2 10-05-2010 10:13 AM
NQhost - Linux VPS, Windows VPS, FreeBSD VPS, Cheap VPS solutions NQhost VPS Hosting Offers 2 09-30-2010 08:39 AM
£0.99 Nano VPS! £1.99 Micro VPS! £6.99 Unmetered VPS! XenVZ VPS Control Panel! ServerSean VPS Hosting Offers 1 09-04-2009 01:54 AM

Related posts from TheWhir.com
Title Type Date Posted


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?