PowerDNS Backend¶

PowerDNS Configuration¶

You need to configure PowerDNS to use the MySQL backend.

1. First enable the MySQL backend:

launch = gmysql

2. Configure the MySQL database settings:

gmysql-host=<host>
gmysql-port=
gmysql-dbname=<dbname>
gmysql-user=<username>
gmysql-password=<password>
gmysql-dnssec=yes
#gmysql-socket=<socket path>

3. Configure the PowerDNS Backend using this sample target snippet

  targets:
    - type: powerdns
      description: PowerDNS Database Cluster

      # List out the designate-mdns servers from which PowerDNS servers should
      # request zone transfers (AXFRs) from.
      masters:
        - host: 192.0.2.1
          port: 5354

      # PowerDNS Configuration options
      options:
        host: 192.0.2.1
        port: 53
        # connects and logs in to the PowerDNS database designate_pdns
        connection: 'mysql+pymysql://designate:password@127.0.0.1/designate_pdns?charset=utf8'

4. Then update the pools in designate

$ designate-manage pool update

See designate-manage pool for further details on the designate-manage pool command, and DNS Server Pools for information about the yaml file syntax

4. Setup the database schema.

$ designate-manage powerdns sync <pool_id>

See designate-manage powerdns for further details on the designate-manage powerdns command

5. Restart PowerDNS and it should be ready to serve queries using the MySQL database as the backing store.