PowerDNS: Create PowerDNS Database dan User di Percona / MySQL

Masuk ke MySQL

sudo mysql -u root -p123456 

Akan keluar

Welcome to the MySQL monitor.  Commands end with ; or \g. 
Your MySQL connection id is 47 
Server version: 5.6.24-72.2 Percona Server (GPL), Release 72.2, Revision 8d0f85b 

Copyright (c) 2009-2015 Percona LLC and/or its affiliates 
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. 

Oracle is a registered trademark of Oracle Corporation and/or its 
affiliates. Other names may be trademarks of their respective 
owners. 

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 

mysql> 

Buat database ‘powerdns’. Database user 'poweruser'. Atau kita dapat membuat sendiri juga

CREATE DATABASE powerdns; 
GRANT ALL ON powerdns.* TO 'poweruser'@'localhost' IDENTIFIED BY 'ubuntu'; 
FLUSH PRIVILEGES; 

USE powerdns; CREATE TABLE domains (

 id                    INT AUTO_INCREMENT, 
 name                  VARCHAR(255) NOT NULL, 
 master                VARCHAR(128) DEFAULT NULL, 
 last_check            INT DEFAULT NULL, 
 type                  VARCHAR(6) NOT NULL, 
 notified_serial       INT DEFAULT NULL, 
 account               VARCHAR(40) DEFAULT NULL, 
 PRIMARY KEY (id) 
); 
CREATE UNIQUE INDEX name_index ON domains(name); 

CREATE TABLE records ( 
  id                    INT AUTO_INCREMENT, 
  domain_id             INT DEFAULT NULL, 
  name                  VARCHAR(255) DEFAULT NULL, 
  type                  VARCHAR(10) DEFAULT NULL, 
  content               VARCHAR(64000) DEFAULT NULL, 
  ttl                   INT DEFAULT NULL, 
  prio                  INT DEFAULT NULL, 
  change_date           INT DEFAULT NULL, 
  disabled              TINYINT(1) DEFAULT 0, 
  ordername             VARCHAR(255) BINARY DEFAULT NULL, 
  auth                  TINYINT(1) DEFAULT 1, 
  PRIMARY KEY (id) 
); 
CREATE INDEX nametype_index ON records(name,type); 
CREATE INDEX domain_id ON records(domain_id); 
CREATE INDEX recordorder ON records (domain_id, ordername); 

CREATE TABLE supermasters ( 
  ip                    VARCHAR(64) NOT NULL, 
  nameserver            VARCHAR(255) NOT NULL, 
  account               VARCHAR(40) NOT NULL, 
  PRIMARY KEY (ip, nameserver) 
); 

CREATE TABLE comments ( 
  id                    INT AUTO_INCREMENT, 
  domain_id             INT NOT NULL, 
  name                  VARCHAR(255) NOT NULL, 
  type                  VARCHAR(10) NOT NULL, 
  modified_at           INT NOT NULL, 
  account               VARCHAR(40) NOT NULL, 
  comment               VARCHAR(64000) NOT NULL, 
  PRIMARY KEY (id) 
); 
CREATE INDEX comments_domain_id_idx ON comments (domain_id); 
CREATE INDEX comments_name_type_idx ON comments (name, type); 
CREATE INDEX comments_order_idx ON comments (domain_id, modified_at); 

CREATE TABLE domainmetadata ( 
  id                    INT AUTO_INCREMENT, 
  domain_id             INT NOT NULL, 
  kind                  VARCHAR(32), 
  content               TEXT, 
  PRIMARY KEY (id) 
); 
CREATE INDEX domainmetadata_idx ON domainmetadata (domain_id, kind); 

CREATE TABLE cryptokeys ( 
  id                    INT AUTO_INCREMENT, 
  domain_id             INT NOT NULL, 
  flags                 INT NOT NULL, 
  active                BOOL, 
  content               TEXT, 
  PRIMARY KEY(id) 
); 
CREATE INDEX domainidindex ON cryptokeys(domain_id); 

CREATE TABLE tsigkeys ( 
  id                    INT AUTO_INCREMENT, 
  name                  VARCHAR(255), 
  algorithm             VARCHAR(50), 
  secret                VARCHAR(255), 
  PRIMARY KEY (id) 
); 
CREATE UNIQUE INDEX namealgoindex ON tsigkeys(name, algorithm); 
quit; 

Pranala Menarik

• PowerDNS
• IPv6