PowerDNS Authoritative server high availability with MariaDB Galera

Power Up

Testing

After adding more nodes to the cluster, a quick and easy test is to connect to any node in the cluster with the MariaDB client and run a quick SQL statement:

sudo mariadb
SHOW GLOBAL STATUS LIKE 'wsrep_cluster_size';

If the size of the cluster is equal to the number of nodes in the cluster, it's time to celebrate! If the size is smaller than expected, either a node did not start correctly, or it cannot connect to the Primary Component.

Conclusion

If you need basic and easy data replication with minimal setup time, MariaDB's Galera Cluster has you covered. Just think what you could do with a slightly more complex configuration with HAProxy [6] and Keepalived [7]. Imagine having a single web interface that could update all PowerDNS Authoritative servers at once, thanks to Galera [8].

Infos

"Speed up Your Name Server with a MySQL Back End" by Joseph Guarino: https://www.admin-magazine.com/Articles/Speed-up-Your-Name-Server-with-a-MySQL-Back-End/
"Exploring PowerDNS" by Joseph Guarino: https://www.admin-magazine.com/Articles/PowerDNS-The-Other-Open-Source-Name-Server/
PowerDNS 4.2 schema: https://github.com/PowerDNS/pdns/blob/rel/auth-4.2.x/modules/gmysqlbackend/schema.mysql.sql
PowerDNS 4.1 schema: https://github.com/PowerDNS/pdns/blob/rel/auth-4.1.x/modules/gmysqlbackend/schema.mysql.sql
MariaDB system variables and options: https://mariadb.com/docs/deploy/community-cluster-cs10-5-rhel8/
HAProxy: http://www.haproxy.org/
Keepalived: https://github.com/acassen/keepalived
PowerDNS-Admin: https://github.com/PowerDNS-Admin/PowerDNS-Admin

The Author

Donnie Greer is a 26-year IT veteran specializing in Linux, IaaS, and as little work as possible. He can often be heard yelling at his Synology NAS: "Work faster! I believe in you!"

« Previous 1 2