CODEWITHSUNDEEP
mysql
Federico Giorgi
Federico Giorgi

Reputation: 10755

MySQL custom storage path

I'm working on a server with almost no free space on it, so I attached a NFS volume to it. Now I would like MySQL to be storing tables or, even better, entire databases on the shared volume. Is there a way to do this?

Thanks a lot!

Upvotes: 2

Views: 322

Answers (1)

Pablo Santa Cruz
Pablo Santa Cruz

Reputation: 181430

I don't think that is a good idea. You will have performance and consistency issues if storage is on NFS. Consider adding a secondary local disk, mounting it, and hosting your database files in it.

Having said that, you could change database location in MySQL. It's pretty simple. Have a look at this web entry. MySQL is pretty flexible with this kind of things.

Upvotes: 1

Related Questions