Joe,
Replication is pretty much instantaneous (depending on network speed),
since the servers communicate using the binary log files. Having said that,
there is no replication scheme for any database product that can guarantee
(over asynchronous replication) that some data won't be lost or mangled in
the event of a true problem. If you are looking for this type of
replication, you have to go to hardware and synchronous networks (the
connection between the boxes is as fast as the local changes). Since this
is a MySQL list, you probably aren't interested in huge EMC Symmetrix system
doing your replication ;) To deal with the recovery process after the
"fall" simply take the data directory from the surviving slave and migrate
it to the master, restart the replication and off you go. Please note that
this applies to current versions of MySQL (3.2x) and is changing the new
(4.x) tree.
Scott Helms
----- Original Message -----
From: "Joe Bifano" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 28, 2002 5:54 PM
Subject: MYSQL REPLICATION
> I am trying to configure mysql for redundancy using replication and the
> built-in mysql master/slave configuration. What I don't understand, even
> after much reading, is how to recover from a failure. If host B is slave
to
> host A, and A goes down, B could then be manually or automatically
> configured to be master itself, and thus take over A's role completely.
> However, if B was not completely caught up from A before the failure took
> place, then once A was back up the two would be out of sync, and A could
> contain data B did not, and B would undoubtedly contain data A did not.
How
> do you avoid this situation or re-sync the two after a failure like this?
>
> I'm finding it difficult to locate a concise and cohesive method to create
a
> redundant database system using mysql. Any other resources or references
> would be heartily appreciated.
>
> Joe
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
