02-22-2013 02:30 AM
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.
Would this be possible on Act! Premium 2011?
02-22-2013 07:54 AM
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.
02-22-2013 01:06 PM
Thanks for the input!
So if im understanding correctly, the Main Server (CA) would sync to the Server (london). Is sync realtime, or can times be set?
Once the London server syncs with the CA server, then users could remotely/locally use either server?
Is there a knowledgebase category on how to set this up?
02-26-2013 09:26 PM
with ACT, users can sync by pressing a button or by using the ACT Scheduler to schedule the sync. it can go up to once an hour.
02-26-2013 09:37 PM
I actually have another questions now. Is synchronization only one way, or does it sync both ways:
CA (Server) -> London (Server)
CA (Server) <->London (Server)
So if information is put on the London server, will it send it back to the CA server and vise versa?