[Multiserver setup] Restore master ispconfig database, what about others servers db ?

Discussion in 'General' started by ledufakademy, Dec 5, 2020.

  1. ledufakademy

    ledufakademy Member HowtoForge Supporter

    we need to restore( juste one days before) our main web server (with ispconfig panel and so main ispconfig database ...).
    during this days we only create one mailbox and one mail alias.
    After this successful restore, mailbox and ailias was not present in ispconfig WEBGUI (nomal) but present on mail server : normal.
    So we decide to recreate this two elements with ispconfig webgui.
    But now they are stucking in job queue (we see 2 red point in job queue)
    How can we correct this ?
    thank you.
  2. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

  3. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    did you compare the values for server.updated in the ispconfig-database on both servers?
    ahrasis likes this.
  4. ledufakademy

    ledufakademy Member HowtoForge Supporter

    Follow the guide : just , change server config (web1 and mail3) to "debug" log level ... on master server (ispconfig panel = web1) and on mailserver n°3, but no log debuging done or any action taken.
    Then red point ... disappear !
    ISPCOnfig is a voodoo thing.

    The question stay the same : how did ispconfig will perform database sync after restoring server which hold the main ispconfig database (web1 in my case) ? (juste one day of offsync), how other server deal with master ispconfig database ?

    Here is our setup (can help other !)

    Capture d’écran du 2020-09-09 22-32-22.png
    Last edited: Dec 5, 2020
    ahrasis likes this.
  5. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    It uses the server.updated value as @florian030 indicated above. With jobs in queue, you will want to set a lower value for your slave servers, less than what the master has queued to be done.
    ledufakademy likes this.
  6. ledufakademy

    ledufakademy Member HowtoForge Supporter

    hello jesse,
    where can i found the "server.updated" on ispconfig WEBGUI ?
    master , slave : we have no master or slave , only a server , web1, that is hosting ispconfig panel , and can acces all other mariadb on all server ... is it that you call "master" server ?
  7. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    It is not there. It is a value in the database.
    ledufakademy and ahrasis like this.

Share This Page