July 28, 2008 at 10:44 am
We have one SS2K5 server used for our corporate intranet. Changes to the data on this server (product availablity, etc) are replicated to our SS2K5 eCommerce server. The majority of the tables are download only, however the tables used for customer orders (account info, shopping cart, etc) use merge replication.
Currently the identity increment for the merge replicated tables is set to 1 and the identity seed on the eCommerce server is set to give the intranet server a space for 100K records (which is more than enough since the inserts for these tables are performed on the eCommerce server).
The problem we are running into is that we need to add a second SS2K5 eCommerce server, which will be load balanced with the other eCommerce server.
How do we go about setting up the replication for this scenario?
Is it possible to just set the identity increment value on the eCommerce servers to 2?
What happens when we need to add yet another SS2K5 eCommerce server? We would like to avoid the whole negative identities approach if possible as this is the customer's invoice number.
July 31, 2008 at 4:24 am
Using an increment of 2 won't help you, because you will still get conflicting id's. You could use different seed values lie 1 on serverA and 2 on ServerB and then an increment of 2. So on server would only generate ven numbers while the other generates the odd numbers. But as you said your self, what if you want to add another server.
So the better solution is defining ID ranges for each server. Like server A can genarate ID's 1 - 100000 and server B from 100001 to 200000 etc.
This article should hep you further:
http://www.sqlservercentral.com/articles/Replication/mergereplicationmanualrangehandling/1667/
[font="Verdana"]Markus Bohse[/font]
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply