Is it possible to store mysql database on two different disks?

Question

linux

Good afternoon.
There is a server, a large (almost 150 gigabytes) database is spinning on it. It is slowly growing, and will soon completely clog the disc. Unfortunately, 150 gigabytes is the limit for a hoster, it does not provide larger disks (but you can take a second one of the same size).
Therefore, it became necessary to split this database into two disks.
How can this be done?
Is a simple ln -s enough for the largest files?

Answer 1

You can read this: https://dev.mysql.com/doc/refman/5.7/en/general-ta... create a tablespace on different disks and group tables by them so as to evenly use disk space and performance.

Answer 2

you can assemble disks in lvm and cut volumes of the desired size

Answer 3

It is possible to create btrfs on top of both drives.

Answer 4

ln -s on large tables will be enough.
The main thing is that the disk is mounted before the muscle starts