What is the right plan?

Posted August 1, 2013 3.3k views
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.

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
5 answers
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.
Thanks for your reply.
No, not right away I am going to get the traffic. but may be in 20-25 days. So what do you suggest the right plan to start with @Pablo of vDevices.
I'd suggest starting off with a plan with more than one CPU core as Pablo suggested, and scaling up as needed.
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?
Yes, you can resize your droplet any time you want.