Is it possible to have 1 database that is synced between two servers in two different locations?
The reason I bring this up is because currently we have a server that hosts our database and client computers access on a local network. We also have computers that access through VPN but in several different areas around the world. The problem with this is that some of the computers have a very slow connection. I was hoping to have 2 different servers that sync the same database between each in realtime or close to realtime.
The idea would be to have 1 server in California (all clients in the U.S. connect to this server). The other server in London (all client computers in that area connect to that server). The California and London servers are synced and pass information between each in realtime. So any updates on the California server would be sent to the London server and vise versa.
for synchronization, ACT uses a publisher subscriber model. You can only have one publisher but you can have many subscribers. If in your example, the only two places that have ACT datbases are the 2 servers you reference, you would be just fine. Just put the master database on 1 server and set up synchronization. If the master is in California, London would get a subscriber database. You can share either database out for office users in either location. If you have remote users also needing to sync, you would create a remote from the master. So additional remote users, even if they are in London, would still sync to California.
