Question Move / Install Database on different Disk / Partition

[maxx]

Hello

is there any way to create a databse server from inside plesk on different vdisk? For example if plesk is installed on hdd and i want to add another database server on a new vdisk which is fast due to ssd storage?

The lastest docu does not show that this is possible in the meanwhile. For windows there is a solution already: How to change default MySQL directory %plesk_dir%\Databases\MySQL\data to another one?

 

[maxx]

Or is it the best to simply move the data to the new partition ?
Does it need more then that?

systemctl stop mysqld
rsync -av /var/lib/mysql/ /ssd/mysql/
mv /var/lib/mysql /var/lib/mysql_backup

Open /etc/my.cnf
datadir=/home/mysql
socket=/home/mysql/server.sock

systemctl start mysqld

 

[IgorG]

As a possible solution, you can just consider mounting a partition from SSD disk to the default MySQL data directory location /var/lib/mysql/

 

[maxx]

Hi Igor,

thank you for your fast feeback.
But the solution above might be also fine, or does it not suit Plesk best practice? Is there any KB for best practice?

 

[jtp]

Greetings, I know I'm late to this party, but setup separate disks for each Web, Mail and Database. I mount the disks in the respective default directory. I feel like this allows me to have what I want (separate, and sometimes large, disks for my user data) while not risking issues arising from custom configurations.