Graphing BIND 9.11/9.10 Queries

[Welisson Tomé]

Hi All,

I'd like to know what kind of tools are you using to graphing queries on Bind as Recursion Server?

BestRegards,

--

Welisson Tomé
br.linkedin.com/in/welissontome/

[Bob Harold]

https://www.dns-oarc.net/tools/dsc

-- 

Bob Harold

 

[Jerry K]

I'm sure others will answer, but if you haven't already done so, I would suggest
the list archives for answers already in place.

Here are a few I pulled out of my personal BIND list archives.

.............................................
http://o-s.kpnqwest.pt

mrtg - multiple list references to /contrib/queryperf directory

http://www.snoogans.co.uk/files/rndcstats.pl <- link dead, but I bet this can be
found somewhere. Might be here <https://github.com/jackl0phty/snmp-rndc-stats>

dnsstats - found here -> http://www.shub-internet.org/brad/dns/index.html

Bind 8 & 9 stats from campin.net, waybackmachine reference
http://web.archive.org/web/20030216040611/http://www.campin.net/DNS/
http://web.archive.org/web/20030207033410/http://www.campin.net/DNS/graph.html

many standard Unix monitoring utilities, Cacti, Nagios, etc, have graphing
utilities either built into the core for DNS, or via some contributed text.

Orca -

originally here -
<http://web.archive.org/web/20030209214009/http://o-s.kpnqwest.pt/>
but now reference <https://www.orcaware.com>
or <http://www.oracle.com/technetwork/systems/articles/orca-jsp-138999.html>
or <https://www.gadgetdaily.xyz/use-orca-to-monitor-system-performance/>
.............................................

Hopefully something here helps.

If you find something you like better, please share.

Jerry

On 01/18/17 08:16 AM, Welisson Tomé wrote:
>
>
> Hi All,
>
> I'd like to know what kind of tools are you using to graphing queries on
> Bind as Recursion Server?
>
> BestRegards,
>
>
>

> _______________________________________________
> Please visit https://lists.isc.org/mailman/listinfo/bind-users to unsubscribe from this list
>
> bind-users mailing list
> bind-...@lists.isc.org
> https://lists.isc.org/mailman/listinfo/bind-users
>

[Jerry Lundström]

Hi,

On 01/18/17 18:25, Bob Harold wrote:
>
> On Wed, Jan 18, 2017 at 9:16 AM, Welisson Tomé <weliss...@ig.com.br

> <mailto:weliss...@ig.com.br>> wrote:
>
> I'd like to know what kind of tools are you using to graphing
> queries on Bind as Recursion Server?
>

> https://www.dns-oarc.net/tools/dsc

We have also been working on graphing with Grafana as you can see on our
test/demo installation:

https://dev.dns-oarc.net/dsc-grafana2/dashboard/db/dsc

Cheers,
Jerry

[Welisson Tomé]

Hi Jerry,

Have you been using some script to collect all information?

Could you shared these scripts with us, please?

BRegards,

---
Welisson Tomé
br.linkedin.com/in/welissontome/

[Jerry Lundström]

Hi Welisson,

On 01/19/17 12:39, Welisson Tomé wrote:
> Have you been using some script to collect all information?

The information is collected by the DNS Statistics Collector (DSC) which
then is processed by dsc-datatool to generate an InfluxDB input file.
That file is later imported and the content display via Grafana.

> Could you shared these scripts with us, please?

I have written a wiki how you can set this up yourself:
https://github.com/DNS-OARC/dsc-datatool/wiki/Setting-up-a-test-Grafana

Cheers,
Jerry

[Welisson Tomé]

Hi Jerry,

Tks so much, I'll check your wiki.

Have you tried use it with Cacti/Zabbix?

BRegards,

---
Welisson Tomé

[Jerry Lundström]

Hi Welisson,

On 01/19/17 13:12, Welisson Tomé wrote:
> Have you tried use it with Cacti/Zabbix?

Yes but not for DSC. With dsc-datatool someone could probably very
easily implement output for other tools if they wish.

Cheers,
Jerry

[Welisson Tomé]

What tool had you tried with these one?

BRegards,

---
Welisson Tomé

[John W. Blue]

Daniel,

Thanks for sharing.  I like the HTTP statistics channel but trying slice up the XML has been challenging.  Going to be checking this combo out.

John

Sent from Nine

From: Daniel Stirnimann <daniel.s...@switch.ch>
Sent: Jan 19, 2017 8:19 AM
To: bind-...@lists.isc.org
Subject: Re: Graphing BIND 9.11/9.10 Queries

Apart from DSC which has been mentioned here, we are also using munin
(www.munin-monitoring.org)

Shumon Huque has written a python plug-in for munin which retrieves the
data from BIND statistics server (via localhost HTTP requests).

https://github.com/shuque/bind9stats

Daniel

[Phil Mayers]

On 19/01/17 15:12, John W. Blue wrote:
> Daniel,
>
> Thanks for sharing. I like the HTTP statistics channel but trying slice
> up the XML has been challenging. Going to be checking this combo out.

We moved to the JSON stats recently to get around a memory leak in our
XML based script. Far nicer IMO.

[Matthew Pounsett]

Yeah, I find processing the JSON stats much easier.. the tools for importing JSON into <insert programming language of choice> tend to be pretty straightforward to use. 

[Phil Mayers]

On 19/01/17 15:18, Matthew Pounsett wrote:

> Yeah, I find processing the JSON stats much easier.. the tools for
> importing JSON into <insert programming language of choice> tend to be
> pretty straightforward to use.

Plug here for excellent CLI tools like httpie and jq for the
development/exploration phase of dealing with the stats (although I find
xpath a bit more familiar than jq syntax)