Replication of generators
Submitted by admin on Fri, 2006-04-28 10:47.
Q: Replicator is not updating the generators.
Is there something that I need do to make this happen?
A: It's not logical replicate generator unless is target database strict read-only switchable as source database only if all data are correctly replicated. You should use generator only if source an target generator value are equal otherwise it causes inconsistency. I preffer using multi-field key (site_id, generated_id) or assign range of possible generator values for each site (1..1000000, 1000001..2000000, etc.). You can also use GUID ids but it causes records highly unreadable.
A: It's not logical replicate generator unless is target database strict read-only switchable as source database only if all data are correctly replicated. You should use generator only if source an target generator value are equal otherwise it causes inconsistency. I preffer using multi-field key (site_id, generated_id) or assign range of possible generator values for each site (1..1000000, 1000001..2000000, etc.). You can also use GUID ids but it causes records highly unreadable.