Question
What setup do you recommend for future scaling
- Posted on November 25, 2019
- Server Optimization
Asked by bestschoolsmx
Right now I’m a running single droplet : 4 vCPUs 8GB / 20GB Disk
It still feels like it’s struggling so I want to scale horizontally but also keep costs roughly around 60 a month.
But which setup is a good starter setup I can build on?
Here are my 2 noob options:
Option 1
droplet(lamp) V
droplet(mysql droplet(redis cache)
Option 2
Load balancer V droplet(lamp) droplet(lamp) V droplet(mysql and redis)
My biggest problem with single droplet was MySQL swapping. The server has a set amount of users it won’t grow much, like around 3000 max.
Does anyone have a similar setup ??
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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.
Want to learn more? Join the DigitalOcean Community!
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
Hi @bestschoolsmx
The setup really depends on your application.
If you have a lot of images you serve on your website, and the application is quite heavy as a whole, I mean like 10 MB of front page when loading, then I’ll recommend using one Apache/Nginx droplet with HaProxy for serving static files alongside maybe Redis and one tiny MySQL droplet.
If you however have an application which makes a lot of DB queries on every click, like big inner join queries from multiple tables, then I’ll recommend getting a bigger MySQL droplet to handle those as opposed to just one Apache/Nginx droplet.
It really depends on your application, you would know which is the heaviest part of it. Act upon that information and create the droplets based on your needs.
Hope, I’ve helped a bit on the issue!
Regards, KDSys