Difference between revisions of "PowerDNS: Create PowerDNS Database dan User di Percona / MySQL"
Jump to navigation
Jump to search
Onnowpurbo (talk | contribs) (Created page with "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...") |
Onnowpurbo (talk | contribs) |
||
Line 35: | Line 35: | ||
account VARCHAR(40) DEFAULT NULL, | account VARCHAR(40) DEFAULT NULL, | ||
PRIMARY KEY (id) | PRIMARY KEY (id) | ||
− | ); | + | ); |
− | CREATE UNIQUE INDEX name_index ON domains(name | + | CREATE UNIQUE INDEX name_index ON domains(name); |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | CREATE TABLE supermasters ( | + | 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, | |
− | CREATE TABLE comments ( | + | 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 INDEX comments_domain_id_idx ON comments (domain_id); | + | |
− | CREATE INDEX comments_name_type_idx ON comments (name, type); | + | CREATE TABLE supermasters ( |
− | CREATE INDEX comments_order_idx ON comments (domain_id, modified_at); | + | ip VARCHAR(64) NOT NULL, |
− | + | nameserver VARCHAR(255) NOT NULL, | |
− | CREATE TABLE domainmetadata ( | + | account VARCHAR(40) NOT NULL, |
− | + | PRIMARY KEY (ip, nameserver) | |
− | + | ); | |
− | + | ||
− | + | CREATE TABLE comments ( | |
− | + | id INT AUTO_INCREMENT, | |
− | ); | + | domain_id INT NOT NULL, |
− | CREATE INDEX domainmetadata_idx ON domainmetadata (domain_id, kind); | + | name VARCHAR(255) NOT NULL, |
− | + | type VARCHAR(10) NOT NULL, | |
− | CREATE TABLE cryptokeys ( | + | 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 INDEX domainidindex ON cryptokeys(domain_id); | + | |
− | + | CREATE TABLE domainmetadata ( | |
− | CREATE TABLE tsigkeys ( | + | 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 UNIQUE INDEX namealgoindex ON tsigkeys(name, algorithm); | + | |
− | quit; | + | 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; | ||
Revision as of 17:30, 27 September 2018
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;