0

related to the problem I faced here No space left on device, I want to adopt a long term solution about the point no space left on device. One of the action includes to add a volume to the machine in which the database runs (MySQL 8, Ubuntu 20.04 and Digital Ocean provider).

I would like to know which one is safest way and rules to follow in order to avoid loosing reference and/or data when I will add a volume on the machine. Considering that this database is running in production without any replication.

Thank you in advance for the support

1
  • Start by asking the cloud provided to give you a bigger machine. Then we can discuss shrinking your data and maybe downsizing again.
    – Rick James
    Apr 15, 2021 at 16:18

1 Answer 1

0

I followed this guide, very useful and complete

https://www.digitalocean.com/community/tutorials/how-to-move-a-mysql-data-directory-to-a-new-location-on-ubuntu-16-04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.