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 7th July 2010, 17:32
damir damir is offline
Senior Member
 
Join Date: Jun 2006
Posts: 375
Thanks: 11
Thanked 51 Times in 42 Posts
Default ISPC 3, powerdns, mysql replication not working.

Hi all,

Im trying to install PowerDNS as DNS server instead of MyDNS. Test environment includes two servers. One server has ISPConfig installed, powerdns and mysql. Server 2 has Powerdns and mysql installed.

Everything is working fine except replication of mysql with powerdns database that ISPConfig has created.

Replication is working fine with other test databases but not with the PowerDNS database that was created by ISPConfig installer.

If i create new table in powerdns database it's replicated fine but if i create new DNS data through ISPconfig panel than that newly created data is not replicated. It's inserted correctly but tables containg new records is not replicated to server 2.

It seems that something is weird with powerdns database that is created by ISPConfig installer.

Anyone with ispconfig, powerdns mysql replication experience?
Reply With Quote
Sponsored Links
  #2  
Old 7th July 2010, 19:15
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,573
Thanks: 792
Thanked 4,980 Times in 3,901 Posts
Default

Looks as you mix up something here. ISPConfig uses a builtin replication mechanism and not the mysql replication. If you configure mysql replication manually beside the ispconfig replication, the system will fail as it creates a conflict. To fix this, remove the mysql replication as it is not nescessary. Then install one ispconfig master server and as many ispconfig slave servers as you need and ispconfig will replicate all nescessary configuration data between these databases. If you use powerdns, then the powerdns databse and plugin has to be on the slave that runs powerdns and ispconfig will replicate the data from the slave database event based into the powerdns database.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 8th July 2010, 09:24
damir damir is offline
Senior Member
 
Join Date: Jun 2006
Posts: 375
Thanks: 11
Thanked 51 Times in 42 Posts
 
Default

Thanx for the reply Till.

I thought that powerdns db should be replicated through mysql replication. My bad.

Installing two ISPConfig Powerdns slaves and choosing slave 2 to be mirror of slave 1 replicates Powerdns correctly. Damn whole day went in troubleshooting and it was that easy. Well at least i learned everything that is in Mysql replication

Now i have connected two DNS server to existing multi server setup and it works like charm.

Thanx again Till.
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
Squirrelmail login failure Cracklefish Installation/Configuration 9 30th June 2010 20:38
MySQL Database Replication - can't upgrade kpm HOWTO-Related Questions 6 18th April 2010 03:54
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 13:58
mysql replication issues Jamesk5 Server Operation 8 23rd September 2006 14:40
PHP & MySQL working, but AREN'T WORKING???? lipp9000 Installation/Configuration 4 21st July 2006 17:01


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


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