Facebook
Twitter
K
KudosDesigns
Guest
Hi,
I am trying to setup HA on Plesk as suggested by Atomic.
I have implemented an HA MySQL cluster and NFS DRDB redundant storage to share the /var/www/httpd and /var/qmail/mailnames across a secure storage array. I am planning to implement Plesk on two boxes, and have them share the same psa database and same secure storage.
Has anyone got MySQL 4.1 working on an external cluster using sql relay as Atomic suggested or otherwise? SQL relay should do it ... but i am having grief getting it to work correctly. It seems to work with individual databases, but not on any arbitrary database.
An ideal solution would be to get the MySQL client to proxy to my cluster if anyone knows how to do this with MySQL so it can make calls transparently to localhost that actually get forwarded onto the cluster.
Beyond this, my next question would be how to overcome the httpd.conf include files for each domain. These would obviously be pointing to the IP of the first server, but would have to be configured for the second server as well. Has anyone got any ideas of how to implement failover with Apache and Plesk?
Thanks everyone!
When i get this all up and running, i will be posting a huge How To on the forum for future reference for everyone (and myself!) as to how to get it all working.
Nick
I am trying to setup HA on Plesk as suggested by Atomic.
I have implemented an HA MySQL cluster and NFS DRDB redundant storage to share the /var/www/httpd and /var/qmail/mailnames across a secure storage array. I am planning to implement Plesk on two boxes, and have them share the same psa database and same secure storage.
Has anyone got MySQL 4.1 working on an external cluster using sql relay as Atomic suggested or otherwise? SQL relay should do it ... but i am having grief getting it to work correctly. It seems to work with individual databases, but not on any arbitrary database.
An ideal solution would be to get the MySQL client to proxy to my cluster if anyone knows how to do this with MySQL so it can make calls transparently to localhost that actually get forwarded onto the cluster.
Beyond this, my next question would be how to overcome the httpd.conf include files for each domain. These would obviously be pointing to the IP of the first server, but would have to be configured for the second server as well. Has anyone got any ideas of how to implement failover with Apache and Plesk?
Thanks everyone!
When i get this all up and running, i will be posting a huge How To on the forum for future reference for everyone (and myself!) as to how to get it all working.
Nick
