Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


PowerDNS Setups
New on LowEndTalk? Please Register and read our Community Rules.

All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.

PowerDNS Setups

Hi guys,

I'm thinking of setting up PowerDNS to handle my DNS. Possibly a master / slave with a MySQL backend.

Any advice on this?

I've got 2x 768MB RAM VP's that I'll most likely use for this purpose. Any tips / tricks / etc I should know.

Lastly if you have any guides on setting this up in Ubuntu - then please let me know. Yes Yes I can find tons of old guides, but these are perhaps not current and someone here may know better etc.

Thanks,

Comments

  • mikegmikeg Member

    Howtoforge have good guides on this:

    http://www.howtoforge.com/installing-powerdns-with-mysql-backend-and-poweradmin-on-ubuntu-9.10

    This guide shows you how to also setup poweradmin too, a front end for administering powerdns.

    Are you planning master-to-master replication between your dns servers?

  • A while ago, I run this setup with 2x 512MB ram VPS, one from RAMNODE and another one from DigitalOcean. Everything worked great. Later, I simply decided to host my dns with DnsMadeEasy. :-)

    I used several tutorials to get it working. Many tutorials had a very important step missing. Export the current db you want to duplicate from the master mysql db and then import it into your mysql slave db.

    The actual mysql synch. configuration is in between "# begin replication setting" and "# end replication setting".

    Both servers were running mysql 5.5.x.

    'Master my.cnf

    # bind-address = 0.0.0.0
    [mysqld]
    # begin replication setting
    server-id               = 1
    log-bin                 = mysql-bin
    log-bin-index           = mysql-bin.index
    expire-logs-days        = 10
    max-binlog-size         = 100M
    binlog-do-db            = powerdns
    
    innodb_flush_log_at_trx_commit=1
    sync_binlog=1
    
    # end replication setting
    port=3306
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    # by gio
    # skip-innodb
    interactive_timeout=150
    wait_timeout=20
    # below setting from http://www.cyberciti.biz/tips/enable-the-query-cache-in-mysql-to-improve-performance.html
    # 131072=128mb 
    query_cache_size=1M
    query_cache_type=1
    query_cache_limit=1M
    # settings for a 256mb server
    key_buffer_size = 128K
    max_allowed_packet = 1M
    thread_stack = 64K
    thread_cache_size = 4
    sort_buffer_size = 64K
    net_buffer_length = 2K
    tmp_table_size = 24M
    max_heap_table_size = 24M
    # end settings for a 256mb server
    # Disabling symbolic-links is recommended to prevent assorted security risks
    symbolic-links=0
    
    # Settings user and group are ignored when systemd is used (fedora >= 15).
    # If you need to run mysqld under a different user or group,
    # customize your systemd unit file for mysqld according to the
    # instructions in http://fedoraproject.org/wiki/Systemd
    user=mysql
    
    # Semisynchronous Replication
    # http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html
    # uncomment next line on MASTER
    ;plugin-load=rpl_semi_sync_master=semisync_master.so
    # uncomment next line on SLAVE
    ;plugin-load=rpl_semi_sync_slave=semisync_slave.so
    
    # Others options for Semisynchronous Replication
    ;rpl_semi_sync_master_enabled=1
    ;rpl_semi_sync_master_timeout=10
    ;rpl_semi_sync_slave_enabled=1
    
    # http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html
    ;performance_schema
    
    
    [mysqld_safe]
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    

    'Slave my.cnf

    [mysqld]
    port=3306
    # begin replication begins
    read-only
    server-id = 2
    # didn't work - master-connect-retry = 60
    relay-log = slave-relay-bin
    relay-log-index = slave-relay-bin.index
    replicate-do-db = powerdns
    # end mysql replication
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    
    # Disabling symbolic-links is recommended to prevent assorted security risks
    symbolic-links=0
    
    # Settings user and group are ignored when systemd is used (fedora >= 15).
    # If you need to run mysqld under a different user or group,
    # customize your systemd unit file for mysqld according to the
    # instructions in http://fedoraproject.org/wiki/Systemd
    user=mysql
    
    # Semisynchronous Replication
    # http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html
    # uncomment next line on MASTER
    ;plugin-load=rpl_semi_sync_master=semisync_master.so
    # uncomment next line on SLAVE
    ;plugin-load=rpl_semi_sync_slave=semisync_slave.so
    
    # Others options for Semisynchronous Replication
    ;rpl_semi_sync_master_enabled=1
    ;rpl_semi_sync_master_timeout=10
    ;rpl_semi_sync_slave_enabled=1
    
    # http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html
    ;performance_schema
    
    
    [mysqld_safe]
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    
Sign In or Register to comment.