Is it possible to separate out data files and log files of MySQL from one drive to another?
For eg:
Data (actual database data and system tablespace ibdata) in one partition, say /data and log files (ibdata0 and ibdata1 only) in one partition, say /redo?
Is it possible? I know the binary logs can be moved to a different partition but I have the doubt for above scenario.
I'm using Percona Server 5.6 on linux.
Edit:
Just checked out, If I set innodb_log_group_home_dir to a different location, would it work?