Re: Replication and Table Design

> When record are inserted, each record is given the nextval sequence
> number as it's rec_id - so far, so good. I now need to create both an
> east-coast and west-coast version to provide better data locality - my
> question is: If I apply "loose consistency", that is , asynchronous
> replication of the data (each coast can receive new records for
> insertion in the database) - how can I keep the data synchronized
> properly?

1. Give the East coast a sequence that ranges from 0-499999 and the Left coast a sequence that ranges from 500000-999999?
   • or -
2. Have the sequence generated by a third server in Kansas ;)