469,081 Members | 1,803 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,081 developers. It's quick & easy.

two-way replication

I have set-up a two-way replication for two of our servers, it is for
redundancy only so only one server will be used at any one time.

I noticed that you cannot use auto-increment columns with this sort of
set-up.

What method do others use to get unique ID's in this sort of set-up?

I was thinking of using timestamp with a random number 1-99 added to the
end. But then I suppose it is possible to get a match (more chance of
winning the Lottery though).
Jul 20 '05 #1
0 981

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Jamey Cribbs | last post: by
8 posts views Thread by John Grenier | last post: by
6 posts views Thread by Laura K | last post: by
8 posts views Thread by Michael Schwarz | last post: by
13 posts views Thread by paul.joseph.davis | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.