Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Replication / August 2003

Tip: Looking for answers? Try searching our database.

Replica Farms ... a few thoughts and questions

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JD Kronicz - 27 Aug 2003 20:55 GMT
I set up a test replica farm today based on what I read on Michael
Kaplan's Trigeminal site (www.trigeminal.com).

I created three replica's for the farm and have them all managed by
the same sychronizer.  They are set up to replicate every 15 minutes
which seems to be the shortest interval allowed by Replication
Manager.  The hub is located in a directory called Hub on a server and
the farm relicas are named Farm Replica 1, Farm Replica 2 and Farm
Replica 3.  I also set up a replica on another machine called Remote
Replica 1.  This replica is managed by its own synchonizer.  (Question
- can more than one synchronizer run on a given machine?).  Remote
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
watched to see what happened.  When the time came for the
sychronization of Remote Replica 1 and the farm synchronizer came and
passed I observed the following.  Farm Relica 1 contained the new
record while the other two farm relicas did not.  So apparently the
farm synchronizer selected farm relica 1 for the sychronization with
Remote Replica 1.  I continued to wait to see what would happen when
the farm synchronizer synchronized its internal members.  When the
time came and passed I observed that now Farm Replica 2 also had the
new record but that Farm Replica 3 still did not.  Upon reviewing the
synchronization log what appeared to have happened during the
sychronization of the farm synchronizer's managed replicas was as
follows:
Farm Replica 2 synchronized with Farm Replica 3
Farm Replica 2 synchronized with Farm Replica 1

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
for remote replicas since they would presumably be sychronizing with
the farm less frequently.

Another observation - The managed replicas of a given synchronizer
synchronize with each other in a direct manner.  There doesn't appear
to be an option to have them synchronize in a indirect fashion.  This
may seem like a silly observation to those who have some substantial
experience in this area but the reason it stood out to me was as
follows.  I thought one of the advantages of indirect synchronizations
was that they can minimize corruption problems.  Further, I thought
the likelyhood of corruption problems was related to multiple
databases being open and communicating with each other at the same
time as opposed to passing notes in drop boxes.  Thus, the question
that I have is ... with multiple replicas in a farm doing frequent
direct synchronizations with each other ... isn't there an increased
chance for corruption?

Yet another observation - I installed replication manager on my
machine.  I confurged the synchronizer to manage the replica farm
which was residing on the server.  Bottom line is that I don't need to
install Replication Manager on the server ( which in my opinion is a
good thing since the less I have to rely on a business IT folks to get
things done the better (not that I have anything against IT folks in
general you understand :)

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?

What type of regular maintainence is required with manageing the farm?

Thanks in advance for your thoughts - JDK
Jack MacDonald - 28 Aug 2003 05:13 GMT
>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
>.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.