[Pdns-users] What is best practice with Primary and Secondary (multiple) PowerDNS Servers?

[Sinisa Burina]

I'm using three servers in different geo locations, each with its own
MariaDB backend, all DB servers joined in Galera cluster. As long as only
one server goes down at a time (or, more precisely put, as long as there
are at least two online to preserve quorum), the cluster gets synchronized
automatically and updated with the most recent changes, whichever DB gets
the updates. The more servers you add to the cluster, the better.

If there are frequent updates from external sources/api clients, things can
be made even more resilient by setting up a floating A or CNAME record with
low TTL to point to one of the working servers, or like in my case, code
the API client so it tries to send the update to several predefined IPs
until the request is successful.

This setup is working for more than 3 years now for me without even the
slightest glitch. I am so satisfied with it that I simply had to share it
with you. 🙂


Best regards,
        Sinisa "Sonny" Burina

On Wed, Nov 18, 2020, 08:23 Sinisa Burina <sburina at gmail.com> wrote:

> I'm using three servers in different geo locations, each with its own
> MariaDB backend, all DB servers joined in Galera cluster. As long as only
> one server goes down at a time (or, more precisely put, as long as there
> are at least two online to preserve quorum), the cluster gets synchronized
> automatically and updated with the most recent changes, whichever DB gets
> the updates. The more servers you add to the cluster, the better.
>
> If there are frequent updates from external sources/api clients, things
> can be made even more resilient by setting up a floating A or CNAME record
> with low TTL to point to one of the working servers, or like in my case,
> code the API client so it tries to send the update to several predefined
> IPs until the request is successful.
>
> This setup is working for more than 3 years now for me without even the
> slightest glitch. I am so satisfied with it that I simply had to share it
> with you. 🙂
>
> Best regards,
>         Sinisa "Sonny" Burina
>
> On Wed, Nov 18, 2020, 00:41 Jacob Bunk Nielsen via Pdns-users <
> pdns-users at mailman.powerdns.com> wrote:
>
>> On 18/11/2020 04.04, Steven Garner via Pdns-users wrote:
>>
>> > What is the accepted best practice with Primary and Secondary
>> > (multiple) PowerDNS Servers?
>> >
>> > Assume PowerDNS server is set up with a MySQL (or other) database
>> > back-end. With at least 2 servers each on different networks, should
>> > the master instance of PowerDNS and each slave instance query the same
>> > MySQL DB, or should each one have its own local MySQL DB?
>>
>> If you have multiple instances that query the same database on a single
>> database server, you don't have any redundancy, then why not just have a
>> single DNS-server too?
>>
>> MySQL supports replication, so I'd suggest running a replica of you DNS
>> database along with your auth DNS server. Should your master database
>> server fail, you'll be unable to update your DNS records, but you'll
>> still be able to answer DNS queries based on the replicas.
>>
>> Best regards,
>>
>> Jacob
>>
>> _______________________________________________
>> Pdns-users mailing list
>> Pdns-users at mailman.powerdns.com
>> https://mailman.powerdns.com/mailman/listinfo/pdns-users
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20201118/8cfd4070/attachment.htm>