Distribute MySQL storage by function

Programming
,
1

Is there any way to specify this?

Is there a way to have MySQL store data belonging to a specific account at a different place than the default location?

I’m looking for a way to have MySQL store data belonging to a certain account (e.g., a particular app, or a particular corporate program) at a specific place in the filesystem (such as a particular drive or RAID) instead of bundling it inside the same physical file structure shared by all other accounts, tables, and data elements managed by MySQL.

I’m aware that it is possible to change the default location of the entire data bundle, but I’m wondering if there is a way to specify this on a function level, for “some data but not all data.”

mysql>
2

No, there is no way to specify this on a function level. MySQL stores data in a specific file structure and cannot separate data for specific accounts or functions into different physical locations. The only way to change the default location of the data bundle is to modify the MySQL configuration file.