<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
pre
{margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.EmailStyle17
{font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I am a newbie to PowerDNS so bear with me. I am working on
setting up two name servers, one as a master and one as a slave that will
handle DNS for a potentially large number of domains. I’m not quite sure
on the topology for the setup.</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<pre><font size=2 color=black face="Courier New"><span style='font-size:10.0pt'> </span></font><font
color=black face=Arial><span style='font-family:Arial;color:windowtext'>If I understand correctly the recommended way of setting up a master and slave boxes is to have the master and slave connect to separate mysql backend servers with the master connecting to a primary mysql box and the slave connected to a second mysql box that is using mysql replication? If this is the case then I assume that I don’t need to configure master=yes and slave=yes on the respective DNS boxes and any insert queries for a new domain would be:</span></font></pre><pre><a
name=AEN3047><font size=2 color=black face=Arial><span style='font-size:10.0pt;
font-family:Arial;color:windowtext'> </span></font></a></pre><pre><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:windowtext'>insert into domains (name,type) values ('powerdns.com','NATIVE') </span></font></pre><pre><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:windowtext'> </span></font></pre><pre><font size=2 color=black
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:windowtext'>which will of course be replicated on the respective mysql box. Is this correct?</span></font></pre><pre><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:windowtext'> </span></font></pre><pre><font size=2 color=black
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:windowtext'>--------------</span></font></pre>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>
If I wanted to configure the more traditional master/slave setup using serial
numbers do I still need two separate database backends for each nameserver? If
so then on the mysql box that the master uses you do an insert on its database
like so for a new domain:</span></font></p>
<pre><a name=AEN3065><font size=2 color=black face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:windowtext'>insert into domains (name,type) values ('powerdns.com','MASTER');</span></font></a></pre><pre><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:windowtext'> </span></font></pre><pre><font size=2 color=black
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:windowtext'>while on the database server that the slave uses the insert statement would be:</span></font></pre><pre><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:windowtext'>insert into domains (name,master,type) values ('powerdns.com','213.244.168.217','SLAVE');</span></font></pre><pre><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:windowtext'> </span></font></pre><pre><font size=2 color=black
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:windowtext'>Is this correct? Then we can use serial numbers etc. According to the docs, by simply updating the serial number on a postgres backend will notify the slaves, is this true for mysql as well?</span></font></pre>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Thanks</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoAutoSig><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>G. White </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoAutoSig><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
</div>
</body>
</html>