« Previous 1 2
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
« Previous 1 2
Buy this article as PDF
(incl. VAT)