By hypertextsol
I want to host a website, which will be having 5000+ mysql connections at a time, with a similar no of users. But what should be the perfect plan on DO (memory + cpu cores) to handle this kind of traffic. I don’t know how to look for the resources being used and how to increase the simultaneous connection on mysql and apache.
Any pointers how to start with the above configuratios would be helpful.
Thanks.
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.
Thanks @kamal . Just 1 more question … Can I start with 512 mb one core, and then gradually increase it two 2 core. Is it possible, if yes would there be some problem while scaling?
Are you going to have 5,000+ connections/users right away or are you going to gradually build up to that? I’d start with at least 2 CPU cores + 4GB of RAM – given that you can scale (up) rather easily.
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
Full documentation for every DigitalOcean product.
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
Scale up as you grow — whether you're running one virtual machine or ten thousand.

From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.
