Does MariaDB support multiple data directories within a single instance?
MySQL 5.6 lets you define separate data directories for individual tables. This is useful if you want to put large tables on a separate storage backend - e.g. frequently used tables go on local disk, and some larger tables go on ISCSI.
Does MariaDB support having multiple data directories within a single running instance?
Answer
In 5.5 you can do it manually with symlinks.
Copy ibd files or whole database directories where you want them and symlink them back. You need to use --innodb-file-per-table, of course.
Innodb pseudo-symlinks via "isl" files are only supported in 5.6.
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
