Droplet with large number of sites

Posted September 10, 2015 3.3k views
NginxMySQLPHPServer OptimizationDigitalOceanConfiguration Management

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:

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.

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.

Submit an Answer
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.