在powerdns服务器上安装相应的包（基于epel源）
[root@powerdns ~]# yum install pdns pdns-backend-mysql -y
在master-mairadb服务器上创建库表并授权
MariaDB [(none)]> create database powerdns; Query OK, 1 row affected (0.00 sec) MariaDB [(none)]> grant all on powerdns.* to ‘powerdns‘@‘192.168.37.%‘ identified by ‘centos‘; Query OK, 0 rows affected (0.00 sec) MariaDB [(none)]> flush privileges; Query OK, 0 rows affected (0.01 sec)
MariaDB [(none)]> use powerdns;
创建powerdns数据库中的表，参看下面文档实现
https://doc.powerdns.com/md/authoritative/backend-generic-mysql/
在proxysql上面添加授权用户
MySQL [(none)]> insert into mysql_users(username,password,default_hostgroup) values (‘powerdns‘,‘centos‘,10); Query OK, 1 row affected (0.00 sec) MySQL [(none)]> load mysql users to runtime; Query OK, 0 rows affected (0.00 sec) MySQL [(none)]> save mysql users to disk; Query OK, 0 rows affected (0.01 sec)
在powerdns服务器配置powerdns使用mariadb作为后台数据存储
[root@powerdns ~]# vim /etc/pdns/pdns.conf launch=gmysql gmysql-host=192.168.37.23 gmysql-port=6033 gmysql-dbname=powerdns gmysql-user=powerdns gmysql-password=centos
启动服务
[root@powerdns ~]# systemctl start pdns
[root@powerdns ~]# systemctl enable pdns
安装http和php相关的包，实现web页面管理
[root@powerdns ~]# yum -y install httpd php php-devel php-gd php-mcrypt php-imap php-ldap php-mysql php-odbc php-pear php-xml php-xmlrpc php-mbstring php-mcrypt php-mhash gettext [root@powerdns ~]# systemctl start httpd [root@powerdns ~]# systemctl enable httpd
下载poweradmin程序，并解压到相应目录
[root@powerdns ~]# wget http://downloads.sourceforge.net/project/poweradmin/poweradmin-2.1.7.tgz [root@powerdns ~]# tar xf poweradmin-2.1.7.tgz [root@powerdns ~]# mv poweradmin-2.1.7 /var/www/html/poweradmin
原文：https://www.cnblogs.com/maxuebin/p/11328873.html