Question

Droplet plan advise for my firm

Posted April 21, 2015 1.6k views
UbuntuDigitalOceanBillingMonitoringBackups

I would like for you to advice me on which of your plans to go if i need to keep a medical record of about 200 million people.

1 comment
  • Well this question will have no correct answer and without seeing the database and how much space is require, it is literally not possible to give an accurate answer.

    I maintain a database with less than 10 million records on the cheapest droplet, but I could see how a medical record database would use much more disk space than what I do.

    Is there any way to can tell us the disk size of the database?
    This is really the only limiting factor.

    Also consider how much of that data is IN-USE on a daily basis. InnoDB likes to have lots of memory to lower the Disk I/O. Droplets currently do not have a way to extend the RAM, so take that into consideration as well.

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.

×
1 answer

This question was answered by @geggleton:

Well this question will have no correct answer and without seeing the database and how much space is require, it is literally not possible to give an accurate answer.

I maintain a database with less than 10 million records on the cheapest droplet, but I could see how a medical record database would use much more disk space than what I do.

Is there any way to can tell us the disk size of the database?
This is really the only limiting factor.

Also consider how much of that data is IN-USE on a daily basis. InnoDB likes to have lots of memory to lower the Disk I/O. Droplets currently do not have a way to extend the RAM, so take that into consideration as well.

View the original comment

Submit an Answer