Hi I just wonder,

Lets say my the mysql data in one of my harddisk has reach their limit.
How do I suppose to add another storage and let the mysql write to new added data on the second storage

Because If I change the old mysql storage with new storage ( still same table structure ) I won't be able to query my old data.