hello, i'm new to VPS management, so i'm hard to decide.
I 'll buy a VPS on DigitalOcean, just 512 MB RAM.
I'use VPS for my website. My website is a video website.
My website just one-page. Because All Request is AJAX, load video link from database. Therefore, all Request is process PHP file.
It will have about 30- 50.000 view/month,and 100-200 symulta
I'm hard to decide for performance, Nginx? Apache? Lighttpd?
So i need help from you, what web server for me? and why
Because nginx is asynchronous threaded in nature and consume very less memory and cpu compared to Apache. PHP-FPM is daemonized and is known to be the best handler for high performance. Both of these together is on the best combination for high traffic PHP website. But even with that, I doubt your VPS can handle 100-200 simultaneous users. In addition to web side, MySQL also needs some resource ( as per your explanation, each requests need MySQL query ). So you may need a VPS with higher resources.
100-200 simu streams is pushing it on a droplet. Double check your assumptions.
That aside, nginx doesn't have worker processes to block. Hence it can process new incoming request when apache otherwise would be preoccupied with already connected users. Best practice is to split the link server from the content streamers, that way you can spin up as many content servers as required. In that scenario, either apache or nginx is good enough.