ISPConfig3 multiserver out of sync

Discussion in 'General' started by rodti, Jul 25, 2012.

  1. rodti

    rodti New Member HowtoForge Supporter

    Hi there,

    My dual-server ISPConfig3 setup has been running fine until today when I changed some DNS records. The changes appear in dbispconfig1 but not in dbispconfig2.

    My first thought was to check the master/slave replication and it seems to be okay, but then that shouldn't be the problem as it would mirror both databases regardless of content. Somehow the mirror ISPConfig server hasn't updated its database.

    I suspect all I need to do is to copy data from the good dbispconfig1 to the outdated dbispconfig2. Should these databases be an identical copy of each mirror? I could do a simple export/import from one to the other but worried there are server/install specific tables for each server that I might break!
     
  2. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

  3. rodti

    rodti New Member HowtoForge Supporter

    I'm getting a replication error on the slave. Does this mean something's broken in ISPConfig's syncing or the master/slave MySQL replication? Looking in the dbispconfig2 on the slave there are multiple errors with missing .frm files, but all fine on the copy on the master.

    Getting a bit worried now!
     
  4. rodti

    rodti New Member HowtoForge Supporter

    Please disregard, I think that was a permissions issue.

    Assuming the databases sync between each other and across machines, will either the cron jobs or a resync be enough to update the (now quite out of date) config files on the slave server?
     
  5. rodti

    rodti New Member HowtoForge Supporter

    Actually it seems to have synced now and all seems well. Thanks for your help Till!
     
  6. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    The cronjob should update the config files automatically when the problem occured less then 30 days ago as the system keeps a backlog of 30 days for all cahnges on the master.
     
  7. rodti

    rodti New Member HowtoForge Supporter

    Ah, very clever! And reassuring should this happen again. Thanks again :)
     

Share This Page