On a multi server setup with mirror server, eg. www1, www2, ns1, ns2, db1, db2, mail1, mail2, where in www1 is the ISPConfig master. If I install ISPConfig panel on www2, it still not have all the server joined like www1. I just want to ask the different approach to handle failover of www1 in terms of ISPConfig panel.
There a tutorial for clustering a web, email and mysql database: https://www.howtoforge.com/tutorial...abase-cluster-on-debian-8.4-with-ispconfig-3/
I think you misunderstood my point. Im looking into ispconfig web control panel server(master ispconfig) failover. I already have a cluster and mirror setup for all service.
According to the comments of the clustering Tutorial, it should work. https://www.howtoforge.com/tutorial...ase-cluster-on-debian-8.4-with-ispconfig-3/5/ Comments 1 and 2.
As confirmed by @Taleman, it can also work for ISPConfig web control panel server. Just backup the ISPConfig mirrored server config.inc.php, then copy and use the ISPConfig master server config.inc.php in its place as posted by @till in there. With some troubleshootings, it should work.
The ISPConfig interface part is basically a website, so not that different from a cms system. This interface connects to a database. To make it HA, you must make the database HA that this interface connects to. The ispconfig slave servers are connecting to this database too by using the dbmaster database credentials in their config files to pull the data which is relevant for them into their local database once a minute. So if you want to create a large scale HA ISPConfig setup, then the main part is to make the master database highly available. you can then have as many server run an interface as you want, you just have to take care that all of them connect to the same master database instance to not get any split-brain situations and that all slaves use this database instance as their master database too.
Thank you all for the reply. I was able to make it work with your advise. However, I observed that local ispconfig database of ns1,ns2, mail1, mail2 doesn't contain or update the web_database table if a new DB was added on DB server. However, If I add new DB user in DB Server, web_database_user table of local ispconfig DB of all server was updated.
That's as it should be. A database is added only on the server where the database is created. db users are added on all servers in the dbispconfig database as they are global.
oh I see. Right now I have ispconfig DB master pointed to WWW1 is it possible for me to run rsync tool then ispconfig_update.sh(on all server) to use the dbispconfig database on my DB1 server? my DB1 server has master to master replication with DB2 so it will be ideal for me to use it if possible.
ISPConfig update script is not able to reconfigure this for you, you will have to do that manually by editing all config files on all nodes.
