Community
Showing results for 
Search instead for 
Do you mean 
Reply

1 Database synced between 2 servers

New Member
Posts: 5
Country: United States

1 Database synced between 2 servers

Hey Everyone,

 

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?

 

Thanks,

 

Eric

 

 

Silver Contributor
Posts: 1,813
Country: USA

Re: 1 Database synced between 2 servers

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.

Test Drive Act! and Quickbooks over Citrix http://GoTryAct.com

Jon Klubnik| ActTrainer.com
(866)710 4228

ACT! Certified Consultant / ACT! Premier Trainer / ACT! Hosting Provider

New Member
Posts: 5
Country: United States

Re: 1 Database synced between 2 servers

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?

 

Thanks!

 

Eric

Silver Contributor
Posts: 1,813
Country: USA

Re: 1 Database synced between 2 servers

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.

 

How To Use the Sage ACT! Network Synchronization Service Across the Internet

 

 

Test Drive Act! and Quickbooks over Citrix http://GoTryAct.com

Jon Klubnik| ActTrainer.com
(866)710 4228

ACT! Certified Consultant / ACT! Premier Trainer / ACT! Hosting Provider

New Member
Posts: 5
Country: United States

Re: 1 Database synced between 2 servers

I actually have another questions now. Is synchronization only one way, or does it sync both ways:

 

CA (Server) -> London (Server)

 

or

 

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?

Platinum Super Contributor
Posts: 5,275
Country: USA

Re: 1 Database synced between 2 servers

Synchronization is a 2-way process.
Greg Martin
Sage