[docker]bind9.11-with-mysql5.6 docker容器化实战
来源：互联网 发布：python 矩阵处理 编辑：程序博客网 时间：2024/06/03 15:53
参考:
https://www.centos.bz/2012/09/bind-with-mysql-support/
http://blog.51niux.com/?id=125
http://4709096.blog.51cto.com/4699096/1599424
这些编译安装的东西没必要深究,没任何意义.简单方便为好.
1. bind物理机安装
需求: 找一个有api的dns.可以直接增加mysql记录不用重启dns即可动态更新,于是动手搞一套mysqlbackend+bind.
后来发现有 powerdns dj-dns也可以实现这些功能,没必要自己搞.思路: 先搞清楚物理机怎么编译bind–>容器化mysql–> 容器化mysql+supervisor–>容器化mysql+supervisor+bind
- 目前最新的bind集合mysql不需要改bind源代码了,改起来很烦的.
- bind和mysql本来不想安装在一台机器上,无奈编译bind需要依赖mysql的lib库(期间我尝试按照mysql-devel还是没能解决),这里已经解决了. 我用debian:jessie为基础
apt-get install -y g++ libboost-all-dev libtool make pkg-config libmysqlclient-dev libssl-dev然后编译安装bind9.11就可以了.见文末
- 1.1二进制安装 mysql-5.6.30-linux-glibc2.5-x86_64.tar.gz
yum -y install perl-develtar -xf mysql-5.6.30-linux-glibc2.5-x86_64.tar.gz -C /usr/local/ln -s mysql-5.6.30-linux-glibc2.5-x86_64 /usr/local/mysqluseradd mysql -s /sbin/nologin -Mchown -R mysql:mysql /usr/local/mysql/cd /usr/local/mysql/support-files/\cp my-default.cnf /etc/my.cnf ## 这个配置文件可以用第二部分my.conf改了字符集\cp mysql.server /etc/init.d/mysqld ## 这样/etc/init.d/mysqld start 就可以启动了/usr/local/mysql/bin/mysqladmin -u root password '123456'vi /etc/profileexport PATH=$PATH:/usr/local/mysql/bin# 初始化-物理机这样操作,如果在容器部分,则可以将初始化好的/data目录替换mysql二进制包里的data,之后就不需要构建镜像时候初始化了./usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data# 启动/usr/local/mysql/bin/mysqld_safe --user=mysql #前台启动/usr/local/mysql/bin/mysqld_safe --user=mysql & - 1.2编译安装bind-9.11.2.tar.gz
一定要编译安装,加上with-dlz-mysql, yum安装默认是不支持mysql backend的.
echo "/usr/local/mysql/lib" >>/etc/ld.so.conf \ldconfigyum install -y perl-devel openssl-develcd /usr/local/src/tar xf bind-9.11.2.tar.gzcd bind-9.11.2/ \ && ./configure --prefix=/usr/local/bind \ --with-dlz-mysql=/usr/local/mysql \ --enable-largefile \ --disable-openssl-version-check \ --enable-threads \ --disable-ipv6 && make && make install./configure –prefix=/usr/local/bind \
–with-dlz-mysql \
–enable-largefile \
–disable-openssl-version-check \
–enable-threads \
–disable-ipv6
make
- 1.3配置named
cat /usr/local/bind/etc/named.conflogging { channel query_log { file "/var/log/named.log" versions 3 size 100m; severity info; print-time yes; print-category yes; print-severity yes; };category queries { query_log; };category lame-servers { null; };};dlz "My zone" { database "mysql {host=172.17.92.3 dbname=dns ssl=false port=3306 user=root pass=123456} {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$'}";};- 1.4登录数据库插入示例数据
create database dns;use dnsCREATE TABLE dns_records(id int(11) unsigned NOT NULL auto_increment,zone varchar(255) NOT NULL,host varchar(255) NOT NULL default '@',type varchar(255) NOT NULL,data text,ttl int(11) default 600,mx_priority int(11) default NULL,refresh int(11) default NULL,retry int(11) default NULL,expire int(11) default NULL,minimum int(11) default NULL,serial bigint(20) default NULL,resp_person varchar(255) default NULL,primary_ns varchar(255),PRIMARY KEY(id));CREATE INDEX host_index ON dns_records(host);CREATE INDEX type_index ON dns_records(type);CREATE INDEX zone_index ON dns_records(zone);insert into dns_records (zone,host,type,data,refresh,retry,expire,minimum,serial,resp_person,primary_ns) values('test.com','@','SOA','ns.test.com',7200,3600,86400,3600,1000,'root.test.com.','ns.test.com.');insert into dns_records (zone,host,type,data) values('test.com','@','NS','ns.test.com.');insert into dns_records (zone,host,type,data) values('test.com','ns','A','1.1.1.1');insert into dns_records (zone,host,type,data) values('test.com','www','A','127.0.0.1');- 1.5启动调试named
/usr/local/bind/sbin/named -c /usr/local/bind/etc/named.conf -g/usr/local/bind/sbin/named -c /home/bind/etc/named.conf2.mysql
- Dockerfile
From centos:7# Init centosENV TZ="PRC"RUN ln -sf \ /usr/share/zoneinfo/Asia/Shanghai \ /etc/localtimeRUN yum install -y autoconf libaio perl-devel make gcc gcc-c++ \ && yum clean allCOPY my.conf /etc/ADD mysql.tar.gz /usr/local/RUN useradd mysql -s /sbin/nologin -M \ && chown -R mysql:mysql /usr/local/mysql \ && echo 'echo 'export PATH=$PATH:/usr/local/mysql/bin/' >> /etc/profile' \ && source /etc/profileEXPOSE 3306CMD ["/usr/local/mysql/bin/mysqld_safe","--user=mysql"]- my.conf
[mysqld]basedir=/usr/local/mysql/datadir=/usr/local/mysql/data/default-storage-engine = innodbinnodb_file_per_table = 1character-set-server = utf8collation-server = utf8_general_ciinit-connect = 'SET NAMES utf8'[mysql]default-character-set = utf8[mysql.server]default-character-set = utf8[mysqld_safe]default-character-set = utf8[client]default-character-set = utf83.mysql-supervisor
- Dockerfile
From centos:7# Init centosENV TZ="PRC"RUN ln -sf \ /usr/share/zoneinfo/Asia/Shanghai \ /etc/localtimeRUN yum install -y autoconf libaio perl-devel make gcc gcc-c++ openssl-devel epel-release \ && yum clean all#supervisorRUN yum -y install supervisor && \ mkdir -p /etc/supervisor/ && \ yum clean allCOPY supervisord.conf /etc/supervisor/COPY my.conf /etc/ADD mysql.tar.gz /usr/local/RUN useradd mysql -s /sbin/nologin -M \ && chown -R mysql:mysql /usr/local/mysql \ && echo 'export PATH=$PATH:/usr/local/mysql/bin/' >> /etc/profile \ && source /etc/profileCOPY entry.sh /usr/local/bin/EXPOSE 3306ENTRYPOINT ["entry.sh"]- entry.sh
#!/usr/bin/env bash## mysql初始化 设置密码echo "-----------------------------usage------------------------------------------------------"echo "insert into dns_records (zone,host,type,data) values('test.com','@','NS','ns.test.com.');"echo "insert into dns_records (zone,host,type,data) values('test.com','ns','A','1.1.1.1');"echo "insert into dns_records (zone,host,type,data) values('test.com','www','A','127.0.0.1');"echo "-----------------------------------------------------------------------------------------"supervisord -c /etc/supervisor/supervisord.conf- my.conf
[mysqld]basedir=/usr/local/mysql/datadir=/usr/local/mysql/data/default-storage-engine = innodbinnodb_file_per_table = 1character-set-server = utf8collation-server = utf8_general_ciinit-connect = 'SET NAMES utf8'[mysql]default-character-set = utf8[mysql.server]default-character-set = utf8[mysqld_safe]default-character-set = utf8[client]default-character-set = utf84.bind-with-mysql-supervisor
CentOS-7 bind-9.11.2.tar.gz mysql-5.6.30-linux-glibc2.5-x86_64.tar.gz- Dockerfile
From centos:7# Init centosENV TZ="PRC"RUN ln -sf \ /usr/share/zoneinfo/Asia/Shanghai \ /etc/localtimeRUN yum install -y autoconf libaio perl-devel make gcc gcc-c++ openssl-devel epel-release \ && yum clean all#supervisorRUN yum -y install supervisor && \ mkdir -p /etc/supervisor/ && \ yum clean allCOPY supervisord.conf /etc/supervisor/# mysqlADD mysql.tar.gz /usr/local/RUN useradd mysql -s /sbin/nologin -M \ && chown -R mysql:mysql /usr/local/mysql \ && echo 'export PATH=$PATH:/usr/local/mysql/bin/' >> /etc/profile \ && source /etc/profile \ && echo "/usr/local/mysql/lib" >>/etc/ld.so.conf \ && ldconfig# bindADD bind-9.11.2.tar.gz /usr/local/src/RUN cd /usr/local/src/bind-9.11.2/ \ && ./configure --prefix=/usr/local/bind \ --with-dlz-mysql=/usr/local/mysql \ --enable-largefile \ --disable-openssl-version-check \ --enable-threads \ --disable-ipv6 \ --disable-linux-caps \ && make && make installCOPY named.conf /usr/local/bind/etcCOPY entry.sh /usr/local/bin/EXPOSE 53/udp 53/tcp 3306/tcpENTRYPOINT ["entry.sh"]- entry.sh
#!/usr/bin/env bash## mysql初始化 设置密码echo "-----------------------------usage------------------------------------------------------"echo "insert into dns_records (zone,host,type,data) values('test.com','@','NS','ns.test.com.');"echo "insert into dns_records (zone,host,type,data) values('test.com','ns','A','1.1.1.1');"echo "insert into dns_records (zone,host,type,data) values('test.com','www','A','127.0.0.1');"echo "-----------------------------------------------------------------------------------------"supervisord -c /etc/supervisor/supervisord.confecho ‘sdasdfadsfda \
asdfadsfads’
- named.conf
logging { channel query_log { file "/var/log/named.log" versions 3 size 100m; severity info; print-time yes; print-category yes; print-severity yes; };category queries { query_log; };category lame-servers { null; };};dlz "My zone" { database "mysql {host=127.0.0.1 dbname=dns ssl=false port=3306 user=root pass=123456} {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$'}";};- supervisor.sh
[supervisord]nodaemon = true[program:mysqld]command=/usr/local/mysql/bin/mysqld_safe --user=mysqlprocess_name=%(program_name)sauto_start = trueautorestart = true[program:named]command=/usr/local/bind/sbin/named -c /usr/local/bind/etc/named.conf -gprocess_name=%(program_name)sauto_start = trueautorestart = truestdout_logfile = /dev/stdoutstdout_logfile_maxbytes = 0stderr_logfile = /dev/stderrstderr_logfile_maxbytes = 0- my.conf
[mysqld]basedir=/usr/local/mysql/datadir=/usr/local/mysql/data/default-storage-engine = innodbinnodb_file_per_table = 1character-set-server = utf8collation-server = utf8_general_ciinit-connect = 'SET NAMES utf8'[mysql]default-character-set = utf8[mysql.server]default-character-set = utf8[mysqld_safe]default-character-set = utf8[client]default-character-set = utf8至此一切编译顺利,
期间遇到dockerfile COPY目录一个小问题, COPY mysql /user/local/ 拷贝不进去,拷贝文件没问题, 最终解决: COPY mysql /user/local/mysql即可.
更新: 从debian:jessie,实现bind和mysql分离
- Dockerfile
FROM debian:jessie#http://mirrors.aliyun.com/help/debianCOPY sources.list /etc/apt/sources.listRUN apt-get update \ && apt-get install -y g++ libboost-all-dev libtool make pkg-config libmysqlclient-dev libssl-dev \ && apt-get clean# bindADD bind-9.11.2.tar.gz /usr/local/src/RUN cd /usr/local/src/bind-9.11.2/ \ && ./configure --prefix=/usr/local/bind \ --with-dlz-mysql \ --enable-largefile \ --disable-openssl-version-check \ --enable-threads \ --disable-ipv6 \ --disable-linux-caps \ && make && make installCOPY named.conf /usr/local/bind/etcCOPY entry.sh /usr/local/bin/ENV TZ="PRC"RUN ln -sf \ /usr/share/zoneinfo/Asia/Shanghai \ /etc/localtimeEXPOSE 53/udp 53/tcpENTRYPOINT ["entry.sh"]- entry.sh
#!/usr/bin/env bashechoecho "--------------------------------请初始化你的bind的mysqlbackend库-----------------------"echo "create database dns;use dnsCREATE TABLE dns_records(id int(11) unsigned NOT NULL auto_increment,zone varchar(255) NOT NULL,host varchar(255) NOT NULL default '@',type varchar(255) NOT NULL,data text,ttl int(11) default 600,mx_priority int(11) default NULL,refresh int(11) default NULL,retry int(11) default NULL,expire int(11) default NULL,minimum int(11) default NULL,serial bigint(20) default NULL,resp_person varchar(255) default NULL,primary_ns varchar(255),PRIMARY KEY(id));CREATE INDEX host_index ON dns_records(host);CREATE INDEX type_index ON dns_records(type);CREATE INDEX zone_index ON dns_records(zone);insert into dns_records (zone,host,type,data,refresh,retry,expire,minimum,serial,resp_person,primary_ns) values('test.com','@','SOA','ns.test.com',7200,3600,86400,3600,1000,'root.test.com.','ns.test.com.');insert into dns_records (zone,host,type,data) values('test.com','@','NS','ns.test.com.');insert into dns_records (zone,host,type,data) values('test.com','ns','A','1.1.1.1');insert into dns_records (zone,host,type,data) values('test.com','www','A','127.0.0.1');"echo "----------------------------------------------be happy---------------------------------------------------"echoif [ ! -n "$1" ] ;then echo "dokcer run -p 53:53/udp -p 53:53/tcp bind-with-nomysql your_mysqlserver_ip" exit 0;fimysqlserver_ip=$1sed -i "s#127.0.0.1#${mysqlserver_ip}#g" /usr/local/bind/etc/named.conf/usr/local/bind/sbin/named -c /usr/local/bind/etc/named.conf -g- named.conf
options{ forwarders { 192.168.6.6; };};logging { channel query_log { file "/var/log/named.log" versions 3 size 100m; severity info; print-time yes; print-category yes; print-severity yes; };category queries { query_log; };category lame-servers { null; };};dlz "My zone" { database "mysql {host=127.0.0.1 dbname=dns ssl=false port=3306 user=root pass=123456} {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$'}";};- sources.list
deb http://mirrors.aliyun.com/debian/ jessie main non-free contribdeb http://mirrors.aliyun.com/debian/ jessie-proposed-updates main non-free contribdeb-src http://mirrors.aliyun.com/debian/ jessie main non-free contribdeb-src http://mirrors.aliyun.com/debian/ jessie-proposed-updates main non-free contrib阅读全文
0 0
- [docker]bind9.11-with-mysql5.6 docker容器化实战
- 【实战】Docker容器资源管理
- Docker入门实战-SSH连接docker容器
- Docker容器实战-简介、安装
- Docker容器实战-简单使用
- Docker容器实战-深入理解
- Docker容器数据管理6
- Docker 实战——将 JavaWeb 应用容器化
- Docker实战之创建一个tomcat容器
- Docker容器
- docker 容器
- docker容器
- Docker 容器
- Docker容器
- Docker容器
- Docker容器
- docker 容器
- docker容器
- 三种工厂模式的学习
- 小白初用Android studio的cMake编译生成.so库并调用
- iOS-仿智联字符图片验证码
- virtualenv和virtualenvwrapper介绍、安装和使用
- 我的ELK搭建笔记（阿里云上部署）
- [docker]bind9.11-with-mysql5.6 docker容器化实战
- 两种方法上传本地文件到github
- vue-i18n学习-01
- eclipse 导出maven的依赖架包
- 如何通过 DNS 验证方式获取Let’s Encrypt 证书的快速脚本
- 第九周-项目三-用二叉树遍历思想解决问题
- 第12周项目4-Floyd算法的验证
- python语言基础知识——基本数据类型详解
- java结构型设计模式——代理模式
