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!
No, thats not nescessary as ispconfig syncs that automatically. Just check why the snc has stopped: http://www.faqforge.com/linux/debugging-ispconfig-3-server-actions-in-case-of-a-failure/
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!
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?
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.
