Continued from the previous article《 Centos uses Bind to configure intelligent DNS (2) 》, this article is mainly about bind+dlz+mysql Combination!
[ root @ MASTER named ] # /usr/local/mysql/bin/mysql -V
/ usr / local / mysql / bin / mysql Ver fourteen point one four Distrib 5.6.28 , for Linux ( x86_64 ) using EditLine wrapper
[ root @ MASTER named ] # /usr/local/mysql/bin/mysql -uroot -p
ERROR two thousand and two ( HY000 ) : Can 't connect to local MySQL server through socket ' / usr / local / mysql / tmp / mysql . sock ' ( two )
[ root @ MASTER named ] # /etc/init.d/mysqld start
zero
one
two
three
four
five
six
seven
eight
nine
ten
eleven
twelve
thirteen
fourteen
fifteen
sixteen
seventeen
eighteen
nineteen
twenty
twenty-one
twenty-two
twenty-three
twenty-four
twenty-five
twenty-six
twenty-seven
twenty-eight
twenty-nine
thirty
thirty-one
thirty-two
thirty-three
thirty-four
thirty-five
thirty-six
thirty-seven
thirty-eight
thirty-nine
forty
forty-one
forty-two
forty-three
forty-four
forty-five
forty-six
forty-seven
forty-eight
forty-nine
fifty
fifty-one
fifty-two
fifty-three
fifty-four
fifty-five
fifty-six
fifty-seven
fifty-eight
fifty-nine
sixty
sixty-one
sixty-two
sixty-three
sixty-four
sixty-five
sixty-six
sixty-seven
sixty-eight
sixty-nine
seventy
seventy-one
seventy-two
seventy-three
seventy-four
seventy-five
seventy-six
seventy-seven
seventy-eight
seventy-nine
eighty
eighty-one
eighty-two
eighty-three
eighty-four
eighty-five
eighty-six
eighty-seven
eighty-eight
eighty-nine
mysql > update mysql. user set password = PASSWORD ( '123456' ) where user = 'root' ;
mysql > flush privileges ;
mysql > create database dnsdb default character set utf8 collate utf8_general_ci;
mysql > create user 'dnsdb' @ 'localhost' identified by '123456' ;
mysql > grant all on dnsdb.* to 'dnsdb' @ 'localhost' identified by '123456' ;
mysql > CREATE TABLE `dns_records` (
- > `id` int (10) unsigned NOT NULL auto_increment ,
- > `zone` varchar (255) NOT NULL ,
- > ` host ` varchar (255) NOT NULL default '@' ,
- > ` type ` enum ( 'MX' , 'CNAME' , 'NS' , 'SOA' , 'A' , 'PTR' ) NOT NULL ,
- > `data` varchar (255) default NULL ,
- > `ttl` int (11) NOT NULL default '120' ,
- > ` view ` char (20) default 'DF' ,
- > `mx_priority` int (11) default NULL ,
- > `refresh` int (11) NOT NULL default '3600' ,
- > `retry` int (11) NOT NULL default '3600' ,
- > `expire` int (11) NOT NULL default '86400' ,
- > `minimum` int (11) NOT NULL default '3600' ,
- > `serial` bigint (20) NOT NULL default '2015050100' ,
- > `resp_person` varchar (64) NOT NULL default 'root.t4x.org.' ,
- > `primary_ns` varchar (64) NOT NULL default 'ns1.t4x.org.' ,
- > `data_count` int (11) NOT NULL default '0' ,
- > PRIMARY KEY (`id`),
- > KEY ` type ` (` type `),
- > KEY ` host ` (` host `),
- > KEY `zone` (`zone`)
- > ) ENGINE = MyISAM AUTO_INCREMENT = one DEFAULT CHARSET = utf8;
Query OK, zero rows affected (0.13 sec)
mysql > desc dns_records;
+-------------+-----------------------------------------+------+-----+---------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-----------------------------------------+------+-----+---------------+----------------+
| id | int (10) unsigned | NO | PRI | NULL | auto_increment |
| zone | varchar (255) | NO | MUL | NULL | |
| host | varchar (255) | NO | MUL | @ | |
| type | enum ( 'MX' , 'CNAME' , 'NS' , 'SOA' , 'A' , 'PTR' ) | NO | MUL | NULL | |
| data | varchar (255) | YES | | NULL | |
| ttl | int (11) | NO | | one hundred and twenty | |
| view | char (20) | YES | | DF | |
| mx_priority | int (11) | YES | | NULL | |
| refresh | int (11) | NO | | three thousand and six hundred | |
| retry | int (11) | NO | | three thousand and six hundred | |
| expire | int (11) | NO | | eighty-six thousand and four hundred | |
| minimum | int (11) | NO | | three thousand and six hundred | |
| serial | bigint (20) | NO | | two billion fifteen million fifty thousand and one hundred | |
| resp_person | varchar (64) | NO | | root.t4x.org. | |
| primary_ns | varchar (64) | NO | | ns1.t4x.org. | |
| data_count | int (11) | NO | | zero | |
+-------------+-----------------------------------------+------+-----+---------------+----------------+
sixteen rows in set (0.06 sec)
mysql > INSERT INTO `dns_records` (`zone`, ` host `, ` type `, `data`, `ttl`,`mx_priority`, `refresh`, `retry`, `expire`,
- > `minimum`, `serial`, `resp_person`, `primary_ns`, `data_count`) VALUES
- > ( 't4x.org' , '@' , 'SOA' , 'ns1.t4x.org.' , 10, NULL , 3600, 3600, 86400, 10, 2015050200, 'root.t4x.org.' , 'ns1.t4x.org.' , 0);
Query OK, one row affected (0.12 sec)
mysql > INSERT INTO `dns_records` (`zone`,` host `, ` type `, `data`) VALUES
- > ( 't4x.org' , '@' , 'NS' , 'ns1.t4x.org.' ),
- > ( 't4x.org' , '@' , 'NS' , 'ns2.t4x.org.' );
Records: two Duplicates: zero Warnings : zero
mysql > INSERT INTO `dns_records` (`zone`, ` host `, ` type `, `data`) VALUES
- > ( 't4x.org' , 'ns1' , 'A' , '1.1.1.19' ),
- > ( 't4x.org' , 'ns2' , 'A' , '1.1.1.20' );
Query OK, two rows affected (0.00 sec)
Records: two Duplicates: zero Warnings : zero
mysql > INSERT INTO `dns_records` (`zone`, ` host `, ` type `, `data`, `ttl`, ` view `) VALUES
- > ( 't4x.org' , 'www' , 'A' , '1.1.1.1' , 3600, 'LOCAL' ),
- > ( 't4x.org' , 'www' , 'A' , '2.2.2.2' , 3600, 'CTCC' ),
- > ( 't4x.org' , 'www' , 'A' , '3.3.3.3' , 3600, 'CUCC' ),
- > ( 't4x.org' , 'www' , 'A' , '4.4.4.4' , 3600, 'CMCC' ),
- > ( 't4x.org' , 'www' , 'A' , '5.5.5.5' , 3600, 'CECC' ),
- > ( 't4x.org' , 'www' , 'A' , '6.6.6.6' , 3600, 'OTHERS' );
Query OK, six rows affected (0.00 sec)
Records: six Duplicates: zero Warnings : zero
mysql > INSERT INTO `dns_records` (`zone`, ` host `, ` type `, `data`, `ttl`, ` view `) VALUES
- > ( 't4x.org' , 'bbs' , 'A' , '11.11.11.11' , 3600, 'LOCAL' ),
- > ( 't4x.org' , 'bbs' , 'A' , '22.22.22.22' , 3600, 'CTCC' ),
- > ( 't4x.org' , 'bbs' , 'A' , '33.33.33.33' , 3600, 'CUCC' ),
- > ( 't4x.org' , 'bbs' , 'A' , '44.44.44.44' , 3600, 'CMCC' ),
- > ( 't4x.org' , 'bbs' , 'A' , '55.55.55.55' , 3600, 'CECC' ),
- > ( 't4x.org' , 'bbs' , 'A' , '66.66.66.66' , 3600, 'OTHERS' );
Query OK, six rows affected (0.00 sec)
Records: six Duplicates: zero Warnings : zero
mysql > INSERT INTO dns_records (zone, host , type ,DATA, view ) VALUES
- > ( 't4x.org' , 'blog' , 'CNAME' , 'www' , 'LOCAL' ),
- > ( 't4x.org' , 'blog' , 'CNAME' , 'www' , 'CTCC' ),
- > ( 't4x.org' , 'blog' , 'CNAME' , 'www' , 'CUCC' ),
- > ( 't4x.org' , 'blog' , 'CNAME' , 'www' , 'CMCC' ),
- > ( 't4x.org' , 'blog' , 'CNAME' , 'www' , 'CECC' ),
- > ( 't4x.org' , 'blog' , 'CNAME' , 'www' , 'OTHERS' );
Query OK, six rows affected (0.00 sec)
Records: six Duplicates: zero Warnings : zero
View configuration information:
zero
one
two
three
four
five
six
seven
eight
nine
ten
eleven
twelve
thirteen
fourteen
fifteen
sixteen
seventeen
eighteen
nineteen
twenty
twenty-one
twenty-two
twenty-three
twenty-four
twenty-five
twenty-six
twenty-seven
twenty-eight
twenty-nine
thirty
thirty-one
thirty-two
thirty-three
thirty-four
thirty-five
thirty-six
thirty-seven
thirty-eight
thirty-nine
forty
forty-one
forty-two
forty-three
forty-four
forty-five
forty-six
forty-seven
forty-eight
forty-nine
fifty
fifty-one
fifty-two
fifty-three
fifty-four
fifty-five
fifty-six
fifty-seven
fifty-eight
fifty-nine
sixty
sixty-one
sixty-two
sixty-three
sixty-four
sixty-five
sixty-six
sixty-seven
sixty-eight
sixty-nine
seventy
seventy-one
seventy-two
seventy-three
seventy-four
seventy-five
seventy-six
seventy-seven
seventy-eight
seventy-nine
eighty
eighty-one
eighty-two
eighty-three
eighty-four
eighty-five
eighty-six
eighty-seven
eighty-eight
eighty-nine
ninety
ninety-one
ninety-two
ninety-three
ninety-four
ninety-five
ninety-six
ninety-seven
ninety-eight
ninety-nine
one hundred
one hundred and one
one hundred and two
one hundred and three
one hundred and four
one hundred and five
one hundred and six
one hundred and seven
one hundred and eight
one hundred and nine
one hundred and ten
one hundred and eleven
one hundred and twelve
one hundred and thirteen
one hundred and fourteen
one hundred and fifteen
one hundred and sixteen
one hundred and seventeen
one hundred and eighteen
one hundred and nineteen
one hundred and twenty
one hundred and twenty-one
one hundred and twenty-two
one hundred and twenty-three
one hundred and twenty-four
one hundred and twenty-five
one hundred and twenty-six
one hundred and twenty-seven
one hundred and twenty-eight
one hundred and twenty-nine
one hundred and thirty
one hundred and thirty-one
one hundred and thirty-two
one hundred and thirty-three
one hundred and thirty-four
one hundred and thirty-five
one hundred and thirty-six
one hundred and thirty-seven
one hundred and thirty-eight
one hundred and thirty-nine
one hundred and forty
one hundred and forty-one
one hundred and forty-two
one hundred and forty-three
one hundred and forty-four
one hundred and forty-five
one hundred and forty-six
one hundred and forty-seven
one hundred and forty-eight
one hundred and forty-nine
one hundred and fifty
one hundred and fifty-one
one hundred and fifty-two
one hundred and fifty-three
one hundred and fifty-four
one hundred and fifty-five
one hundred and fifty-six
one hundred and fifty-seven
one hundred and fifty-eight
one hundred and fifty-nine
one hundred and sixty
one hundred and sixty-one
one hundred and sixty-two
one hundred and sixty-three
one hundred and sixty-four
one hundred and sixty-five
one hundred and sixty-six
one hundred and sixty-seven
one hundred and sixty-eight
one hundred and sixty-nine
one hundred and seventy
one hundred and seventy-one
one hundred and seventy-two
one hundred and seventy-three
one hundred and seventy-four
one hundred and seventy-five
[ root @ MASTER / ] # cat /var/named/named.rfc1912.zones
view "LOCAL" {
match - clients { key local ; LOCAL ; } ;
server 1.1.1.20 { keys local ; } ;
recursion yes ;
allow - update { none ; } ;
allow - transfer { key local ; } ;
also - notify { 1.1.1.20 ; } ;
notify yes ;
zone "." IN {
type hint ;
file "named.root" ;
} ;
dlz "local zone" {
database "mysql
{host=localhost dbname=dnsdb ssl=false user=dnsdb pass=123456}
{select zone from dns_records where zone = '$zone$' and view='LOCAL'}
{select ttl, type, mx_priority, case when lower(type)='txt' then concat('\"', data, '\"')
else data end from dns_records where zone = '$zone$' and host = '$record$'
and not (type = 'SOA' or type = 'NS') and view='LOCAL'}
{select ttl, type, mx_priority, data, resp_person, serial, refresh, retry, expire, minimum
from dns_records where zone = '$zone$' and (type = 'SOA' or type='NS') and view='LOCAL'}
{select ttl, type, host, mx_priority, data, resp_person, serial, refresh, retry, expire,
minimum from dns_records where zone = '$zone$' and not (type = 'SOA' or type = 'NS') and view='LOCAL'}
{select zone from xfr_table where zone = '$zone$' and client = '$client$' and view='LOCAL'}
{update data_count set count = count + 1 where zone ='$zone$' and view='LOCAL'}" ;
} ;
} ;
view "CTCC" {
match - clients { key ctcc ; CTCC ; } ;
server 1.1.1.20 { keys ctcc ; } ;
recursion yes ;
allow - update { none ; } ;
allow - transfer { key ctcc ; } ;
also - notify { 1.1.1.20 ; } ;
notify yes ;
zone "." IN {
type hint ;
file "named.root" ;
} ;
dlz "ctcc zone" {
database "mysql
{host=localhost dbname=dnsdb ssl=false user=dnsdb pass=123456}
{select zone from dns_records where zone = '$zone$' and view='CTCC'}
{select ttl, type, mx_priority, case when lower(type)='txt' then concat('\"', data, '\"')
else data end from dns_records where zone = '$zone$' and host = '$record$'
and not (type = 'SOA' or type = 'NS') and view='CTCC'}
{select ttl, type, mx_priority, data, resp_person, serial, refresh, retry, expire, minimum
from dns_records where zone = '$zone$' and (type = 'SOA' or type='NS') and view='CTCC'}
{select ttl, type, host, mx_priority, data, resp_person, serial, refresh, retry, expire,
minimum from dns_records where zone = '$zone$' and not (type = 'SOA' or type = 'NS') and view='CTCC'}
{select zone from xfr_table where zone = '$zone$' and client = '$client$' and view='CTCC'}
{update data_count set count = count + 1 where zone ='$zone$' and view='CTCC'}" ;
} ;
} ;
view "CUCC" {
match - clients { key local ; CUCC ; } ;
server 1.1.1.20 { keys cucc ; } ;
recursion yes ;
allow - update { none ; } ;
allow - transfer { key cucc ; } ;
also - notify { 1.1.1.20 ; } ;
notify yes ;
zone "." IN {
type hint ;
file "named.root" ;
} ;
dlz "local zone" {
database "mysql
{host=localhost dbname=dnsdb ssl=false user=dnsdb pass=123456}
{select zone from dns_records where zone = '$zone$' and view='CUCC'}
{select ttl, type, mx_priority, case when lower(type)='txt' then concat('\"', data, '\"')
else data end from dns_records where zone = '$zone$' and host = '$record$'
and not (type = 'SOA' or type = 'NS') and view='CUCC'}
{select ttl, type, mx_priority, data, resp_person, serial, refresh, retry, expire, minimum
from dns_records where zone = '$zone$' and (type = 'SOA' or type='NS') and view='CUCC'}
{select ttl, type, host, mx_priority, data, resp_person, serial, refresh, retry, expire,
minimum from dns_records where zone = '$zone$' and not (type = 'SOA' or type = 'NS') and view='CUCC'}
{select zone from xfr_table where zone = '$zone$' and client = '$client$' and view='CUCC'}
{update data_count set count = count + 1 where zone ='$zone$' and view='CUCC'}" ;
} ;
} ;
view "CMCC" {
match - clients { key cmcc ; CMCC ; } ;
server 1.1.1.20 { keys cmcc ; } ;
recursion yes ;
allow - update { none ; } ;
allow - transfer { key cmcc ; } ;
also - notify { 1.1.1.20 ; } ;
notify yes ;
zone "." IN {
type hint ;
file "named.root" ;
} ;
dlz "cmcc zone" {
database "mysql
{host=localhost dbname=dnsdb ssl=false user=dnsdb pass=123456}
{select zone from dns_records where zone = '$zone$' and view='CMCC'}
{select ttl, type, mx_priority, case when lower(type)='txt' then concat('\"', data, '\"')
else data end from dns_records where zone = '$zone$' and host = '$record$'
and not (type = 'SOA' or type = 'NS') and view='CMCC'}
{select ttl, type, mx_priority, data, resp_person, serial, refresh, retry, expire, minimum
from dns_records where zone = '$zone$' and (type = 'SOA' or type='NS') and view='CMCC'}
{select ttl, type, host, mx_priority, data, resp_person, serial, refresh, retry, expire,
minimum from dns_records where zone = '$zone$' and not (type = 'SOA' or type = 'NS') and view='CMCC'}
{select zone from xfr_table where zone = '$zone$' and client = '$client$' and view='CMCC'}
{update data_count set count = count + 1 where zone ='$zone$' and view='CMCC'}" ;
} ;
} ;
view "CECC" {
match - clients { key cmcc ; CECC ; } ;
server 1.1.1.20 { keys cecc ; } ;
recursion yes ;
allow - update { none ; } ;
allow - transfer { key cecc ; } ;
also - notify { 1.1.1.20 ; } ;
notify yes ;
zone "." IN {
type hint ;
file "named.root" ;
} ;
dlz "cmcc zone" {
database "mysql
{host=localhost dbname=dnsdb ssl=false user=dnsdb pass=123456}
{select zone from dns_records where zone = '$zone$' and view='CECC'}
{select ttl, type, mx_priority, case when lower(type)='txt' then concat('\"', data, '\"')
else data end from dns_records where zone = '$zone$' and host = '$record$'
and not (type = 'SOA' or type = 'NS') and view='CECC'}
{select ttl, type, mx_priority, data, resp_person, serial, refresh, retry, expire, minimum
from dns_records where zone = '$zone$' and (type = 'SOA' or type='NS') and view='CECC'}
{select ttl, type, host, mx_priority, data, resp_person, serial, refresh, retry, expire,
minimum from dns_records where zone = '$zone$' and not (type = 'SOA' or type = 'NS') and view='CECC'}
{select zone from xfr_table where zone = '$zone$' and client = '$client$' and view='CECC'}
{update data_count set count = count + 1 where zone ='$zone$' and view='CECC'}" ;
} ;
} ;
view "OTHERS" {
match - clients { key cmcc ; OTHERS ; } ;
server 1.1.1.20 { keys others ; } ;
recursion yes ;
allow - update { none ; } ;
allow - transfer { key others ; } ;
also - notify { 1.1.1.20 ; } ;
notify yes ;
zone "." IN {
type hint ;
file "named.root" ;
} ;
dlz "cecc zone" {
database "mysql
{host=localhost dbname=dnsdb ssl=false user=dnsdb pass=123456}
{select zone from dns_records where zone = '$zone$' and view='OTHERS'}
{select ttl, type, mx_priority, case when lower(type)='txt' then concat('\"', data, '\"')
else data end from dns_records where zone = '$zone$' and host = '$record$'
and not (type = 'SOA' or type = 'NS') and view='OTHERS'}
{select ttl, type, mx_priority, data, resp_person, serial, refresh, retry, expire, minimum
from dns_records where zone = '$zone$' and (type = 'SOA' or type='NS') and view='OTHERS'}
{select ttl, type, host, mx_priority, data, resp_person, serial, refresh, retry, expire,
minimum from dns_records where zone = '$zone$' and not (type = 'SOA' or type = 'NS') and view='OTHERS'}
{select zone from xfr_table where zone = '$zone$' and client = '$client$' and view='OTHERS'}
{update data_count set count = count + 1 where zone ='$zone$' and view='OTHERS'}" ;
} ;
} ;
include "ctcc.cfg" ;
include "cucc.cfg" ;
include "cmcc.cfg" ;
include "cecc.cfg" ;
include "local.cfg" ;
include "others.cfg" ;
include "keys/ctcc.key" ;
include "keys/cucc.key" ;
include "keys/cmcc.key" ;
include "keys/cecc.key" ;
include "keys/local.key" ;
include "keys/others.key" ;
Data modification:
insert INTO dns_records (zone, host , type ,data,ttl, view ) values ( 't4x.org' , 'ok' , 'A' , '127.0.0.1' , '3600' , 'CMCC' );
INSERT INTO `dns_records` (`zone`, ` host `, ` type `, `data`, `ttl`, ` view `) VALUES ( 't4x.org' , 'bbs' , 'A' , '11.11.11.11' , 3600, 'LOCAL' ); #Insert a record parsed as 11.11.11.11 by bbs.t4x.org
mysql > update dns_records set data = '9.9.9.9' where id =9; #Change the modification type date with ID 9 to 9.9.9.9
mysql > delete from dns_records where id =12; #Delete data with id 12
mysql：
zero
one
two
three
four
five
six
seven
eight
nine
ten
eleven
twelve
thirteen
fourteen
fifteen
sixteen
seventeen
eighteen
nineteen
twenty
twenty-one
twenty-two
twenty-three
twenty-four
twenty-five
twenty-six
twenty-seven
twenty-eight
twenty-nine
thirty
thirty-one
thirty-two
thirty-three
thirty-four
thirty-five
thirty-six
thirty-seven
thirty-eight
thirty-nine
forty
forty-one
forty-two
forty-three
forty-four
forty-five
forty-six
forty-seven
forty-eight
forty-nine
fifty
fifty-one
fifty-two
fifty-three
fifty-four
fifty-five
fifty-six
fifty-seven
fifty-eight
fifty-nine
sixty
sixty-one
sixty-two
sixty-three
sixty-four
sixty-five
sixty-six
sixty-seven
sixty-eight
sixty-nine
seventy
seventy-one
seventy-two
seventy-three
seventy-four
seventy-five
seventy-six
seventy-seven
seventy-eight
seventy-nine
eighty
eighty-one
eighty-two
eighty-three
eighty-four
eighty-five
eighty-six
eighty-seven
eighty-eight
eighty-nine
ninety
ninety-one
ninety-two
ninety-three
ninety-four
ninety-five
ninety-six
ninety-seven
ninety-eight
ninety-nine
one hundred
one hundred and one
one hundred and two
one hundred and three
one hundred and four
one hundred and five
one hundred and six
one hundred and seven
one hundred and eight
one hundred and nine
one hundred and ten
one hundred and eleven
one hundred and twelve
one hundred and thirteen
one hundred and fourteen
one hundred and fifteen
one hundred and sixteen
one hundred and seventeen
one hundred and eighteen
one hundred and nineteen
one hundred and twenty
one hundred and twenty-one
one hundred and twenty-two
one hundred and twenty-three
one hundred and twenty-four
one hundred and twenty-five
one hundred and twenty-six
one hundred and twenty-seven
one hundred and twenty-eight
one hundred and twenty-nine
one hundred and thirty
one hundred and thirty-one
one hundred and thirty-two
one hundred and thirty-three
one hundred and thirty-four
one hundred and thirty-five
one hundred and thirty-six
one hundred and thirty-seven
one hundred and thirty-eight
one hundred and thirty-nine
one hundred and forty
one hundred and forty-one
one hundred and forty-two
one hundred and forty-three
one hundred and forty-four
one hundred and forty-five
one hundred and forty-six
one hundred and forty-seven
one hundred and forty-eight
one hundred and forty-nine
one hundred and fifty
one hundred and fifty-one
one hundred and fifty-two
one hundred and fifty-three
one hundred and fifty-four
one hundred and fifty-five
one hundred and fifty-six
one hundred and fifty-seven
one hundred and fifty-eight
one hundred and fifty-nine
one hundred and sixty
one hundred and sixty-one
one hundred and sixty-two
one hundred and sixty-three
one hundred and sixty-four
one hundred and sixty-five
one hundred and sixty-six
one hundred and sixty-seven
one hundred and sixty-eight
one hundred and sixty-nine
one hundred and seventy
one hundred and seventy-one
one hundred and seventy-two
one hundred and seventy-three
one hundred and seventy-four
one hundred and seventy-five
one hundred and seventy-six
one hundred and seventy-seven
one hundred and seventy-eight
one hundred and seventy-nine
one hundred and eighty
one hundred and eighty-one
one hundred and eighty-two
one hundred and eighty-three
one hundred and eighty-four
one hundred and eighty-five
one hundred and eighty-six
one hundred and eighty-seven
one hundred and eighty-eight
one hundred and eighty-nine
one hundred and ninety
mysql > select * from dns_records\G
*************************** one row ***************************
id: one
zone: t4x.org
host : @
type : SOA
data: ns1.t4x.org.
ttl: ten
view : LOCAL
mx_priority: NULL
refresh: three thousand and six hundred
retry: three thousand and six hundred
expire: eighty-six thousand and four hundred
minimum: ten
serial: two billion fifteen million fifty thousand and two hundred
resp_person: root.t4x.org.
primary_ns: ns1.t4x.org.
data_count: zero
*************************** two row ***************************
id: two
zone: t4x.org
host : @
type : NS
data: ns1.t4x.org.
ttl: one hundred and twenty
view : LOCAL
mx_priority: NULL
refresh: three thousand and six hundred
retry: three thousand and six hundred
expire: eighty-six thousand and four hundred
minimum: three thousand and six hundred
serial: two billion fifteen million fifty thousand and one hundred
resp_person: root.t4x.org.
primary_ns: ns1.t4x.org.
data_count: zero
*************************** three row ***************************
id: three
zone: t4x.org
host : @
type : NS
data: ns2.t4x.org.
ttl: one hundred and twenty
view : LOCAL
mx_priority: NULL
refresh: three thousand and six hundred
retry: three thousand and six hundred
expire: eighty-six thousand and four hundred
minimum: three thousand and six hundred
serial: two billion fifteen million fifty thousand and one hundred
resp_person: root.t4x.org.
primary_ns: ns1.t4x.org.
data_count: zero
*************************** four row ***************************
id: four
zone: t4x.org
host : ns1
type : A
data: 1.1.1.19
ttl: one hundred and twenty
view : LOCAL
mx_priority: NULL
refresh: three thousand and six hundred
retry: three thousand and six hundred
expire: eighty-six thousand and four hundred
minimum: three thousand and six hundred
serial: two billion fifteen million fifty thousand and one hundred
resp_person: root.t4x.org.
primary_ns: ns1.t4x.org.
data_count: zero
*************************** five row ***************************
id: five
zone: t4x.org
host : ns2
type : A
data: 1.1.1.20
ttl: one hundred and twenty
view : LOCAL
mx_priority: NULL
refresh: three thousand and six hundred
retry: three thousand and six hundred
expire: eighty-six thousand and four hundred
minimum: three thousand and six hundred
serial: two billion fifteen million fifty thousand and one hundred
resp_person: root.t4x.org.
primary_ns: ns1.t4x.org.
data_count: zero
*************************** six row ***************************
id: six
zone: t4x.org
host : www
type : A
data: 1.1.1.1
ttl: three thousand and six hundred
view : LOCAL
mx_priority: NULL
refresh: three thousand and six hundred
retry: three thousand and six hundred
expire: eighty-six thousand and four hundred
minimum: three thousand and six hundred
serial: two billion fifteen million fifty thousand and one hundred
resp_person: root.t4x.org.
primary_ns: ns1.t4x.org.
data_count: zero
*************************** seven row ***************************
id: seven
zone: t4x.org
host : www
type : A
data: 2.2.2.2
ttl: three thousand and six hundred
view : CTCC
mx_priority: NULL
refresh: three thousand and six hundred
retry: three thousand and six hundred
expire: eighty-six thousand and four hundred
minimum: three thousand and six hundred
serial: two billion fifteen million fifty thousand and one hundred
resp_person: root.t4x.org.
primary_ns: ns1.t4x.org.
data_count: zero
*************************** eight row ***************************
id: eight
zone: t4x.org
host : www
type : A
data: 3.3.3.3
ttl: three thousand and six hundred
view : CUCC
mx_priority: NULL
refresh: three thousand and six hundred
retry: three thousand and six hundred
expire: eighty-six thousand and four hundred
minimum: three thousand and six hundred
serial: two billion fifteen million fifty thousand and one hundred
resp_person: root.t4x.org.
primary_ns: ns1.t4x.org.
data_count: zero
*************************** nine row ***************************
id: nine
zone: t4x.org
host : www
type : A
data: 4.4.4.4
ttl: three thousand and six hundred
view : CMCC
mx_priority: NULL
refresh: three thousand and six hundred
retry: three thousand and six hundred
expire: eighty-six thousand and four hundred
minimum: three thousand and six hundred
serial: two billion fifteen million fifty thousand and one hundred
resp_person: root.t4x.org.
primary_ns: ns1.t4x.org.
data_count: zero
*************************** ten row ***************************
id: ten
zone: t4x.org
host : www
type : A
data: 5.5.5.5
ttl: three thousand and six hundred
view : CECC
mx_priority: NULL
refresh: three thousand and six hundred
retry: three thousand and six hundred
expire: eighty-six thousand and four hundred
minimum: three thousand and six hundred
serial: two billion fifteen million fifty thousand and one hundred
resp_person: root.t4x.org.
primary_ns: ns1.t4x.org.
data_count: zero
*************************** eleven row ***************************
id: eleven
zone: t4x.org
host : www
type : A
data: 6.6.6.6
ttl: three thousand and six hundred
view : OTHERS
mx_priority: NULL
refresh: three thousand and six hundred
retry: three thousand and six hundred
expire: eighty-six thousand and four hundred
minimum: three thousand and six hundred
serial: two billion fifteen million fifty thousand and one hundred
resp_person: root.t4x.org.
primary_ns: ns1.t4x.org.
data_count: zero
eleven rows in set (0.00 sec)
mysql >
Stress test:
zero
one
two
three
four
five
six
seven
eight
nine
ten
eleven
twelve
thirteen
fourteen
fifteen
sixteen
seventeen
eighteen
nineteen
twenty
twenty-one
twenty-two
twenty-three
twenty-four
twenty-five
twenty-six
twenty-seven
twenty-eight
twenty-nine
thirty
thirty-one
thirty-two
thirty-three
thirty-four
thirty-five
thirty-six
thirty-seven
thirty-eight
thirty-nine
forty
forty-one
forty-two
forty-three
forty-four
forty-five
forty-six
forty-seven
[ root @ MASTER / ] # cd /byrd/tools/bind-9.9.8/contrib/queryperf
[ root @ MASTER queryperf ] # ./ configure
[ root @ MASTER queryperf ] # make
[ root @ MASTER queryperf ] # wc -l abc.txt
nine hundred and ninety-seven thousand two hundred and thirty-four abc . txt
[ root @ MASTER queryperf ] # tail -2 abc.txt
ee . t4x . org A
ee . t4x . org A
[ root @ MASTER queryperf ] # ./ queryperf -d abc.txt -s 1.1.1.19
DNS Query Performance Testing Tool
Version : $ Id : queryperf . c , v one point one two two thousand and seven / 09 / 05 07 : thirty-six : 04 marka Exp $
[ Status ] Processing input data
[ Status ] Sending queries ( beginning with 1.1.1.19 )
[ Status ] Testing complete
Statistics :
Parse input file : once
Ended due to : reaching end of file
Queries sent : nine hundred and ninety-seven thousand two hundred and thirty-four queries
Queries completed : nine hundred and ninety-seven thousand two hundred and thirty-four queries
Queries lost : zero queries
Queries delayed ( ? ) : zero queries
RTT max : zero point two zero zero three six one sec
RTT min : zero point zero zero zero zero three eight sec
RTT average : zero point zero zero two four zero four sec
RTT std deviation : zero point zero zero zero nine five two sec
RTT out of range : zero queries
Percentage completed : one hundred %
Percentage lost : zero %
Started at : Sun Mar twenty-seven twenty-two : sixteen : forty-two two thousand and fifteen
Finished at : Sun Mar twenty-seven twenty-two : eighteen : forty-three two thousand and fifteen
Ran for : one hundred and twenty point four zero zero two five seven seconds
Queries per second : eight thousand two hundred and eighty-two point six five six seven three nine qps
top - twenty-two : seventeen : forty-three up twelve : sixteen , four users , load average : zero point eight seven , zero point two five , zero point zero eight
Tasks : eighty-one total , one running , eighty sleeping , zero stopped , zero zombie
Cpu ( s ) : fifty-six point three % us , thirty-eight point seven % sy , zero % ni , zero % id , zero % wa , zero % hi , five % si , zero % st
Mem : 494420k total , 461120k used , 33300k free , 1864k buffers
Swap : 1015800k total , 302104k used , 713696k free , 90916k cached
Official documents: http://bind-dlz.sourceforge.net/mysql_driver.html
MySQL master-slave synchronization: https://note.t4x.org/database/configuration-mysql-master-slave/ SourceByrd's Weblog- https://note.t4x.org/service/configuration-intelligence-dns-senior/
Download MySQL data for lazy people: http://pan.baidu.com/s/1b4IY42 Password: 45v3 SourceByrd's Weblog- https://note.t4x.org/service/configuration-intelligence-dns-senior/
Reference documents: 1： http://www.tokiwinter.com/set-up-a-bind-dlz-nameserver/ 2： http://docs.linuxtone.org/ebooks/CDN/bind-dlz-view2.pdf 3： http://www.it165.net/admin/html/201209/386.html 4： http://blog.chinaunix.net/uid-10435474-id-2957057.html 5： http://www.linuxidc.com/Linux/2014-03/98556.htm 6： http://os.51cto.com/art/201111/305114.htm 7： http://blog.chenxiaosheng.com/posts/2013-09-09/install-bind-mysql-dlz.html 8： http://ruiaylin.github.io/2015/01/15/intelligent%20Dns%20configuration/ 9： https://www.centos.bz/2012/09/bind-dlz-with-mysql-intelligent-dns/ SourceByrd's Weblog- https://note.t4x.org/service/configuration-intelligence-dns-senior/
SourceByrd's Weblog- https://note.t4x.org/service/configuration-intelligence-dns-senior/
