Issue Plesk with Additional Data Disk to MySQL and Applications (Environment Down)

[gutohmm]

Hi Guys, Good Afternoon!

I've been trying to configure my Plesk to work with a separated disk to MySQL Databases and Apache Applications (vhosts).

But, every time that I try to do this by myself, I'm facing different errors.

There's some way or documentation that provide us with a CLEAR and STRUCTURED VISION about how to do this?

Example:

• Disk 1: Plesk Installation
• Disk 2: MySQL Databases
• Disk 3: Websites

Thanks,
Gustavo Magella

 

[Monty]

Before you install Plesk and MySQL, simply mount your MySQL disk to /var/lib/mysql and your websites disk to /var/www/vhosts and then install Plesk + all required components.

 

[gutohmm]

Before you install Plesk and MySQL, simply mount your MySQL disk to /var/lib/mysql and your websites disk to /var/www/vhosts and then install Plesk + all required components.

Thanks for your prompt response Monty! But, in my case, I'm using an Azure Image, Pre-Configured.
There's another way?
Cheers!

 

[Monty]

Well, I don't know the Azure Image, but the general procedure would be the same as for any other server:

1. Stop all services except SSH on your server
2. Mount your MySQL disk to a temporary mountpoint, example /mnt
3. Copy all your data from /var/lib/mysql to /mnt (make sure to preserve all ownership information + attributes)
4. Rename /var/lib/mysql to /var/lib/mysql.old
5. Umount /mnt and mount it to /var/lib/mysql

Then do the same for /var/www/vhosts and update your /etc/fstab and restart your services.

 

[Monty]

Of course you could also change the "MYSQL_*" and "HTTPD_VHOSTS_D" variables in /etc/psa/psa.conf and copy your data to that new location.
There are some threads regarding this:

Question - How to change the MySQL and web directory in Plesk for Linux??

how to change the MySQL and web directory in Plesk for Linux? My idea is to have the database on one disk and the Web on another, I have already changed the mail directory, setting in the file /etc/psa/psa.conf. Disk1 = SO Done Disk2 = Database Disk3 = Web Disk4 = Mail Done

talk.plesk.com

Question - MariaDB change data directory location

Hi, I'm trying to change the MariaDB data directory from /var/lib/mysql to /my_folder/mysql. Everything is good I can log into mysql in command line but plesk give me a hard time with Zend Errors. I've change my /etc/my.cnf and my /etc/psa/psa.conf to match with the new mysql location but...

talk.plesk.com

 How to change virtual hosts location in Plesk for Linux?

Applicable to: Plesk for Linux Question How to change virtual hosts locations in Plesk for Linux? How to replicate website vhost and root document path during migration from a non-Plesk server? ...

support.plesk.com

But I prefer to keep default values whenever possible and just create my disk layout as required.