title: Innodb; multiple data directories
body: <p>I have a requirement to store two Innodb database files on separate partitions. (one database on raid0 for speed, the other on raid1 for stability)</p>
  
  <p>From what I've read, the only way to accomplish this is by using <code>innodb_file_per_table</code> and symlinking .ibd and .frm files wherever-they-may-live to the configured mysql storage directory (/var/lib/mysql on my system), where the ibdata1 file must live (for table metadata).</p>
  
  <p>Is this the only way to accomplish the split?</p>
  
  <p>Is there an innodb analog to myisam's TABLE/INDEX DIRECTORY?</p>