[Pdns-users] MySQL Replication

[Richard Mayhew - Nashua Broadband]

Hi,

Great, Thanks. I'll stick with the default and do a little more work on
learning the replication process of InnoDB...

Regards
Richard

-----Original Message-----
From: Norbert Sendetzky [mailto:norbert at linuxnetworks.de] 
Sent: 05 May 2006 10:38 AM
To: pdns-users at mailman.powerdns.com
Cc: Richard Mayhew - Nashua Broadband
Subject: Re: [Pdns-users] MySQL Replication

On Friday 05 May 2006 10:29, Richard Mayhew - Nashua Broadband wrote:
> Looking at the default table setup for PowerDNS, the type of DB is 
> InnoDB.
>
> What would be the downfall, if any, be of converting the tables to 
> MyISAM and using this type for the DB replication. Would it be a 
> better option?

Your domain will be either not existing anymore or incomplete (entries
are
missing) if something goes wrong while doing an AXFR from the master
server.

You might do this if you are using PowerDNS only as master but I don't
recommend that especially because it's not a problem any more to
replicate and backup InnoDB tables.


Norbert
--
OpenPGP public key
http://www.linuxnetworks.de/norbert.pubkey.asc