cd /usr/local/src

apt-get source bind9

./configure --prefix=/usr \
	--mandir=\$${prefix}/share/man \
	--infodir=\$${prefix}/share/info \
	--sysconfdir=/etc/bind \
	--localstatedir=/var/run/bind \
	--enable-threads \
	--with-libtool \
	--enable-shared \
	--enable-static \
	--with-openssl=/usr \
	--with-gnu-ld \
	--with-dlz-mysql;
make;
make install;

vi /etc/bind/named.conf (.local)

dlz "Mysql zone" {
	database "mysql
		{host=127.0.0.1 dbname=디비명 user=유저 pass=비번}
		{select zone from dns_records where zone = '%zone%'}
		{select ttl, type, mx_priority, case when lower(type)='txt' then concat('\"', data, '\"') when lower(type) = 'soa' then concat_ws(' ', data, resp_person, serial, refresh, retry, expire, minimum) else data end from dns_records where zone = '%zone%' and host = '%record%'}";
};

 CREATE TABLE `dns_records` (
	`id` int(11) NOT NULL auto_increment,
	`zone` varchar(64) default NULL,
	`host` varchar(64) default NULL,
	`type` varchar(8) default NULL,
	`data` varchar(64) default NULL,
	`ttl` int(11) NOT NULL default '3600',
	`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 '2008082700',
	`resp_person` varchar(64) NOT NULL default 'resp.person.email',
	`primary_ns` varchar(64) NOT NULL default 'ns1.yourdns.here',
	`data_count` int(11) NOT NULL default '0',
	PRIMARY KEY  (`id`),
	KEY `host` (`host`),
	KEY `zone` (`zone`),
	KEY `type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

options {
directory "/etc/bind";
// If there is a firewall between you and nameservers you want
// to talk to, you may need to fix the firewall to allow multiple
// ports to talk.  See http://www.kb.cert.org/vuls/id/800113
// If your ISP provided one or more IP addresses for stable
// nameservers, you probably want to use them as forwarders.
// Uncomment the following block, and insert the addresses replacing
// the all-0's placeholder.
// forwarders {
//      0.0.0.0;
// };
auth-nxdomain no;    # conform to RFC1035
listen-on-v6 { any; };
};

#!/bin/sh -e
### BEGIN INIT INFO
# Provides:          bind9
# Required-Start:    $remote_fs
# Required-Stop:     $remote_fs
# Should-Start:      $network $syslog
# Should-Stop:       $network $syslog
# Default-Start:     2 3 4 5
# Default-Stop:      0 1 6
# Short-Description: Start and stop bind9
# Description:       bind9 is a Domain Name Server (DNS)
#        which translates ip addresses to and from internet names
### END INIT INFO
PATH=/sbin:/bin:/usr/sbin:/usr/bin
# for a chrooted server: "-u bind -t /var/lib/named"
# Don't modify this line, change or create /etc/default/bind9.
OPTIONS=""
RESOLVCONF=no
test -f /etc/default/bind9 && . /etc/default/bind9
test -x /usr/sbin/rndc || exit 0
. /lib/lsb/init-functions
IDFILE=/var/run/named/named.pid
check_network() {
if [ -x /usr/bin/uname ] && [ "X$(/usr/bin/uname -o)" = XSolaris ]; then
IFCONFIG_OPTS="-au"
else
IFCONFIG_OPTS=""
fi
if [ -z "$(/sbin/ifconfig $IFCONFIG_OPTS)" ]; then
#log_action_msg "No networks configured."
return 1
fi
return 0
}
case "$1" in
start)
log_daemon_msg "Starting domain name service..." "bind9"
log_action_msg "modprobe..."
modprobe capability >/dev/null 2>&1 || true
log_action_msg "mkdir..."
# dirs under /var/run can go away on reboots.
mkdir -p /var/run/named
log_action_msg "chmod..."
chmod 775 /var/run/named
log_action_msg "chown..."
chown root:bind /var/run/named >/dev/null 2>&1 || true
log_action_msg "! -x /usr/sbin/named..?"
if [ ! -x /usr/sbin/named ]; then
log_action_msg "true.."
log_action_msg "named binary missing - not starting"
log_end_msg 1
fi
log_action_msg "false.."
log_action_msg "! check_network..?"
if ! check_network; then
log_action_msg "true.."
log_action_msg "no networks configured"
log_end_msg 1
fi
log_action_msg "false.."
log_action_msg "start..?"
if start-stop-daemon --start --oknodo --exec /usr/sbin/named \
--pidfile ${PIDFILE} -- $OPTIONS; then
if [ "X$RESOLVCONF" != "Xno" ] && [ -x /sbin/resolvconf ] ; then
echo "nameserver 127.0.0.1" | /sbin/resolvconf -a lo.named
fi
log_end_msg 0
else
log_action_msg "false.."
log_end_msg 1
fi
;;
stop)
log_daemon_msg "Stopping domain name service..." "bind9"
if ! check_network; then
log_action_msg "no networks configured"
log_end_msg 1
fi
if [ "X$RESOLVCONF" != "Xno" ] && [ -x /sbin/resolvconf ] ; then
/sbin/resolvconf -d lo.named
fi
pid=$(/usr/sbin/rndc stop -p | awk '/^pid:/ {print $2}') || true
if [ -z "$pid" ]; then          # no pid found, so either not running, or error
pid=$(pgrep -f ^/usr/sbin/named) || true
start-stop-daemon --stop --oknodo --quiet --exec /usr/sbin/named \
--pidfile ${PIDFILE} -- $OPTIONS
fi
if [ -n $pid ]; then
while kill -0 $pid 2>/dev/null; do
log_progress_msg "waiting for pid $pid to die"
sleep 1
done
fi
log_end_msg 0
;;
reload|force-reload)
log_daemon_msg "Reloading domain name service..." "bind9"
if ! check_network; then
log_action_msg "no networks configured"
log_end_msg 1
fi
/usr/sbin/rndc reload >/dev/null && log_end_msg 0 || log_end_msg 1
;;
restart)
if ! check_network; then
log_action_msg "no networks configured"
exit 1
fi
$0 stop
$0 start
;;
status)
ret=0
status_of_proc -p ${PIDFILE} /usr/sbin/named bind9 2>/dev/null || ret=$?
exit $ret
;;
*)
log_action_msg "Usage: /etc/init.d/bind9 {start|stop|reload|restart|force-reload|status}"
exit 1
;;
esac
exit 0

# for www.domain.com to resolve to 1.2.3.4
insert into dns_records (zone, host, type, data, mx_priority) values ('domain.com', 'www', 'A', '1.2.3.4', null);
# for domain.com to resolve to 1.2.3.4
insert into dns_records (zone, host, type, data, mx_priority) values ('domain.com', '@', 'A', '1.2.3.4', null);
# for www2.domain.com to alias to www.domain.com;
# note the trailing period in the data field
insert into dns_records (zone, host, type, data, mx_priority) values ('domain.com', 'www2', 'CNAME', 'www.domain.com.', null);
# for mail for domain.com to go to domain.com
# note the trailing period in the data field
insert into dns_records (zone, host, type, data, mx_priority) values ('domain.com', '@', 'MX', 'domain.com.', '0');

allow-recursion { any; };
allow-query { any; };
allow-query-cache { any; };