Best practise for attached volume to self managed MYSQL DB instance

Although we do not have a guide available on how to set up your Block Storage volume to attach to a self managed DB instance, we do have a couple of Community posts where customers have asked similar questions. In the following post that I referenced, this customer was looking to provide additional storage to their /home directory using Block Storage. It was mentioned in order to give /home directory more space on the Volume, you will need to move all of your existing content onto it. I recommend reviewing this information a bit further to get a better idea if this situation applies to you:

• How to give more storage to /home directory with block storage? (21407) | Linode Questions

MYSQL will auto write to this secondary disk after primary disk (instance SSD) is full

There should be a line in your database's configuration to set the directory it uses. Here's some information on setting the MySQL data directory, as an example:

• How to change MySQL data directory? - Stack Overflow

Additionally, one of my colleague's wrote a detailed post on how you can move your database files to a Block Storage Volume and what to consider.

• How do I move my database files to a Block Storage Volume? (18893) | Linode Questions

You may also want to look over our Block Storage product guide to get a better idea on how it works and how to properly attach it:

• Attach and Detach a Volume | Linode Docs
• Configure and Mount a Volume | Linode Docs

Before proceeding with any of this information, I recommend taking a Backup of your Linode in case anything should go amiss:

• Backups - Guides(our paid backup service)
• Backing Up Your Data
• Copy a Disk Over SSH
• Back Up A Block Storage Volume.