Books or Articles on Replication Strategy

Thread View: borland.public.interbase.replication

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Rick Long Fri, 23 Dec 2005 21:04

#80

Author: Rick Long
Date: Fri, 23 Dec 2005 21:04

7 lines
1173 bytes

If anyone has books or an Internet article that discusses replication 
strategy, I would appreciate a reference.

We are starting our first replication project and would like to learn 
best practices before we experience "what not to do".
Example: How to allow users in two locations to add new Orders where the 
Order number needs to be unique?

Re: Books or Articles on Replication Strategy

#81

Author: Robert Schieck TeamB
Date: Sat, 24 Dec 2005 12:00

23 lines
1572 bytes

Rick Long wrote:

> We are starting our first replication project and would like to learn
> best practices before we experience "what not to do".  Example: How
> to allow users in two locations to add new Orders where the Order
> number needs to be unique?

One way is to have a unique identifer stored in eache server that is
used in the primary key  to make sure what comes out is unique....

If you only have a few machines, 'a' ,'b', 'c' works....

Another less  secure way  is to partition the "numers" amongst the
machines. Server 1 starts uses 0 to 100 for keys, server 2 uses 200 to
300 etc. Of course you can expand the ranges but there is a chance of
overlap if one server creates too many records and goes byond its range.

hth

-- 
Rob Schieck
TeamB

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads