[Linux] PDNS-³×ÀÓ¼¹ö (PowerDNS) ¼³Ä¡ ¹× replication
http://ehostidc.co.kr/center/EH050402.php?no=141488&page=8&choose=tit¡¦ (359)https://blog.naver.com/goethe1/221642889788 (471)
OS : CentOS 7.4
1. pdns 설치(1차/2차 공통)
a. repo 설치
[root@ns1 ehost]# yum install epel-release -y
b. pdns 및 mariadb 설치
[root@ns1 ehost]# yum install mariadb-server mariadb
[root@ns1 ehost]# yum install pdns pdns-backend-mysql
c. DB 설정
[root@ns1 ehost]# systemctl start mariadb
[root@ns2 ehost]# mysql_secure_installation
d. pdns db 생성
[root@ns1 ehost]# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or g.
Your MariaDB connection id is 9
Server version: 5.5.56-MariaDB MariaDB Server
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
Type "help;" or "h" for help. Type "c" to clear the current input statement.
MariaDB [(none)]> create database pdns;
Query OK, 1 row affected (0.00 sec)
MariaDB [(none)]> GRANT ALL ON pdns.* TO "pdns"@"localhost" IDENTIFIED BY "pdns패스워드";
Query OK, 0 rows affected (0.00 sec)
- ( SOA접근 USER 추가 )
MariaDB [(none)]> GRANT ALL ON pdns.* TO "pdns"@"testdns" IDENTIFIED BY "pdns패스워드";
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
e. pdns DB import
[root@ns1 ehost]# cd /usr/share/doc/pdns-backend-mysql-3.4.11/
[ehost@ns1 pdns-backend-mysql-3.4.11]# mysql -updns -pdlghtmxm1509 pdns < schema.mysql.sql
2. pdns 설정 (/etc/pdns/pdns.conf )
a. 1차 네임서버
allow-axfr-ips=2차네임서버IP/32
master=yes
launch=gmysql
gmysql-host=localhost
gmysql-user=pdns
gmysql-password=pdns패스워드
gmysql-dbname=pdns
b. 2차 네임서버
master=no
slave=yes
slave-cycle-interval=60
gmysql-host=localhost
gmysql-user=pdns
gmysql-password=pdns패스워드
gmysql-dbname=pdns
- 2차 서버 DB 설정
[root@ns2 ehost]# mysql -u pdns -p
mysql > use pdns;
mysql > insert into supermasters values ("1차네임서버IP", "ns2.ehostidc.co.kr", "admin");
2차 네임서버 도메인
3. 서비스 등록 및 시작(1/2차 네임서버 공통)
[root@ns1 ehost]# systemctl enable mariadb
[root@ns1 ehost]# systemctl enable pdns
[root@ns1 ehost]# systemctl start pdns
4.powerdns admin 셋팅(1/2차 네임서버 공통)
a. http/php 설치
[root@ns1 ehost]# yum install httpd php php-devel php-gd php-imap php-ldap php-mysql php-odbc php-pear php-xml php-xmlrpc php-mbstring php-mcrypt php-mhash gettext
[root@ns1 ehost]# yum install php-pear-DB php-pear-MDB2-Driver-mysql
b. 웹소스 다운로드
[root@localhost ~]# cd /var/www/html
[root@localhost ~]# wget http://downloads.sourceforge.net/project/poweradmi...
c. 해당 파일 압축해제 및 poweradmin 으로 폴더 이름 변경
d. http://61.97.255.11:8080/poweradmin/install/
- db 접속 정보 셋팅
아래 내용의 쿼리를 디비에서 실행
- cp inc/config-me.inc.php inc/config.inc.php
- inc/config.inc.php 파일 수정
- install 폴더 삭제 후 http://"서버IP"/poweradmin 로 접속
- 1차 서버에서는 Add master zone 에 도메인 셋팅
- 2차 서버에서는 Add slave zone 에 1차와 동일한 도메인 셋팅
- 1차 서버에서 도메인 zone 업데이트 시에 2차로 자동 전파
5. 문제점 및 해결책(?)
a. 도메인 설정을 1/2차에 모두 해야 하는 점.
b. 1/2차 모두 master 로 설정 후 DB를 mysql replication 셋팅하면, 2차 pdns 에 도메인 셋팅 이슈가 없으질듯.
cf. mysql replication 이용해서 설정했을때 오류 발생
May 24 12:23:55 ns2 pdns[2815]: Exiting because communicator thread died with error: GSQLBackend unable to refresh domain_id 2: Failed to execute mysql_query, perhaps connecti
on died? Err=1: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based l
ogging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
May 24 12:23:55 ns2 pdns[2815]: Done launching threads, ready to distribute questions
May 24 12:23:56 ns2 pdns_control: Fatal error: Unable to connect to remote "/var/run/pdns.controlsocket": Connection refused
May 24 12:23:56 ns2 systemd: pdns.service: control process exited, code=exited status=1
May 24 12:23:56 ns2 systemd: Unit pdns.service entered failed state.
May 24 12:23:56 ns2 systemd: pdns.service failed.
my.cnf 설정에서
binlog_format=ROW 또는
binlog_format=MiXED
처리 필요