Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 25th July 2012, 13:06
rodti rodti is offline
Member
 
Join Date: Apr 2007
Posts: 58
Thanks: 6
Thanked 3 Times in 3 Posts
Default ISPConfig3 multiserver out of sync

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!
Reply With Quote
The Following User Says Thank You to rodti For This Useful Post:
teencelom (1st August 2012)
Sponsored Links
  #2  
Old 25th July 2012, 14:15
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,775
Thanks: 821
Thanked 5,332 Times in 4,184 Posts
Default

Quote:
I suspect all I need to do is to copy data from the good dbispconfig1 to the outdated dbispconfig2.
No, thats not nescessary as ispconfig syncs that automatically. Just check why the snc has stopped:

http://www.faqforge.com/linux/debugg...-of-a-failure/
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
rodti (25th July 2012)
  #3  
Old 25th July 2012, 16:01
rodti rodti is offline
Member
 
Join Date: Apr 2007
Posts: 58
Thanks: 6
Thanked 3 Times in 3 Posts
Default

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!
Reply With Quote
  #4  
Old 25th July 2012, 16:18
rodti rodti is offline
Member
 
Join Date: Apr 2007
Posts: 58
Thanks: 6
Thanked 3 Times in 3 Posts
Default

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?
Reply With Quote
  #5  
Old 25th July 2012, 16:56
rodti rodti is offline
Member
 
Join Date: Apr 2007
Posts: 58
Thanks: 6
Thanked 3 Times in 3 Posts
Default

Actually it seems to have synced now and all seems well. Thanks for your help Till!
Reply With Quote
  #6  
Old 25th July 2012, 16:57
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,775
Thanks: 821
Thanked 5,332 Times in 4,184 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
rodti (25th July 2012)
  #7  
Old 25th July 2012, 16:58
rodti rodti is offline
Member
 
Join Date: Apr 2007
Posts: 58
Thanks: 6
Thanked 3 Times in 3 Posts
 
Default

Quote:
Originally Posted by till View Post
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.
Ah, very clever! And reassuring should this happen again. Thanks again :-)
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISPConfig 3 multiserver not in sync mccyberix HOWTO-Related Questions 1 17th May 2012 01:23
vhost sync multiserver setup frederic Installation/Configuration 1 17th January 2012 11:03
Multiserver Environment - Debian, Postfix, ISPConfig3 erosbk General 1 9th May 2011 02:12
amavis rejects all inbound emails aclhkaclhk Installation/Configuration 5 28th February 2010 04:24
ispconfig3 multiserver thensome Installation/Configuration 1 7th February 2009 11:10


All times are GMT +2. The time now is 18:22.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.