利用bind9架设智能DNSPostgreSQL数据库篇
利用bind9架设智能DNSmdash;mdash;PostgreSQL数据库篇
智能DNS工作原理：
在用户解析一个域名的时候，判断一下用户的IP，然后跟DNS服务器内部的IP表匹配一下，看看用户是电信还是网通用户，然后给用户返回对应的IP地址。目前的域名服务运营商不提供智能DNS服务，所以必须自行架设DNS服务或者使用网上免费的智能DNS服务，，如DNSPOD
本实例中我架设的是一个简单的内外解析模式，如果需要增加其他类别（电信、网通）只需添加对于的 view 即可。
bind 在很早以前就已经集成了bind-dlz 数据库模块，可支持sqllit、bdb Mysql PostgreSQL ODBC LDAP等数据源，详见：
本次架设采用PostgreSQL作为数据源实现，数据库已经准备完毕（可使用已有的数据库系统，创建一个新库即可）。
1、配置说明
两个view
local 内部网络
any 其他（公网）
2、创建数据库、表并添加基本记录记录
# zone sample.com其他域名的添加方式类似，将zone项替换为对于的域名即可
3、bind 编译安装及配置
rpm包默认不支持dlz模式，需要使用源码编译
以下安装路径为系统默认路径
配置文件 /etc/named.conf
其他配置文件路径 /etc/named/
4、创建相关配置文件
查看是否存在 /etc/rndc.key 文件，如果没有就生成一个
rndc-confgen -a -c rndc.key
默认的rndc.key 文件中的key名称 好像是 rndckey
手动生成的key名称是 rndc-key
key的名称一定要一致，否则会出现不能使用 rndc 刷新、不能同步的问题。
使用 dnssec-keygen 生成view TSIG key
如：
详细见下面的完整配置文件，该配置文件包含文件存储和数据库两种方式（数据库存储已经注视掉），文件存储方式已经包含master slave 之间的TSIG 方式同步。
及在不同的view中使用各自key进行同步。
完整 named.conf 内容
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
MySQL and PostgreSQL: Best Practices in Web Development
Jul 14, 2023 pm 02:34 PM
MySQL and PostgreSQL: Best Practices in Web Development Introduction: In the modern world of web development, databases are an essential component. When choosing a database, common choices are MySQL and PostgreSQL. This article will cover best practices for using MySQL and PostgreSQL in web development and provide some code examples. 1. Applicable scenarios MySQL is suitable for most web applications, especially those that require high performance, scalability and ease of use.
MySQL and PostgreSQL: Performance comparison and optimization tips
Jul 13, 2023 pm 03:33 PM
MySQL and PostgreSQL: Performance Comparison and Optimization Tips When developing web applications, the database is an indispensable component. When choosing a database management system, MySQL and PostgreSQL are two common choices. They are both open source relational database management systems (RDBMS), but there are some differences in performance and optimization. This article will compare the performance of MySQL and PostgreSQL and provide some optimization tips. Performance comparison comparing two database management
MySQL and PostgreSQL: Data Security and Backup Strategies
Jul 13, 2023 pm 03:31 PM
MySQL and PostgreSQL: Data Security and Backup Strategies Introduction: In modern society, data has become an indispensable part of business and personal life. For database management systems, data security and backup strategies are crucial, both to protect data from loss or damage and to ensure the reliability and integrity of recovered data. This article will focus on the data security and backup strategies of two mainstream relational database systems, MySQL and PostgreSQL. 1. Data security: (1) User rights
Learn database functions in Go language and implement addition, deletion, modification and query operations of PostgreSQL data
Jul 31, 2023 pm 12:54 PM
Learn the database functions in the Go language and implement the addition, deletion, modification, and query operations of PostgreSQL data. In modern software development, the database is an indispensable part. As a powerful programming language, Go language provides a wealth of database operation functions and toolkits, which can easily implement addition, deletion, modification and query operations of the database. This article will introduce how to learn database functions in Go language and use PostgreSQL database for actual operations. Step 1: Install the database driver in Go language for each database
How to use PostgreSQL database in PHP programming?
Jun 12, 2023 am 09:27 AM
With the development of database technology, database management systems also present a variety of choices. Developers can choose the most suitable database according to their needs and preferences. As an advanced open source relational database system, PostgreSQL is attracting more and more attention and use by developers. So, how to use PostgreSQL database in PHP programming? 1. Install and configure the PostgreSQL database. Before using PostgreSQL, you need to install and configure it. first
Using PostgreSQL in Go: The Complete Guide
Jun 18, 2023 am 09:28 AM
Go language is a fast and efficient programming language suitable for building web services and back-end applications. PostgreSQL is an open source relational database management system that promises to provide higher reliability, scalability and data security. In this article, we’ll take a deep dive into using PostgreSQL with Go and provide some practical code examples and tips. Installing and setting up PostgreSQL First, we need to install and set up PostgreSQL. Can be found on the official website
PHP implements open source PostgreSQL relational database
Jun 18, 2023 am 08:40 AM
With the development of the Internet, the amount of data continues to grow, and the need for data management becomes increasingly urgent. Relational database is an important way of data management, among which PostgreSQL is popular for its flexibility, scalability and security. This article introduces how to use the PHP language to implement an open source PostgreSQL relational database. I hope it will be helpful to developers with corresponding needs. Overview PostgreSQL is a powerful relational database system that follows the SQL standard and has many
MySQL and PostgreSQL: How to optimize database query performance?
Jul 12, 2023 pm 03:15 PM
MySQL and PostgreSQL: How to optimize database query performance? Overview: Database query performance is an important consideration when developing applications. Good query performance improves application responsiveness and user experience. This article will introduce some methods to optimize database query performance, focusing on two commonly used databases, MySQL and PostgreSQL. Optimization of database indexes: Database indexes are an important factor in improving query performance. Indexes can speed up data search and reduce query scanning time.
