Hi All,
Our project consists of two Webservers and two database servers for providing high availability in India. We have some users in US,they will access some large size files, review them then submit the page through our web application. Since our files are available in SAN storage located in India, it is taking too much time to open while accessing them from US. As files and documents plays a major role in our application, we decided to have two Webservers, two database servers, and separate SAN storage in US. Then We will enable Geo Load balancing, so that the http request will hit appropriate webservers based on geo graphical location. Now this setup seems fine. But we are facing issues for replicating database between servers located in India and US, and replicating files between SAN storage located in India and US. We tried SQL Server Merge Replication for database synchronization and Goodsync for Files synchronization. Both are not supporting properly. We have window services hosted in India, that will generate files based on the changes happened in database. Since merge replication is too slow and it is not replicating changes as sets, files are getting generated with partial data, results wrong documents. Can you please advise me the best solution for this issue?
What I have tried:
Merge Replication for Database Syncing, Goodsync for files syncing
Submit an article or tip