Question

Database Size and Blockstorage

Hi

I have an old ubuntu 16 simple 5$ droplet. Mysql was installed. But it is full now -> 19GB. So I create a new 18 ubuntu server and 100gb blockstage. Blockstroge is in /mnt.

When I install mysql, it goes to install in root path so the database size is limited 20GB again.how can I use blockstorage for mysql.

thanks

Subscribe
Share

Submit an 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.

you can mount the block storage under the default data location, /var/lib/mysql.

Steps would roughly be;

  1. shutdown mysql
  2. unmount /mnt
  3. mount block storage volume in /var/lib/mysql location
  4. start mysql

HTH,

Andrew