[Pdns-users] question about PDNS - performance

[Owen Borseth]

I wish I kept the stats around, but when we first implemented PDNS we 
had a slaved mysql DB on each server. Eventually we decided to have all 
the servers use a central DB running on high end hardware and the 
performance increase was significant. Our DB is located in Denver, 
Colorado, US and 3 of our servers are on the same GB network as the DB. 
We also have one server located in Atlanta, Georgia, US. With the high 
cache hit rate that we have the performance ding on the cross country DB 
connections are negligible and has never been an issue.

- Owen

bert hubert wrote:

>On Wed, Feb 23, 2005 at 10:32:00AM +1300, Dan Clark wrote:
>  
>
>>ok excellent, thats just what I wanted to hear ;)
>>just one query, is your SQL on the same box/s as the DNS daemon? or do 
>>you have it across the network on the core MYSQL server?
>>    
>>
>
>We've seen great results from a separate machine for the database. There is
>some cost in latency, but if you use gigabit that is very limited. You may
>want to increase the number of distributor-threads for a remote machine.
>
>  
>
>>I'm trying to find where the bottlekneck is slowing it all down and 
>>can't get logging to file to work (just wont populate the .log file)
>>    
>>
>
>Try query-logging in PowerDNS. There are also tools to diagnose 'slow
>queries' on MySQL. 
>
>Good luck!
>
>  
>