Re: [Pdns-users] mysql vs postgresql

2007-02-05 Thread bert hubert
On Tue, Feb 06, 2007 at 09:33:27AM +1100, Adam Cassar wrote: > We tested this on Debian 'testing'. Pdns version is 2.9.20. In testing I > used the gmysql and gpgsql backends. One big powerdns user attains 12000qps using PostgreSQL on millions of records, but they do a lot of caching on the PowerDN

Re: [Pdns-users] mysql vs postgresql

2007-02-05 Thread Adam Cassar
Hi, We tested this on Debian 'testing'. Pdns version is 2.9.20. In testing I used the gmysql and gpgsql backends. Postgresql is version 8.1 and Mysql version 5.0.32 The following Postgresql settings where changed: effective_cache_size shared_buffers The following Mysql settings where changed:

Re: [Pdns-users] forward-zones with private address spaces

2007-02-05 Thread Kenneth Marshall
Yes, it works great (when you edit the right file). I did not need to set --serve-rfc1918=off. Ken On Mon, Feb 05, 2007 at 10:38:54AM -0500, Michael C. Gates wrote: > Does this mean you can have both internal and external addresses? That would > be awesome. Right now, I have a hosts file, which I

RE: [Pdns-users] forward-zones with private address spaces

2007-02-05 Thread Michael C. Gates
Does this mean you can have both internal and external addresses? That would be awesome. Right now, I have a hosts file, which I run a script that gets all of the records, and replaces the first three sections of the ip address with 10.1.1.etc. But it would be really sweet if I could just have an e

Re: [Pdns-users] forward-zones with private address spaces

2007-02-05 Thread Kenneth Marshall
I apologize for the wasted bandwidth. The pdns-recursor startup script had been changed to point to a different recursor.conf file. I was editing the wrong file which had no effect as might be expected. Egg on face, Ken On Mon, Feb 05, 2007 at 04:28:49PM +0100, bert hubert wrote: > On Mon, Feb 05

Re: [Pdns-users] forward-zones with private address spaces

2007-02-05 Thread bert hubert
On Mon, Feb 05, 2007 at 09:25:15AM -0600, Kenneth Marshall wrote: > forward-zones=10.in-addr.arpa= That is the proper syntax. Can you show the output of --trace while you run a query on the 10 range? Also, you may need to run with --serve-rfc1918=off to prevent the internal zones from interferin

[Pdns-users] forward-zones with private address spaces

2007-02-05 Thread Kenneth Marshall
Hi, Has anyone gotten the forward-zones option for the PDNS recursor to work with private address spaces? We have some internal 10.* address and the forward lookup works. But the reverse fails. Here is what I had in the recursor.conf file: forward-zones=10.in-addr.arpa= It fails to resolve. Mayb

[Pdns-users] Slave server configuration

2007-02-05 Thread Devraj Mukherjee
Hi Everyone, I am trying to setup a slave DNS server, using pdns and sqlite, I have the proper version of pdns-server installed on the machine and configured to talk to a SQLite database. Is this what I need or do I need the recursor version? What do I do next, just copy the records? How do I au

Re: [Pdns-users] mysql vs postgresql

2007-02-05 Thread Norbert Sendetzky
Hi Adam > On a same of 100K zones and using the queryperf tool available with bind > (selecting each record from each zone) over a 10 minute run, both > untuned postgresql and mysql was able to handle around 2000 qps. > > After tuning both Postgresql and Mysql, I was able to reach 2500 qps on > Po