[Pdns-users] [Fwd: Re: Reliable supermaster setup - howto?]

[Przemyslaw Wegrzyn]

Jesse Angell wrote:
> I am using MySQL for both my master and my slave.  I played with MySQL replication some but it just seemed over-kill for what I needed (I have a huge MySQL replicated environment for my web stuff).  I ended up just writing a simple script on the master that would do a mysqldump.  It would keep track of the checksum of the last dump and if it changed it would scp that mysqldump to the slave and restore it.
>
> Runs every minute from cron...works great.  Ghetto -- but simple and trouble-free :)
>   
Isn't it amazing, that there is no out-of-the-box solution for such a
common task? Everybody seem to use some homebrewed solution.
I had some idea as well - make a python or perl script listening on a
socket (or spawned from inetd). Client side would connect and send last
update time (or counter, whatever), server would answer with set of
changed data, which the client would import into its local database. All
cron'ed.

Basically, there are many solutions, and none of theme is rocket
science, but I just don't want to reinvent the wheel. I'm probably going
to try PostgreSQL + Slony, simply because it is just ready and needs
configuring only. And because I've never used Slony before :)

Cheers,
Przemek