[Pdns-users] MySQL Multi-Master configuration?

[Jon Davis]

I just wanted to kick in my 2 cents.  I run about 50 domains for my company
off a PDNS/MySQL setup on 5 geographically diverse servers (OpenVPN
connecting them). We skipped the multi-master simply because (for us) the
records aren't changing that much.  If the master goes down, big whoop, we
loose a single name server (Because the master DB is also a name server)...
the other 4 slaves (slash name servers) will keep running and keep serving.

You have to screw up purdy bad to break it. The only major concerns I have
are replication failing. openvpn failing (and replication failing)... but
the biggest concern is user error (IE "update `records` set content='1.2.3'
where 1"... whoops).

-Jon

On Thu, Sep 15, 2011 at 21:12, Johannes Ernst <johannes.ernst at gmail.com>wrote:

> I'm thinking of setting up a multi-master MySQL backend, where the masters
> are geographically distributed and run a local instance of PowerDNS each.
>
> The theory is that it would provide HA, and also allow more than one name
> server for my domain, e.g.
>        ns1.example.com
>        ns2.example.com
> and the master-master replication would make sure they stay consistent.
>
> I could put a PowerAdmin at http://ns1.example.com/ and
> https://ns2.example.com/, and using either would be equivalent.
>
> I have not been able to find any usable information on this setup. So my
> question is whether this idea sounds sane, and what the obvious pitfalls
> might be? Experience from anybody with a setup in any way comparable would
> be very helpful …
>
> Thanks,
>
>
>
> Johannes
>
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> http://mailman.powerdns.com/mailman/listinfo/pdns-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20110917/eaa80664/attachment-0001.html>