-
We have Master-Master replication setup and our database contains a couple of sequences. When I tried to replicate them, it gave me an error. I looked at the replication API document, it did not list "sequences" as one of the currently supported features in replication.
Can you suggest me a good way to solve this ? We just have two databases being Master-Master replicated.
Thanks a lot for your help.
-
OAR does not support Sequences in replication. One way to approach this is to have each site generate a globally unique sequence. for Example, Node A's sequences start with 1 and increment by 2 (All Odds) and Node B's sequences start with 2 and increment by 2 (all Even).
Hope that helps...
-
Thanks a lot for the good solution.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|