multiple file systems for mysql
- by RainDoctor
Does mysql support multiple file systems for a single database with most of the tables being on MyISAM?
Context: we have a 1.5TB mysql database, which is increasing at the rate of 200GB per month. The storage is directly attached, whose slots are almost full. I can add another DAS, and increase the file system. But resizing volume, resizing file system, etc are getting messy. Is there a concept of "tablespace, datafile" (like in oracle) in MySql world?
Or how you guys manage mysql db with these kind of constraints?