How can i change the default psa db server for an high availability system

[BenjaminA]

Hello,

I would like to make an high availability system for my website. I actually have 4 servers and a Loadbalancer system:
- 1 MySQL server
- 1 NAS server
- 2 Plesk servers
- My loadbalancer

On my two Plesk servers, the /var/www/vhosts directory are mounted with NFS from the NAS server, so my website is sync on the two servers. The loadbalancer give a Loadbalancing IP to my Plesk servers and automatically disable the access to a down server.

How can I change the default psa database server (to have the same MySQL server for my two Plesk servers)? Or how can I sync the two psa databases?

Are there others directories to sync than /var/www/vhosts ?

Thanks

Have a nice day

 

[Andrey Kucherov]

Hello,

You can use the following article in order to find out what configuration options are available for the Parallels Plesk Panel (PPP):

http://kb.odin.com/en/952

As you can see it is not supported to migrate the psa database.
However you can probably try to mount the /var/lib/mysql from your MySQL server to the /var/lib/mysql on your PPP servers. (you will need to dump the psa database on one of your servers before this and move it to the new MySQL server).

Please let us know if you will find the solution to this task.