Database on other servers

Discussion in 'Server Operation' started by Erik Damber, Dec 10, 2020.

  1. Erik Damber

    Erik Damber Member


    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!
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    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.
  3. Erik Damber

    Erik Damber Member

    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.
  4. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    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.
  5. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

    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.

Share This Page