How to split MySQL/MariaDB datadir to multiple mount points
If you are going to be using InnoDB tables and if you plan to have innodb_file_per_table enabled, then your best option would probably be to use the CREATE TABLE statement’s “DATA DIRECTORY” option, so that you can place a table outside the data directory. From the MySQL documentation: DATA DIRECTORY, INDEX DIRECTORY For InnoDB, the…