Hello! We are hosting a web service and using ISPconfig. We have all clients on virtual machines but now we have exported all the databases (SQL) to a three server cluster. I want to know whats the best way to install new clients now? The only thing I can think of is installing ISPconfig och the new server and creating the databases there via the ISPconfig web interface and then configure db.ini the right way. The new database servers are a Galera cluster and not sure if installing ispconfig there is the right way to go. Another option is just creating the database on the client servers and then migrate the database to the db cluster and pointing to it in db.ini. Any suggestions? Thanks!
Do you mean the databases are on a server that does not have ISPConfig installed? If this is the setup, I can not offer any useful advice. ISPConfig does work with a separate database host, and the ISPConfig Manual explains how to set it up. I think it would be possible to install three database hosts that way.
Yes we recently migrated the databases to a cluster for a HA solution with HAproxy. I've migrate all 130 customers databases to those servers. Just trying to find a good routine for installing new clients. Guess we might have to install as usual and then export the empty database with tables to our new cluster and point with db.ini.
If you do not mind writing code, adding copying of database to new database creation in ISPConfig would be doable. This is guessing, I have not coded plugins for ISPConfig and do not know how.
I haven't done it but as @Taleman said, it is doable. I think extend current one to it will be faster and disable the current one once the process (including setting servers access to it) is finished.
