jvandenbroek
Verified User
First note that using MyDNS is not a slam-dunk; you'd have to run some kind of system to import information from the MySQL zone files DA maintaines, and then you'd have to run replication to get the information over to the slaves.
When we tried MySQL replication (about a half year ago) we were successful in local networks but not across the Internet; it worked for a while, but usually failed within less than an hour. We discussed the issue with the author of the replication howto we found on the 'net (he's considered somewhat of an expert on replication) and he offered to help us for money, but he also wrote that replication was not designed to work over the 'net and probably wouldn't.
That's a wide open statement. How? using MyDNS instead of BIND? BIND is the most popular DNS server on the 'net; much of the 'net runs on BIND. And while BIND doesn't directly support copying of zone names between masters and slaves, it supports zone import, which MyDNS does not; with MyDNS you've got to either get replication to work, or find some other way to replicate the databases on a continuous basis.
Neither MyDNS nor djbdns/tinydns (Dan Bernstein's suite) follow the RFCs as well as BIND, and continued study has made up my mind; we'll stick with BIND .
Jeff
I really don't have any problems with MySQL replication over WAN -- one of the slave replicators is located in Germany (master and other slave are in the Netherlands) and every dns update gets almost instantly replicated. And even if you've got unstable, disconnecting connections, the replicator should (default) retry every 60 seconds to reconnect. Which version(s) of MySQL did you test? Though I don't want to convince you, you should know it can actually work great