New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Should i go with VPS or Dedi Server?
I have wordpress site, which has regular of 130-150(Yes i mean 24/7) people online. Even more in weekends.
my VPS details (Running):
- OpenVZ
- 4GB Ram
- 120 HDD
- 5TB BW
- Nginx
- Varnish Cache
- Even CDN is implemented on top
my problems on this server.
- Needed more than 0.5 TB HDD/SSD, but they only offers 120 (highest config) per client.
- And of course needed more BW that 5TB
- Datacenter isn't inside us. So DC needed somewhere in west-coast
- 70% traffics from USA, So server takes lots of time to load, even tho i have CDN.
So, now should i go with Dedi server? OR should i stick with good/stable VPS ?
btw my budget is around 120-150$ including plesk/cpanel + Managed.
Any Suggestion? any recommended stable/affordable dedi or VPS?
Comments
A cpanel license for a dedicated server costs somewhere around 30-35 usd/month.
It eats a pretty large chunk of your budget and when asking for managed aswell. Doesn't leave much room for the actual server.
If you really need a dedicated server for this site and aomeone to manage the server, cPanel could perhaps be removed from the equation and tje dollars saved could be out towards hardware and management.
From your description I suspect that the waiting time is from fetching data inside the mysql database.
Perhaps start with running mysqltuner and follow the recommendations?
yes you are right ! its huge DB.
Never knew about this before, any step guide links ?
Thank you so much @MikHo
Interpreting the results is a different matter :-)
If raindog308 wasn't clear enough, http://www.lowendguide.com/3/database/mysqltuner-suggestions-for-optimizing-your-mysql-installation/
Copy the results to a pastebin like http://noted.pw/ and we can look at it.
Perhaps even give a few pointers.
Hi @MikHo @raindog308 here is my results
http://pastebin.com/BvHMbXB9
Please advice !
get more ram. your mysql use 3.7G (93% of installed RAM)
and
add those values to your /etc/my.cnf
lower threads from 500 to 200 as you used max 108
And put at least 64M for the parameters namhuy told you
Run optimize table too
I believe you have bad config there, 4GB of RAM should can handle 2000+ online user as long as they are not login.
Even with 150 people online at any given time; you're only dealing with SQL & HTTP requests (amongst other minor things) - this cannot use 5TB, or even anywhere near 1TB a month unless your setup is seriously configured wrong, taking into consideration you even have a CDN somewhere in your setup.
Also do you really need cPanel? Can you not use a free panel like Kloxo - it's the same thing just a free version. A cPanel license will run you at least $30/m which eats into your budget.
Furthermore, you're utilizing Varnish & Nginx, which is great: but have you looked into adding gzip compression for your requests? It'll cause a higher CPU load, but will speed up requests to your user base.
I'd recommend http://www.supremebytes.com/dedicated-servers.php - $80/m for : Xeon E3-1230 , 16Gb RAM , 1x 1TB WD Black 7400RPM & 5TB bandwidth + still leaves you a gap for purchasing that cPanel license if you choose not to go with Kloxo.
he needs 500GB of storage, I assume he's hosting files to download
@isansar what about Dual X5150, 16GB RAM (great for caching that MySQL), 500GB disk - $20/month (paid quarterly) or $30/month (paid month-to-month). Gigabit port.
@MarkTurner
There is no need for a dedicated, tweaking and fixing the settings of his mysql and other services.
Basicly what happens is that MySQL reserves to much memory causes it to swap to disk whenever varnish is "working" or a file (image or whatever) is requested.
This makes everything slow.
If the mysqltuner output is true
Having mysql use 3, almost 4 GB is overkill.
Fix the issues according to mysqltuner and limit the memory usage of mysql and I'm sure you will se an improvment.
Older version of wordpress? Newer versions use InnoDB but it seems the majority of your data is MyISAM. On InnoDB implementations If you're purely serving WP sites then try bumping up the innodb_buffer_pool_size to over 1G. This allows MySQL to cache the most frequently accessed records (index keys moreso) into memory, but due to block sizes some data gets cached into memory too. Since you're using MyISAM you'd want to increase the key_buffer_size to a much higher value. Basically with low values you're thrashing the disk when you have lots of memory that should primarily be used to hold the data you're going to process/send over the network.
My understanding of WP is that it's almost entirely database driven so if you're looking to increase performance then that's what to look at. The OS will cache all those WP php files just fine.
mysqlreport is good for digging deeper. http://hackmysql.com/mysqlreport
For bandwidth, check that any versions of jquery or the like are fetched from google instead of your own servers. Not only will it save you bandwidth, it's far more likely to already be cached by the client.
In regards to the original question, go unmanaged/dedicated if you're comfortable with that. VPS are overpriced towards this scale.
Hmmm... that's what i'm thinking.
Yes, you are right. It's education based wordpress and i do need lots of space or pdf and podcast for every lesson.
I would love to know about.
@isansar - here's the offer (but that coupon expires in a few hours):