Re: [Pdns-users] MySQL backend and notify

2010-08-12 Thread Yves Goergen
On 12.08.2010 08:28 CE(S)T, bert hubert wrote:
 If configured with 'master' in the configuration, it will periodically
 retrieve a list of all SOA serial numbers, and determine which ones changed.

Does anybody know what time interval this is? Seconds, minutes, hours?

-- 
Yves Goergen LonelyPixel nospam.l...@unclassified.de
Visit my web laboratory at http://beta.unclassified.de
___
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
http://mailman.powerdns.com/mailman/listinfo/pdns-users


Re: [Pdns-users] MySQL backend and notify

2010-08-12 Thread bert hubert
On Thu, Aug 12, 2010 at 08:55:17AM +0200, Yves Goergen wrote:
 On 12.08.2010 08:28 CE(S)T, bert hubert wrote:
  If configured with 'master' in the configuration, it will periodically
  retrieve a list of all SOA serial numbers, and determine which ones changed.
 
 Does anybody know what time interval this is? Seconds, minutes, hours?

1 minute. This is in fact the 'slave-cycle-interval' setting - the name is a
bit confusing.

Bert
___
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
http://mailman.powerdns.com/mailman/listinfo/pdns-users


Re: [Pdns-users] MySQL backend and notify

2010-08-12 Thread Steve Spencer
Yves Goergen wrote:
 Hello,
 
 I'm currently setting up my first PowerDNS server. It shall act as
 master for another DNS server. I'm going to use the gmysql backend. How
 will the pdns server know when I have changed the records in the
 database to send out notifications to the slaves? Will that work on a
 regular basis or will I have to start a separate process to tell
 pdns-server to rescan the database?
 
We use this system now.  Our method is this:

* Two pdns servers, one primary and one secondary
Both running mysql and gmysql back end
* One machine running mysql with a web front end and PDNS Admin Console
for PDNS

* The PDNS console machine operates as the mysql master and both the
master pdns and the slave pdns operate as slaves to this master database

You will need to google: mysql master slave replication.  We've been
using some form of the above implementation for many years.  Works great!

Thanks,
-- 
--
Steven G. Spencer, Network Administrator
KSC Corporate - The Kelly Supply Family of Companies
Office 308-382-8764 Ext. 231
Mobile 308-380-7957
___
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
http://mailman.powerdns.com/mailman/listinfo/pdns-users


Re: [Pdns-users] MySQL backend and notify

2010-08-11 Thread Yves Goergen
On 12.08.2010 00:11 CE(S)T, LikeFiction wrote:
 If PowerDNS finds that a SOA record 
 contains a higher value than this notified_serial, it knows it has to 
 send out an update to the slaves.

Yes, but the question is how does it find that? The database won't tell
its connected clients (here the pdns-server) that some data has changed.
Will pdsn query the database every few seconds or will I have to tell
pdns with a special command that the serial (and thus the data) of a
zone has changed?

-- 
Yves Goergen LonelyPixel nospam.l...@unclassified.de
Visit my web laboratory at http://beta.unclassified.de
___
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
http://mailman.powerdns.com/mailman/listinfo/pdns-users


Re: [Pdns-users] MySQL backend and notify

2010-08-11 Thread Ton van Rosmalen
Hi,

Yves Goergen schreef:
 On 12.08.2010 00:11 CE(S)T, LikeFiction wrote:
   
 If PowerDNS finds that a SOA record 
 contains a higher value than this notified_serial, it knows it has to 
 send out an update to the slaves.
 

 Yes, but the question is how does it find that? The database won't tell
 its connected clients (here the pdns-server) that some data has changed.
 Will pdsn query the database every few seconds or will I have to tell
 pdns with a special command that the serial (and thus the data) of a
 zone has changed?

   
The slaves check on a regular interval whether the master has an updated
serial in the SOA.
If a higher serial exists this is detected and the zone is transferred
to the slave.

Regards,

Ton
___
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
http://mailman.powerdns.com/mailman/listinfo/pdns-users