Related

Product Now Available: Managed MySQL Databases Product
Install MySQL on New Droplet Question Question
How can I solve error "SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)" Question Question

Question

Which specifications do i need?

Posted October 29, 2016 3.9k views
MySQL

We are gonna have an application process for an event. We took 900+ application in 30 minutes last year. But because of shared hosting plan, so many people had difficulties to be able submit form even seeing form. Which plan should we get to serve better ? We are using mysql database and getting information with 4 mysql query.

Thanks

Add a comment
memingure
By:
memingure

Related

Product Now Available: Managed MySQL Databases Product
Install MySQL on New Droplet Question Question
How can I solve error "SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)" Question Question

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.

×
4 answers
xMudrii October 29, 2016

Well I would say that minimum is $10 Droplet. It gives you 1 GB RAM which is recommended for MySQL to run.
$5 Droplet is small for your needs, as it gives 512 MB RAM. With that memory size and number of visitors your server would go down very easy.
If price is important point, you can go with $10 and install swap to make sure it’s enough.
In case this is not problem and you want to be sure it works flawless, you can go with $20 Droplet as it ships with 2 GB RAM.

I think most important point is RAM usage if queries are not complex. In that case number of CPU is not that important and one CPU would finish work without problems.

Reply Report
newbie October 29, 2016

if the server will be available only for 1 day or couple of days you can take 10$ or 20$ plan as xMudrii said.

if you plan to have a server permanently and need higher resources only for a certain time, start with 5$ plan with 1gb swap and on the day of submission, do flexible resize to 20$ plan. only for few hours or a day it wouldn’t cost you much. when the submission is over, resize back to 5$ plan.

Reply Report
memingure October 30, 2016

Is it possible that i resize my 5$ plan to 640$ plan for 12 hours immediately? Do i need to move the server or will it be resized just in seconds?

Reply Report
  • xMudrii October 30, 2016

    Yes, it is possible that you resize $5 plan to $640 plan. Please note that resizing Droplet requires you to power off Droplet before doing so. The process of resize should not take long.

    There are two types of Resize. You have CPU and RAM only and Disk, CPU and RAM.
    CPU and RAM only is reversible Resize - you will have option to resize to lower Droplet.
    Disk, CPU and RAM is permanent resize. Once you resize with this option, you will never again be able to lower it (e.g. from $10 to $5). With this, you would be able to upgrade it but not to downgrade anymore.
    This is because if you downsize disk, there can be data loss.

    There is tutorial - How To Resize Your Droplets on DigitalOcean which will explain you difference between resize options and what you need to know about it.

    Reply Report
memingure October 30, 2016

How much time does the resizing from 5$ plan to 640$ plan, CPU and RAM only, take?

Reply Report
  • xMudrii October 30, 2016

    This is something I don’t know and you should contact support for it.
    In article I linked there is Estimated downtime section saying:

    The estimated maximum downtime window for the resize process for a Droplet is: up to one minute per GB of used storage. For example, if your Droplet is using 20GB storage, the entire resize should take less than 20 minutes after it is initiated. The actual time of the process is typically very quick.

    But as you don’t change size of disk I’m not sure is this relevant. Anyways in my experience, I done “small” resizes, e.g. $5 -> $20 and it was pretty quick (less than minute for me).
    I can’t try it for you because it’s locked for me.
    When I already said locked, keep in mind, if you use PayPal you need to do some payment in advanced to unlock all sizes.
    For example, I done $5 payment and can create up to maximum $20 Droplet. For more than it I need to do more payment.
    This is not a problem if you are using credit card (I think). For more information about that, you can ask support.

    Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help