Droplet with large number of sites

September 10, 2015 1.3k views
Server Optimization DigitalOcean Nginx Configuration Management MySQL PHP

I'm currently building a system where the entire functionality is stored in one, core system and clients hosted on the same droplet simply symlink to index.php and only really have media directory with each client for their own media.

Now - I'm trying to figure out whether it will work with say 500 / 1000 sites - each one will have its own dedicated database, plus access to the core database for common features.

Could anyone give me some advice on what / how should I configure droplet as?

I believe nginx sockets might cause a problem (which I have already had a chance to experience) and I'll probably have to use TCP - I've followed these instructions earlier today: https://rtcamp.com/tutorials/php/fpm-sysctl-tweaking/

Now - would the database also need to be set up to use TCP?

In general - do you think that single (large) droplet would be capable of handling this sort of system? I understand that it depends on many factors like traffic to those sites etc. but some advice on how to handle this would be very much appreciated.

1 Answer

You can definitely run 500 PHP/MySQL apps using FPM on a single server. However, depending on various server configurations, when you get up around there you may need to start tweaking open file limits for various processes such as PHP and MySQL. If you can't risk running into that in production, your best bet is to test your config on a dev server by creating and making requests to large numbers of separate apps (500, 1000, 1500, etc.) until you see what breaks, then you can start tweaking settings so that service doesn't break at that point and continue testing until something else breaks. That way, you'll have a good idea (though not perfect) of what your server configuration can handle in production and also what the failure modes are.

  • Thanks @jsamuel - I'll do exactly that when we hit larger number of sites. At the moment everything works fine, but plan is to get more on :)

Have another answer? Share your knowledge.