>I set up a test replica farm today based on what I read on Michael
>Kaplan's Trigeminal site (www.trigeminal.com).
>Replica 1. This replica is managed by its own synchonizer. (Question
>- can more than one synchronizer run on a given machine?). Remote
No. One synchronizer per machine.
>Replica 1 was set up to replicate with the sychronizer managing the
>farm every hour. I added a record to Remote Replica 1 and then
[quoted text clipped - 4 lines]
>farm synchronizer selected farm relica 1 for the sychronization with
>Remote Replica 1. I continued to wait to see what would happen when
The synchronizer will always pick *one* of the replicas. You cannot
predict which one it will be, although in my experience it stays with
the same one until something perturbs the system.
>Thus, the new record was not transferred to Farm Replica 3 during this
>process. During the next synchronization of the farm synchronizer's
>managed replicas the added record will be propagated to Farm Replica
>3. So .. bottom line is that it appears that there can be some lag in
>the propagation of updated or new data among farm members .. not a
>problem .. just an observation. This lag can be substantially longer
correct. IIRC, you can control the schedule of the locally-managed
replicas and make it more frequent than the default one hour.
>for remote replicas since they would presumably be sychronizing with
>the farm less frequently.
They will be current after they synchronize -- however often you
choose to do that...
>Another observation - The managed replicas of a given synchronizer
>synchronize with each other in a direct manner. There doesn't appear
[quoted text clipped - 3 lines]
>follows. I thought one of the advantages of indirect synchronizations
>was that they can minimize corruption problems. Further, I thought
Indirect synchronization minimizes corruption problems **over
unreliable connections** (e.g. WAN). Having all the farm replicas on a
single disk is about as reliable as you can get. Therefore, direct
sync is appropriate.
>the likelyhood of corruption problems was related to multiple
>databases being open and communicating with each other at the same
[quoted text clipped - 10 lines]
>things done the better (not that I have anything against IT folks in
>general you understand :)
Bad choice. the synchronizer and the replicas that it manages should
be on a single machine for maximum reliability.
I understand your motivation, but don't do it...
>One other question related to problems that can occur with farm
>replicas and how they are corrected. What types of problems can the
>internal direct synchronizations fix automatically and what types of
>problems can't they fix. What types of data loss can take place? Is
>it possible to set up the system so that no data loss will take place
>or at least so it's obvious when data loss took place?
If the communication link goes bad during the indirect sync, the
replica in the farm will be marked as "unreachable", therefore, will
not participate in further indirect synchronizations. The synchronizer
will automatically choose another one from the same farm. Later, when
the synchronizer does its "synchronize local replicas" update (i.e. a
direct synch), it *will* be able to communicate with the "unreachable"
replica, and will restore its status to "reachable". If the farm was
just a single replica, this type of self-healing could not occur.
>What type of regular maintainence is required with manageing the farm?
>
>Thanks in advance for your thoughts - JDK
=======================================================
Jack MacDonald
remove UPPERCASE LETTERS from email address
Vancouver, B.C. Canada
Info about MSAccess user-level security
www.geocities.com/jacksonmacd
JD Kronicz - 28 Aug 2003 15:43 GMT
Thanks again for your clarifications.
>-----Original Message-----
>
[quoted text clipped - 95 lines]
>www.geocities.com/jacksonmacd
>.
JD Kronicz - 28 Aug 2003 15:50 GMT
I forgot one follow up question.
In regards to putting the synchronizer on the machine with
the farm (in this case a server machine) I guess I can
understand the rationale there. What is seems to mean ...
is that I will need to approach the IT people to install
Replication Manager on the server (not sure how they will
feel about that) and then describe to them how to
configure it (that will be fun). I am also not sure how
much they will like having a synchronizer running in the
background all the time. Do you have any experiences
along this line? Am I thinking about this correctly? Is
there any way I can manage the sychronizer on the server
from a client machine? I was even thinking about putting
the farm and synchronizer on a client share. This may put
a performance hit on the client machine (not sure how
big). Is this a bad idea?
Thanks again.
>-----Original Message-----
>
[quoted text clipped - 95 lines]
>www.geocities.com/jacksonmacd
>.