Related

Can't install php-soap to my PHP 7.0 centos Question Question
cpu from 13% to 100% in one minute Question Question

Question

What size of droplet do you recommend?

Posted July 13, 2015 16.8k views
UbuntuPHPServer OptimizationGetting StartedScaling

I want to create a new droplet, but im not sure what kind of size i will need, i want to use it for a php site + mysql for about 10000 users, or maybe more in the future. Can you give me some suggestions?

Add a comment
Laucian
By:
Laucian
Add a comment
1 comment
  • retran July 13, 2015
    Reply Report

    For a serious site (one want to work reliably, and respond to changes) you should dedicate a droplet to run your mysql server, and a separate droplet for your php+http server (apache or nginx).

    On your mysql VPS, for mysql to work “well” (without weird crashes) you need about 2GB Ram, and multiple CPU’s are ideal anyway. That corresponds to the $20/m droplet.

    For the php/web server droplet, you may be able to achieve good enough performance with a 512MB ($5/m droplet) if you run nginx+fpm. If you run apache, you should start at the 1GB/$10/m droplet… but you may need a 2+ core system (the ones starting at $20/m) to get decent results for non-trivial PHP based site under any kind of load (on apache).

    My recommended starting configuration (without getting into replication, which you should consider if your data is important):
    $10/m Droplet running Ubuntu 14 LTS + php5.5 + nginx - fpm
    $20/m Droplet running Ubuntu 14 LTS + mariadb-server (or mysql-server)

    Remember, most of the DigitalOcean tutorials assume you run mysql on the same droplet as your web server. Those are ok to use, just SKIP the mysql part.

    To configure Ubuntu 14 LTS + php5.5 + nginx - fpm: (SKIP the mysql section)
    https://www.digitalocean.com/community/tutorials/how-to-install-linux-nginx-mysql-php-lemp-stack-on-ubuntu-12-04

    To configure Ubuntu 14 LTS + mariadb-server (mariadb is my preferred fork of MySQL)

    1. create new droplet with Ubuntu 14 LTS
    2. from command line: apt-get install mariadb-server
    How To Install Linux, nginx, MySQL, PHP (LEMP) stack on Ubuntu 12.04
    by Etel Sverdlov
    LEMP stack is a group of open source software to get web servers up and running. The acronym stands for Linux, nginx (pronounced Engine x), MySQL, and PHP. This tutorial explains how to install the required repos to download nginx and php-fpm, how to install MySQL, how to install nginx, how to install php-fpm, how to configure php and nginx, and how to create a php info page. This tutorial is written for Ubuntu 12.04.

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
2 answers
jonaharagon July 17, 2015

It really depends on what you’re doing with it. In my case, I would start with a $5 Droplet, and if it gets overloaded upgrade it to a $10, and so on. DigitalOcean makes upgrading super easy to do, so I would just take advantage of that and upgrade accordingly.

Reply Report
ForYourIT July 13, 2015

Depends, its pretty hard to say. Its something like “how much potatoes can you fit in this box?” If you are running php scripts with a high load of your server, and getting alot of mysql queries at a moment you will need more resources.

And what do you mean with users? The amount of people visiting your site a day, a week?

But you could start with a $20/month droplet, check how much resources you are using with this website and “calculate” how much more you need or if this is allright. With a DO droplet you will always have the flexibility to upgrade your droplet to a higher plan without any risks.

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help