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?
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.
×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.
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.
Question
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)