MYSQL5.5指定表独立路径

由于MYSQL 5.6版本前不支持直接指定路径
设置innodb_file_per_table以及软链接到不同磁盘，实现表分不同磁盘（假设/data/与/var/lib/mysql 是不同磁盘的挂载点 ）
mysql>  select version();
+------------+
| version()  |
+------------+
| 5.5.41-log |

vi /etc/my.cnf
innodb_file_per_table=1
/etc/init.d/mysql stop
/etc/init.d/mysql start
mysql
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 3
Server version: 5.5.41-log MySQL Community Server (GPL)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

mysql> use zssdb
create table test_table (a varchar(10)) ENGINE=innodb;

ls -lrt /var/lib/mysql/zssdb
-rw-rw----. 1 mysql mysql    65 Jan 17 10:57 db.opt
-rw-rw----. 1 mysql mysql  8560 Jan 17 11:02 test.frm
-rw-rw----  1 mysql mysql  8554 Jan 21 10:40 test_table.frm
-rw-rw----  1 mysql mysql 98304 Jan 21 10:40 test_table.ibd

mkdir /data/
mv /var/lib/mysql/zssdb/test* /data/
chown  mysql:mysql -R /data/
ln -s /data/test.frm /var/lib/mysql/zssdb/test.frm
ln -s /data/test_table.frm /var/lib/mysql/zssdb/test_table.frm
ln -s /data/test_table.ibd /var/lib/mysql/zssdb/test_table.ibd
chown mysql:mysql -R /var/lib/mysql/zssdb/test*

[root@M1 zssdb]# ls -lrt /var/lib/mysql/zssdb/
total 4
-rw-rw----. 1 mysql mysql 65 Jan 17 10:57 db.opt
lrwxrwxrwx  1 mysql mysql 14 Jan 21 10:48 test.frm -> /data/test.frm
lrwxrwxrwx  1 mysql mysql 20 Jan 21 10:48 test_table.frm -> /data/test_table.frm
lrwxrwxrwx  1 mysql mysql 20 Jan 21 10:48 test_table.ibd -> /data/test_table.ibd

mysql> use zssdb
mysql> insert into test_table values('ab'),('cd');
mysql> select * from test_table;
+------+
| a    |
+------+
| ab   |
| cd   |
+------+
2 rows in set (0.00 sec)