sync two mysql db

[chrislive]

Hi everyone,

I have 2 DNS servers (primary/secondary) that use MySQL as a back end. The concern that I have is that the data within my get out of sync.

I would like to have both databases exactly the same at all times. What I invision is that I would update the Primary DB and it would then automatically (or even manually by clicking update secondary dns) i would be able to export the entire DB structure and import into the second DB.

I guess what would be nice would be to have two options.

Migrate Primary DNS to Secondary DNS
Migrate Secondary DNS to Primary DNS

That way I could choose.

Any suggestions on how to start this project? I have looked around the net and couldnt find any software to do this (open source anyways)

Thanks
Chris

[Roger_Ramjet]

You are talking about replication in mysql and it is too big a subject to answer in a forum, Read tha manual and have a go. Post here when you run into trouble.

MySQL as DNS server, interesting.