Re: [Pdns-users] MySQL table columns
* Yves Goergen nospam.l...@unclassified.de [100811 22:39]: Hello, Second question: Is there an overview available that describes what each of the database table columns is good for? There's example data but it doesn't use all columns. Some columns are used for internal purposes I've read, but I haven't found a comprehensive list of all supported columns and what PowerDNS expects to read from them. Especially for diverse record types. There's the one with half a dozen of numbers and I don't know what to put where and what they all mean. If possible, I'd like to create a database view to give those ugly numbers a name and to have a table that only contains the data I want to maintain. Did you read this already? http://doc.powerdns.com/types.html -- christian hofstaedtler ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] MySQL backend and notify
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
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
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