is it possible to have innodb_file_per_table on mutiple filesystem
Posted on 2006-11-07
We are on RH Linux MySQL 5.0.18
With innodb_file_per_table enabled, is there a way to isolate the data files to different filesystem? Right now all the .idb files goes into data directory and we end up having one big filesystem.
I take it symbolic linking doesn't work for innodb?
I can't think of anything better than having mutiple mysqld running to isolate the database and datadirectory. Any better options?