Hi all,
We are developing Silverlight application (version 2.0 Silverlight API) that has few editable layers. RDBMS for SDE is SQL Server 2008. Users would be editing both geometries and attributes of the editable layers.
We want to have Failover clustering setup so that if primary server fails, requests are routed to the secondary server. We have planned creating replica of our primary SDE database on the secondary server.
Now the issue is, at this point of time, I cannot have clear picture of how synchronization between replicas should take place. I would try to explain the issue by following scenario.
Assume that primary server is online and user has done some changes by editing some parcels. He saves changes to database. Now, my secondary DB server also needs to be updated accordingly. Because at this very moment, if primary server goes offline and replicas are not synchronized, next users would not be looking at the latest data.
So does this mean that after every save to DB of primary database( by editing features in web application), I would have to synchronize changes? If yes, can this be done by ArcObjects API? Would it put too much load on network?
Can anybody please let me know how I should plan my replication and synchronization? Any help would be much appreciated.
Regards,
Supriya.
