ispconfig with galera cluster

Discussion in 'Installation/Configuration' started by craigfanman, Jan 23, 2018.

  1. craigfanman

    craigfanman Member

    Hi I'm planning on migration to a galera cluster and just wanted to ask a few questions. Currently I have 8 LAMP servers with apache/mysql and about 200 sites on each. I've now made a galera cluster with haproxy in front, tested all working fine.

    Question I have is: how to integrate this into ispconfig? My best guess is I install the ispconfig DB node onto the haproxy server, this means its still independent of galera nodes being up/down? although the 1 haproxy server does become a single point of failure now.

    also when you have a setup like this is it best to move ALL databases onto the cluster and completely shutoff mysql on the web server, or should I keep a small mysql installation on each web server just for the local ispconfig database and other local services? (pureftpd relies on it etc)

    any tips appreciated thanks.
     

Share This Page