[Pdns-users] PowerDNS Backend MySQL QPS

[Genzo Rey]

Dear Bert,

Thanks so much for your answer,

I have use PowerAdmin to create 100 domains with 1000 Records A for each
domain. So my test file is 100000 different domains.
My PowerDNS version is 3.3.3. So I will try install 4.x.x and test again
with graphs.

Can you tell me about what resource is most important in PowerDNS (CPU, RAM
or Disk Read/Write speed). My boss is very like PowerDNS because it's more
security and HA than Bind (cPanel). The only problems is performance.

I have test 1 VPS 2 CPU 1GB RAM cPanel and it's QPS is 15000 - 19000. With
the same resource 1 VPS 1 CPU 512MB RAM PowerDNS + 1 VPS 1 CPU 512MB RAM
MySQL (1 split into 2 VPS because I want to protect database) and I have
shown you my results. So I need to boost perfomance equal or higher than
cPanel to convince my boss use PowerDNS. Do you have any resource sample
(how many CPU, RAM, ...) or any setting ?

Sorry because asking too much. One again thanks you so much.

Thanks & Best Regards,

----------------------------------------------------------------------------
-------------------------------------
NGUYEN THANH HIEN (GENZO REY)
Tel: (08) 3 806 0360 | Cell Phone: 093 799 2063
Skype: lionheart91091
Email: lionheart91091 at outlook.com, lionheart91091 at gmail.com,
lionheart91091 at icloud.com

-----Original Message-----
From: bert hubert [mailto:bert.hubert at powerdns.com] 
Sent: Tuesday, July 19, 2016 03:47
To: Genzo Rey <lionheart91091 at gmail.com>
Cc: pdns-users at mailman.powerdns.com
Subject: Re: [Pdns-users] PowerDNS Backend MySQL QPS

On Tue, Jul 19, 2016 at 03:41:37AM +0700, Genzo Rey wrote:
> I'm looking for new Nameserver solutions for my company. I build 1 VPS 
> PowerDNS 512 MB RAM and 1 VPS MySQL 512MB RAM to test performance (qps).
> This is my results:

Hi Genzo,

Did you try 100000 unique queries?

Secondly, which version of PowerDNS did you test?

Finally, during testing, can you enable graphing? See
https://blog.powerdns.com/2014/12/11/powerdns-graphing-as-a-service/ - this
shows what PowerDNS is doing as it answers your questions.

>   Queries per second:   2131.778761

If this is all cache misses on a low-power VPS on 3.x.x, with lots of
domains, this number is not unexpected.

Can you try 4.x.x and with the graphs? That will allow us to see if
performance is what you could expect.

	Bert