Can I store my mysql database on two different disks?


Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/public_html/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
31 views
Good afternoon.

There is a server, it revolves a large (almost 150 gigabytes) of the database. She is slowly growing and will soon completely clog the drive. Unfortunately, the 150 gigabytes limit for the host, the larger disks it does not (but you can take a second).

Therefore, it became necessary to split the base in two.
How can I do this?

A simple ln-s on large files enough?
by | 31 views

4 Answers

0 like 0 dislike
You can read it here: https://dev.mysql.com/doc/refman/5.7/en/general-ta... to create a tablespace on different drives and simply access them on the table so as to evenly use the space and performance of disks.
by
0 like 0 dislike
you can collect the discs in lvm and cut into desired size volume
by
0 like 0 dislike
You can create btrfs on top of both discs.
by
0 like 0 dislike
ln-s on a large table will suffice

The main thing that the drive was mounted before startanet of muscul
by

Related questions

0 like 0 dislike
1 answer
0 like 0 dislike
1 answer
0 like 0 dislike
2 answers
0 like 0 dislike
2 answers
110,608 questions
257,187 answers
0 comments
40,472 users