[BNM] rsync over ftp

[Karim Ahmed]

Hi Tom,

My experience of mysql replication is that it happens "instantly" and rsync
uses a very efficient algorithm to find out what changed so should also
provide near live replication especially when running as a daemon but (as
always) best to suck it and see! I have set up mysql db replication in both
directions and it worked well; you do have to configure the servers so that
one creates odd primary keys and the other even keys.

I think the DNS changes should happen in max 10 minutes. I'm guessing you
will have a monitoring server watching the live server and if it can't see
it, connects to the DNS server and amends the IP to mirror then back again
when live appears. is that how you would do it?

K
On Fri, Dec 5, 2008 at 5:59 PM, Tom Coady <tom.coady at gmail.com> wrote:

> On Fri, Dec 5, 2008 at 5:39 PM, Alessandro De Maria <
> alessandro.demaria at gmail.com> wrote:
>
> > Hi Tom, can you explain what you want to achieve in more details?
>
>
> Thanks Karim & Alessandro
>
> I guess if I could formulate a coherent question it would be a good start.
>
> Your pointers to rsync & mysql replication are in the right direction but
> don't seem to address my imaginary solution of a standby host with a
> reasonably up to date database which the dns can point to in case of
> failover. Maybe this has never been considered as it would take too long
> for
> the dns changes to propogate?
> --
>
> BNM Subscribe/Unsubscribe:
> http://www.brightonnewmedia.org/options/bnmlist
>
> BNM powered by Wessex Networks:
> http://www.wessexnetworks.com
>