Why does the master dbispconfig located in web server? Can it possibly put to DB server? so the installation will go like this. DB1 -> Web1 -> DNS1 ->DNS2-> Mail1 Later on, we can possibly add DB2(Web2,Mail2) for mirroring. Will this makes maintaining the DB server much easier?
Because you need a webserver to run the controlpanel UI. Sure, but in this case, you have to install a web server (apache or nginx) on the database server. Not really. But if you plan to install a large scale setup, you will probably use a dedicated server just for the controlpanel as master server.
Thank you for your answer. For the meantime dbispconfig master is in web server but clients DB is located in db server. I am trying to add a mirror for each server. On ISPConfig 3.1 manual 3.3.1.5. MySQL Master-Master Replication - Prepare Server1, should I do this on www1 or db1 server? If I will do this on the www1, should I also do this on db1 to mirror db2? If I will able to have a dedicated and mirror servers setup correctly with HAProxy High Availability. Will I be able to configure HAProxy with round-robin or leastconn without affecting data integrity?
From what I can see each server in multi server setup has ISPConfig installed with at least a minimal php (cli, mysql, mcrypt) and mysql to support it, so separating only its master database from master ispconfig UI kinda pointless and may be difficult as you may need major restructuring, though I did read some threads asking about it and claiming their success in doing so. Anyway, I think it is up to you to mirror any server whether it is a web, mail, dns or database server but I am not so sure about mirroring and HAProxy high-availability thing as I never reached that level.
