Related

Product Now Available: Managed MySQL Databases Product
Why are snapshots so slow Question Question
Connect to DB installed into dedicated VPS (private networking) Question Question

Question

Can I increase the size of the root disk on a droplet without increasing the ram or the cpu?

Posted July 3, 2018 2k views
MySQLDigitalOceanDeployment

I want to setup a mysql server that stores a lot of of data but will be rarely hit and even then with internal services. With that goal in mind I want to create a droplet with 8GB ram but 500GB HDD. Is there a way I can do this?

Add a comment
jeet1985
By:
jeet1985
Add a comment

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.

×
2 answers
SphericalCow July 5, 2018

I think here that your best bet is to use block storage volumes, equivalent to the Amazon EBS volumes if you have used those before. So, you may have the fixed root drive, but you can attach on the secondary 500GB block storage volume as a data partition. You should be able to specify the datadir in the /etc/my.cnf configuration file to point to a mount of the secondary 500GB block storage volume.

Reply Report
WayneSallee August 23, 2018

And you can create symlinks to other folders on the second drive, wherever you want to make it seamless.

ln -s /folderOnMainDrive/folder /mountedDrive/folder/folder

I have my website on a second drive, and while my system is set up to pull website files from the main drive, they are actually symlinks that point to the second drive.

To add another drive:
Click on “volumes”, then click on “add volume”

Wayne Sallee
Wayne@WayneSallee.com

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help