Choosing between which HTTP, DB, Optimization tools on a VPS server [closed]

I am finally moving from a Shared hosting to a VPS hosting on Digital Ocean.

Since now I have control of what I can install, I would like to know which of these are preferred to install.

Web Server

Apache or NGinx?

I learn that nginx is faster than Apache but Apache has most support. I am not really familiar with both of them. I just want to know which one is better to use, which one is more stable?

Database

MySQL or MariaDB?

I am familiar with MySQL, I just learn that MariaDB is faster, but I am not sure if it’s ready for production

Optimization

APC + (memcached || redis)?

APC is the only one i know, any better alternative? as of Memcache and redis, I am not familiar with any of them and they are the only one I know.

Thank you

Answer

Are you Facebook? Are you Twitter? If the answer to both of those question is “no”, then stop worrying about what is “faster”. Premature optimisation is a bad trap to fall into.

I see too damn many people making choices based around raw speed and benchmarks. This is a bad idea. You should choose the platform based on:

  1. What you know best
  2. What is most supported
  3. What is most mature

(in that order, usually, but not always).

Make your pick between Apache and NGinx. Apache is more common, but both are fine.

MySQL or MariaDB? Never heard of MariaDB so that probably fails #2 and #3 and you already state that you know MySQL. So clear winner there.

Memcached/Redis? Both are popular. Both are good. Flip a coin. Decide if you even need it based on the volume of traffic you expect – perhaps just a normal database will do fine.

Basically – get a production ready, stable product out there before you start fretting over things like this.

Attribution
Source : Link , Question Author : Timmy , Answer Author : Mark Henderson

Leave a Comment